datatable更新入Oracle库,使用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);

时间： 2013-03-01