Use datatable to update a database

1. modify data

            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. Insert data

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

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