SqlCommandBuilder not updating record in database

Fouzia Qureshi

private void btn_update_Click(object sender, EventArgs e){

try

{

conStr = @"--------------";

con = new SqlConnection(conStr);

con.Open();

string query = "Select * from tblProduct";

cmd = new SqlCommand(query, con);

sda = new SqlDataAdapter(cmd);

SqlCommandBuilder scb = new SqlCommandBuilder(sda);

sda.Update(tbl);

tbl.AcceptChanges();

con.Close();

MessageBox.Show("Data Updated :) ");

}

catch (Exception ex)

{

MessageBox.Show("error" + ex.Message);

}

3 Replies

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

Amit Gupta5y ago
@Fouzia

Just be generally aware the when you are using adapter.Update(tableName) , you must use the same object that you have used to fetch the query (i.e select statement).

It will not update back to the database, if you had re-initialized the adapter object.
Rajanikant Hawaldar5y ago
Refer below article that maight give you ideas to fix your issues.

https://www.c-sharpcorner.com/uploadfile/mahesh/commandbuilder-in-ado-net/
Sachin Singh5y ago
You have 2 mistakes , first you are not specifying the selectCommand of dataAdapter second you have no dataset so where are you exactly updating data?
please visit https://www.sharpencode.com/article/ADONET/dataset-and-sqldataadapter
private void btn_update_Click(object sender, EventArgs e){
try
{

using (SqlConnection con = new SqlConnection(cs))
            {
                SqlDataAdapter da = new SqlDataAdapter("select * from tblProduct", con);

                SqlCommandBuilder builder = new SqlCommandBuilder(da);
                da.Update((DataSet)Cache["ds"]); // here dataset contains updated data.
            }

MessageBox.Show("Data Updated :) ");
}
catch (Exception ex)
{
MessageBox.Show("error" + ex.Message);
}
}