用dataset修改数据,你们见见哪里出错了
用dataset修改数据,你们看看哪里出错了
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=.;Initial Catalog=student;Integrated Security=True";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from [dbo].[login]";
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
conn.Open();
sda.Fill(ds, "login");
DataTable dt = new DataTable();
dt = ds.Tables[0];
DataRow dr = dt.Rows[1];
dt.Rows[1][1]="12";
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
sda.UpdateCommand = scb.GetUpdateCommand();
sda.Update(dt);
Response.Write("成功");
------解决思路----------------------
你login表没设置主键吧
------解决思路----------------------
没有设置主键
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=.;Initial Catalog=student;Integrated Security=True";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from [dbo].[login]";
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
conn.Open();
sda.Fill(ds, "login");
DataTable dt = new DataTable();
dt = ds.Tables[0];
DataRow dr = dt.Rows[1];
dt.Rows[1][1]="12";
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
sda.UpdateCommand = scb.GetUpdateCommand();
sda.Update(dt);
Response.Write("成功");
------解决思路----------------------
你login表没设置主键吧
------解决思路----------------------
没有设置主键