DataSet Changes?
-
I have a DataSet that gets it's data from a stored procedure. I then use that dataset to populate a datagrid. When the user makes changes to the datagrid or adds new rows, how can I update the database table with the affected rows? Is there a way to tell which rows in a dataset have been changed or added?
-
I have a DataSet that gets it's data from a stored procedure. I then use that dataset to populate a datagrid. When the user makes changes to the datagrid or adds new rows, how can I update the database table with the affected rows? Is there a way to tell which rows in a dataset have been changed or added?
just use the update method of the adapter you used:
Adapter.Update(ds)
Just make sure you have created the commands neccesary for the operations (insert, delete, update) Nick Seng (the programmer formerly known as Notorious SMC)
God, I pity me! - Phoncible P. Bone
-
just use the update method of the adapter you used:
Adapter.Update(ds)
Just make sure you have created the commands neccesary for the operations (insert, delete, update) Nick Seng (the programmer formerly known as Notorious SMC)
God, I pity me! - Phoncible P. Bone