SqlCommandBuilder not updating database in C#

Question

I am using disconnected approchfor a form with 2 buttons, but unable to perform functionality of 1 button.
Search button will search products from tblProduct table and display in Datagridview. User can add edit or delete rows in Datagridview and update button will update the data in database.

Sachin Singh · Answer

You were not updating anything , i have updated your methods now test. the file is attached.

Sachin Singh · Answer

but where are you making changes in datagridview and loading the change into datatable? reload the datatable this time not from the database but with datagridview foreach (DataGridViewRow row in dgv.Rows) { DataRow dRow = dt.NewRow(); foreach (DataGridViewCell cell in row.Cells) { dRow[cell.ColumnIndex] = cell.Value; } dt.Rows.Add(dRow); } though your approach is not correct , instead of changing in datagrid change in datatable then bring the changes in datagrid. the update() method works on the changes made to the datatable and accordingly fires the T-Sql for any modified data update statement is fired behind the scene , it is decided by the row state property of datatable. in your case there is no change occuring in datatable so on Update() nothing will take place. please go through https://www.sharpencode.com/article/ADONET/dataset-and-sqldataadapter

SqlCommandBuilder not updating database in C#

Answers (2)