there are many ways.
if you are using an OleDbDataAdapter to fill the dataset, you can then also use the UPDATE() method in this, creating an UpdateCommand statement so when you call the Update() method, it will use the appropriate command to update the datasource (database)
http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbdataadapter.aspx
Above includes an example
or you could execute the OleDbCommand and giving it an update statement, the same way as shown in the above link
Does this help
|