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);
声明：本站（华域联盟www.cnhackhy.com）所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。