data adapter does not update

eksypnos123

SqlConnection con=new SqlConnection("Data Source=real\\real;Initial Catalog=Northwind;Integrated Security=SSPI;"); string sql1="Select * from Employees"; SqlDataAdapter da=new SqlDataAdapter(sql1,con); SqlCommandBuilder cb=new SqlCommandBuilder(da); DataSet ds=new DataSet(); da.Fill(ds,"Employees"); ds.Tables[0].Rows[0]["LastName"]="Smith"; ds.AcceptChanges(); da.Update(ds,"Employees"); I execute the above simple code and yet the tables Employess from Nortwind database is not updated. I get no errors. I have followed the example from the documentation of SqlCommandBuilder.

3 Replies

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

aeroswan22y ago
yes,that's right. when you execute the acceptchanges method, the DataRow's RowState property will change from Added orModified to Unchanged. so DataAdapter will not get the changes.
0
eksypnos12322y ago
yep it works, thanks. it seems that the ds.AcceptChanges unmarks the rows that are modified, so the da soes nothing if it's called after.
0
aeroswan22y ago
i have encountered the same problem,and you can solve it by changing the sequence of the last two rows of codes. ......... ......... ds.Tables[0].Rows[0]["LastName"]="Smith"; da.Update(ds,"Employees"); ds.AcceptChanges(); i have tried it in oracle,and it works.
0