static void Main(string[] args)
{
SqlConnection con = new SqlConnection(@"Data Source=(local);Integrated Security=SSPI;" + "Initial Catalog=test");
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter("select sname from person", con);
SqlCommandBuilder bulder = new SqlCommandBuilder(adapter);
DataSet data = new DataSet();
adapter.Fill(data, "person");
Console.WriteLine(data.Tables["person"].Rows[11]["sname"]);
data.Tables["person"].Rows[11]["sname"] = "update";
adapter.Update(data, "person");
Console.WriteLine(data.Tables["person"].Rows[11]["sname"]);
con.Close();
Console.ReadKey();
}
{
SqlConnection con = new SqlConnection(@"Data Source=(local);Integrated Security=SSPI;" + "Initial Catalog=test");
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter("select sname from person", con);
SqlCommandBuilder bulder = new SqlCommandBuilder(adapter);
DataSet data = new DataSet();
adapter.Fill(data, "person");
Console.WriteLine(data.Tables["person"].Rows[11]["sname"]);
data.Tables["person"].Rows[11]["sname"] = "update";
adapter.Update(data, "person");
Console.WriteLine(data.Tables["person"].Rows[11]["sname"]);
con.Close();
Console.ReadKey();
}
而且person表要有主建,没有的话,只能自己写Update语句来更新
SqlDataAdapter adapter = new SqlDataAdapter("select * from person", con);
SqlCommandBuilder cb = new SqlCommandBuilder(adapter);
adapter.Update(data);
,上面的条件都满足的话,这样才能更新