Dataset update doesn't work

Question

Hi to all ..... I have a problem on this code: this is sistattically correct but doesn't work. What i would like to do it's get data from a SQL server table , fill a dataset , modifiy and update the SQL table with a dataadapter. Maybe the error can be in the Update command statement... Can anyone give me a suggest ? Thank in advance George Here is the code i used: string strConn; strConn = "data source=MyDataSource;initial catalog=PTI;persist security info=False;user id=sa;workstation id=MyWksId;packet size=4096"; SqlConnection SqlConn = new SqlConnection(strConn); SqlConn.Open(); string strQry = "select * from mySQLtable"; SqlCommand cmd = new SqlCommand(strQry,SqlConn); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand=cmd; DataSet ds = new DataSet(); da.Fill(ds,"mySQLtable"); strQry = "Update mySQLtable set flag = 2"; cmd.CommandText = strQry; da.UpdateCommand=cmd; da.Update(ds,"mySQLtable"); SqlConn.Close();