Several basic operations of the DataSet

Several basic operations of the DataSet

A problem was encountered when writing a program recently, the insert content in the text type (SQL SERVER) field cannot be used directly with SQL statements, because there are newline, special characters. So you can only use a dataset. Remember in the ASP in the writing is Rs.addnew (), rs.update (), etc., in the asp.net is how to write it? After half a day of information (incredibly hard to find), write down some of these basic operations.
The following program is written from the dataset already established.

Delete a record that already exists
DataRow Dr;
int Vsno=int32.parse (txtsno.text);
dr=dataset11.tables["Student"]. Rows.find (Vsno)
Dr. Delete ();
Sqldataadapter1.update (dataSet11, "Student");

insert a new record

int Vsno=int32.parse (txtsno.text);
int Vscore=int32.parse (txtscore.text);
DataRow Dradd
dradd=dataset11.tables["Student"]. NewRow ();
Dradd[0]=vsno;
Dradd[1]=txtfname.text;
Dradd[2]=txtlname.text;
Dradd[3]=vscore;
dataset11.tables["Student"]. Rows.Add (Dradd);
SqlCommandBuilder Mybuilder = new SqlCommandBuilder (sqlDataAdapter1);
Sqldataadapter1.update (dataSet11, "Student");

edit a record that already exists

int Vsno=int32.parse (txtsno.text);
int Vscore=int32.parse (txtscore.text);
Drupdate.beginedit ();
drupdate["SNo"]=VSNO;
drupdate["FirstName"]=txtfname.text;
drupdate["LastName"]=txtlname.text;
drupdate["Score"]=vscore;
Drupdate.endedit ();
Sqldataadapter1.update (dataSet11, "Student");