使用DataTable更新數據庫

1、修改數據

????????????DataRow?dr?=?hRDataSet.Tables["emp"].Rows.Find(textBox3.Text);//DataRow?dr?=?hRDataSet.Tables["emp"].Select("id="+textBox3.Text)[0];dr.BeginEdit();
????????????dr["name"]?=?textBox1.Text;dr.EndEdit();

            SqlCommandBuilder cmd=new SqlCommandBuilder(empTableAdapter);empTableAdapter.Update(hRDataSet);this.empTableAdapter.Fill(this.hRDataSet.emp);

2、插入數據

??????????? DataSet ds = new DataSet();
??????????? using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["db"].ConnectionString))
??????????? {
??????????????? String sql = "select id,name,age from emp";
??????????????? SqlDataAdapter adp = new SqlDataAdapter(sql, conn);
??????????????? adp.Fill(ds);
??????????????? DataRow dr=ds.Tables[0].NewRow();
??????????????? dr["name"]=txtName.Text;
??????????????? dr["age"] = Convert.ToInt32(txtAge.Text);
??????????????? SqlCommandBuilder cmd=new SqlCommandBuilder(adp);
??????????????? ds.Tables[0].Rows.Add(dr);
??????????????? adp.Update(ds);
??????????? }

3、刪除數據

????????????DataRow?dr?=?hRDataSet.Tables["emp"].Rows.Find(textBox3.Text);
????????????//DataRow?dr?=?hRDataSet.Tables["emp"].Select("id="+textBox3.Text)[0];
?????????? dr.Delete();
??????????? SqlCommandBuilder cmd=new SqlCommandBuilder(empTableAdapter);
????????????empTableAdapter.Update(hRDataSet);
????????????this.empTableAdapter.Fill(this.hRDataSet.emp);