ADO Foundation Supplements II: INSERT, UPDATE, delete data

Inserting data

1          Public voidInsertdatatosql ()2         {3             stringConstr = configurationmanager.connectionstrings["NorthwindConnectionString"]. ConnectionString;4SqlConnection conn =NewSqlConnection (constr);5 Conn. Open ();6 7SqlCommand cmd =NewSqlCommand ();8Cmd. Connection =Conn;9Cmd.commandtext ="INSERT into CUSTOMERS (customerid,companyname,contactname) Value (' Bille ', ' XYZ commpany ', ' Bill Evjen ')";Ten  One             //the insert operation is through CMD. ExecuteNonQuery (); method to implement the A cmd. ExecuteNonQuery (); - Conn. Close (); -}

Update data

1          Public intUpdatedatatosql ()2         {3             stringConstr = configurationmanager.connectionstrings["NorthwindConnectionString"]. ConnectionString;4SqlConnection conn =NewSqlConnection (constr);5 Conn. Open ();6 7SqlCommand cmd =NewSqlCommand ();8Cmd. Connection =Conn;9Cmd.commandtext ="UPDATE Employees SET emp_bonus =1000 WHERE yrs_duty >=5";Ten  One             //cmd. ExecuteNonQuery () returns the number of records affected by the update A             intRecordsAffected =cmd. ExecuteNonQuery (); -             returnRecordsAffected; -}

Delete data

1          Public intDeleteemployee ()2         {3             stringConstr = configurationmanager.connectionstrings["NorthwindConnectionString"]. ConnectionString;4SqlConnection conn =NewSqlConnection (constr);5 Conn. Open ();6 7SqlCommand cmd =NewSqlCommand ();8Cmd. Connection =Conn;9Cmd.commandtext ="DELETE Employees WHERE LastName = ' Evjen '";Ten                 One             //returns the number of deleted records A             intRecordsAffected =cmd. ExecuteNonQuery (); -             returnRecordsAffected; -}