Question on Updating DB with a DataGrid..

[melegant]

I have an application that fills a datagrid using a datatable as the datasource.

Now, I would like for the user to be able to make changes to that datagrid, then when he/she is ready to hit a submit button and send the changes back to the DB.

The question is if this is possible and if it is..how?

Thanks

 

[quwiltw]

Yep. The easy way I think is to set up a DataAdapter (specifically, the InsertCommand/UpdateCommand/DeleteComand propertyies) and call its Update method passing in the datatable. There are numerous examples online for this.

 

[quwiltw]

Actually I just noticed Robby posted some sample code that looks appropriate to your question. You might want to check it out.
http://www.computerhelp.forum/showthread.php?s=&threadid=71636

 

[melegant]

Woop thanks..worked like a charm.....these boards are the best.

 

[me_again]

Excellent piece of code by Robby!

I spent the last week and a half surfing the net and searching for any sample code to do just this sort of thing.

Thanks Robby!