ahmad002
یک شنبه 14 مهر 1392, 11:29 صبح
این کدیه که واسه delete نوشتم ولی کار نمی کنه (خطا هم نداره)
DataSet ds2 = new DataSet();
SqlDataAdapter da2 = new SqlDataAdapter("select * from tbl3 where Code = '" + Int32.Parse(textBox5.Text.Trim()) + "' ", conct);
SqlCommandBuilder comb2 = new SqlCommandBuilder(da2);
for (int i = 0; i <= ds.Tables["afrad"].Rows.Count - 1; i++)
{
ds.Tables["afrad"].Rows[i].Delete();
}
da2.DeleteCommand = comb2.GetDeleteCommand();
da2.Update(ds2, "afrad");
dataGrid1.DataSource = ds2;
dataGrid1.DataMember = "afrad";
DataSet ds2 = new DataSet();
SqlDataAdapter da2 = new SqlDataAdapter("select * from tbl3 where Code = '" + Int32.Parse(textBox5.Text.Trim()) + "' ", conct);
SqlCommandBuilder comb2 = new SqlCommandBuilder(da2);
for (int i = 0; i <= ds.Tables["afrad"].Rows.Count - 1; i++)
{
ds.Tables["afrad"].Rows[i].Delete();
}
da2.DeleteCommand = comb2.GetDeleteCommand();
da2.Update(ds2, "afrad");
dataGrid1.DataSource = ds2;
dataGrid1.DataMember = "afrad";