foreach (DataRow row in set.Tables["test"].Rows)
{
if (row[0].ToString() == textBox3.Text)
{
row.Delete();
}
}
set.AcceptChanges();
foreach (DataRow row in set.Tables["test"].Rows)
{
MessageBox.Show(row[0].ToString());
}
SqlConnection conn = new SqlConnection(Properties.Settings.Default.testConnectionString);
string str = "select * from test";
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(str, conn);
SqlCommandBuilder cmdb = new SqlCommandBuilder(adapter);
adapter.Update(set, "test");
conn.Close();
这是我写的根据指定的条件在Dataset删除行的代码,为什么看到在Dataset中已经删除了指定的行,可是却无法更新到数据库中呢?
求指点如何把删除后的Dataset更新到数据库中?