I have a datagridview bound to a data table, via a data adapter. I am using the validating method of the dgv to update the data table. I now see that I need Insert and Update statements, tied to the data adapter.
The problem is that the data is already in the dgv, so how do I build the Insert/Update statements using the data which is already in the dgv? (the dgv has only two columns).