I have Purchase Order Header and Line items in a Master-details format in a form
The line items are updated in a DataGrid and the header fields are "form" controls [like text boxes, date control, combobox etc]
The primary key is a GUID field. When the user clicks on "Save", I do the following to generate a GUID value
If String.IsNullOrEmpty(Me.GlobalIDTextBox.Text) Then
Me.GlobalIDTextBox.Text = System.Guid.NewGuid.ToString
End If
Once the header is updated, I enter line item details in the grid and clicked on "Save" again. That saves the record in the database [so far so good]
Now, If I start entering valu in the grid [without saving the header first], I am getting a null value exception as the "Primary Key" is not yet saved against the header. I would like to be able to enter all the data in the "Data Grid" and the header and click on "Save" only once.
Questions:
How can I update the newly added Grid row with a Header GUID value so that it does not throw and error
Thanks
Visual Basic19
|