I have a windows form that I am populating from a MS Access database using a datatable. I am able to get the data from the database and populate the gridview without any problems.
The question I have is I need to save the changes that the user makes to the Gridview back to the database. I know that all I have to do is update the dataadapter. My issue is that all of the records in the gridview are sub-records of the main record that is appearing on the form. When I save the record I need to be able to assign the master Rec_ID number to a ID column for each record in the gridview datatable. I also want to assign the row number to the Row_ID column in the datatable so that the records always appear in the same row. How can I update these two values (Rec_ID & Row_ID) when saving the data table?