1, modify the data
Copy Code code as follows:
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. Inserting data
Copy Code code as follows:
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. Delete data
Copy Code code as follows:
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);