使用DataTable更新數據庫(增,刪,改)

2024-07-10 12:46:23

字體：大中小

來源：轉載

供稿：網友

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

上一篇：asp.net中使用cookie與md5加密實現記住密碼功能的實現代碼

下一篇：asp.net中Session緩存與Cache緩存的區別分析