how to update data into Access DB?  
Author Message
nictan





PostPosted: Visual C# Express Edition, how to update data into Access DB? Top

I have manage to create the insert data into the Access DB but if i wish to make a update on the DB how can i do it



Visual Studio Express Editions20  
 
 
ahmedilyas





PostPosted: Visual C# Express Edition, how to update data into Access DB? Top

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