About DataAdapter.Update() please help me!!!

Question

--myda.Update(mysetmytable)--(error) errors: Erupt the clash:The DeleteCommand affects 0 records string strdelrecords=null; try { for(int i=0;i<myset.Tables[0].Rows.Count;i++) { if(this.dataGrid1.IsSelected(i)) { strdelrecords+=OrderID= +' +Convert.ToString(this.dataGrid1[i0].ToString())+' or ; } strdelrecords=strdelrecords.Trim(); strdelrecords=strdelrecords.Remove(strdelrecords.Length-22); DataTable dataTable=myset.Tables[0]; DataRow[] NewRow=dataTable.Select(strdelrecords); if(NewRow.Length==0) { return; } foreach(DataRow delrow in NewRow) { delrow.Delete(); } mycmd =new SqlCommand(DELETE FROM mytable where  + strdelrecordsmyconn); myda.DeleteCommand =mycmd; myda.Update(mysetmytable); myset.AcceptChanges(); } catch(System.Exception exp) { MessageBox.Show(exp.Message); return; }

Cstrayman · Answer

Thank you very much! I hope to be with you to become the friend!

miker · Answer

Why don't use SqlCommand.ExecuteNonQuery method? Here is how: mycmd =new SqlCommand(DELETE FROM mytable where  + strdelrecordsmyconn); mycmd.ExecuteNonQuery();

About DataAdapter.Update(), please help me!!!