Our Training Programs

All contents are copyright of their authors.

Saving data from datagridview to database sql server

Saving data from datagridview to database sql server

Ahmed El Hamdi

11yAsked Apr 14, 2015, 3:53 PM2.3kWindows Forms

Hey,

Im using visual studio 2010.

I have an application based on winforms.

Im using c#, i have a datagridview wich is loaded with data from a table (sql server database 2008).

I want to ask how could I detect if there is a modification in datagrid and save the modification to the table in my databse!

like and update, insert and delete operation !

thank you

here is my mail : [email protected] (cuz im login with facebook account here)

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Manoj Bhoir11y ago
Hi, you can use DataGridView events to perform your insert, update and delete operations.

Please check this :
http://www.codeproject.com/Articles/12846/Auto-Saving-DataGridView-Rows-to-a-SQL-Server-Data
http://www.c-sharpcorner.com/UploadFile/rohatash/insert-edit-update-and-delete-data-with-datagridview-in-wi/
ramya bharath11y ago
http://www.c-sharpcorner.com/uploadfile/kannagoud/insertupdatedelete-in-datagridview-using-linq-in-windows-forms/
Hope it helps