data adapter does not update

Question

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.

Answer 1

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.

Answer 2

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.

Answer 3

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.