CODEWITHSUNDEEP
c#
62071072SP
62071072SP

Reputation: 1935

Updating Datagridview values into database

I am developing an forms application where user can get tables data from database into gridviewcontrol which is editable so that user can update some data in the grid and when user clicks update buttonon the form the updated datagrid values should update in database. User can update more column values at a time. I am working on datagrids for the frist time and I managed to get data from databse and display in data grid but I am not able to update edited data back top database.

Upvotes: 5

Views: 29377

Answers (2)

Alex Kryvdyk
Alex Kryvdyk

Reputation: 317

Check the links below.

http://www.codeproject.com/Articles/12846/Auto-Saving-DataGridView-Rows-to-a-SQL-Server-Data

C# Issue: How do I save changes made in a DataGridView back to the DataTable used?

WinForms DataGridView - update database

C# WinForms - how to send updates from DataGridView to DataBase

Save changes in dataGridView

Upvotes: 8

isioutis
isioutis

Reputation: 324

If you are using a DataTable as a source to the DataGrid that shouldn't be so hard , you can get the changes in the DataTable using datatable.getchanges() // search for an example in getchanges()

and then update each row that has changed using the unique key ( i assume you have one ) of the row .

If you need to know how you update back to the database then you should check msdn for the exact method you have to use , depending of course on the one you used to load the data to the grid .

Upvotes: 3

Related Questions