使用DataTable更新数据库(增,删,改)

修改数据

复制代码代码如下:

            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);