Updating Database Table with DataGridView
Posted on 2009-06-26
Hi, I'm using VB 2005, WinForms. I have a database Table we can call (UsersList). I have a DataTable called (dtUsers) in my code that works with a DataAdapter. Together they fill a DataGridView for me to display my list of Users. - That much works well.
I would like to allow my users to make changes (Edits) to the data that they see in the DataGridView. My problem is how do I execute the "Update" of changes back to the Table from the DataGridView. And have the DataGridView refresh itself.
In other words, if I do the following it does not work:
I would like to provide my users a button for them to click and be able to save any modifications made to the data they see in the DatGridView.
Thanks for your help,