datatable如何更新？

显示全部楼层 · 2015-9-8 23:00:48

protected void Button2_Click(object sender, EventArgs e)

{

using (SqlConnection conn = new SqlConnection(connstr))

{

SqlDataAdapter ad = new SqlDataAdapter("Select * from info2" , conn);//Where id="+this.xuehao.Text.Trim()+" "

SqlCommandBuilder builder = new SqlCommandBuilder(ad);

ad.UpdateCommand = builder.GetUpdateCommand();

DataTable dt = new DataTable();

ad.Fill(dt);

//this.xuehao.Focus();

DataRow row = dt.NewRow();

row[0] = this.xuehao.Text.Trim();

row[1] = this.name.Text.Trim();

row[2] = this.age.Text.Trim();

row[3] = this.score.Text.Trim();

row[4] = this.sex.Text.Trim();

dt.

ad.Update(dt);

this.GridView1.DataSource = dt;

this.DataBind();

}
dt.那里不会改。。。。
这里是新建一个行，然后写入DT，然后再更新数据库。。。
问题是怎么更新DT？

千问 · 2015-9-8 23:00:48

/*把更改写回数据库DataAdapter.Update*/
/*Important: 这种在DataTable中进行的插入、更新和删除并不会自动写回数据库
*/
SqlDataAdapter adapter = new SqlDataAdapter(strSql, strConn);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
DataSet ds = new DataSet();
adapter.Fill(ds, "

千问 · 2015-9-8 23:00:48

dt.Rows.Add(row);