......
SqlConnection connection=new Sqlconnection(ConnectionString);
......
SqlDataAdapter MySda1=new SqlDataAdapter(sda1,connection);
DataSet ds1=new DataSet();
......
MySda1.UpdateCommand=new SqlCommand("UPDATE 专业='计算机科学' FROM 学生 WHERE 姓名='王强'",connection);
MySda1.InsertCommand=new SqlCommand("INSERT INTO 学生 (姓名,专业) VALUES('雷果国','计算机科学'",connection);
MySda1.DeleteCommand=new SqlCommand("DELETE FROM 学生 WHERE 姓名='周明'",connection);
MySda1.Update(ds1,connection);
......