DataSet SqlCommandBuilder添加修改删除数据

private void Add()
  {
   SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString());
   myConnection.Open();
   SqlDataAdapter myDataAdapter = new SqlDataAdapter ();
   DataSet myDataSet = new DataSet ();
   string strCom ="select * from MemberTable";
   myDataAdapter.SelectCommand = new SqlCommand (strCom,myConnection);
   SqlCommandBuilder myCB = new SqlCommandBuilder (myDataAdapter);
   myDataAdapter.Fill (myDataSet,"myTable");
   DataRow myDataRow;    //定义一个DataRow
   DataTable myDataTable;         //定义一个DataTable
   myDataTable = myDataSet.Tables["myTable"];      //引用DataSet中的一个DataTable
   myDataRow = myDataTable.NewRow();      //调用NewRow方法得到一个DataRow
   myDataRow["MemberNickname"] = "成龙";  //将此DataRow中的myName字段置为“杨扬”
   myDataTable.Rows.Add(myDataRow);
   myDataAdapter.Update(myDataSet,"myTable");
   Response.Write("添加成功");
  }
  private void Modify()
  {
   SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString());
   myConnection.Open();
   SqlDataAdapter myDataAdapter = new SqlDataAdapter ();
   DataSet myDataSet = new DataSet ();
   string strCom ="select * from MemberTable where MemberId=3";
   myDataAdapter.SelectCommand = new SqlCommand (strCom,myConnection);
   SqlCommandBuilder myCB = new SqlCommandBuilder (myDataAdapter);
   myDataAdapter.Fill (myDataSet,"myTable");
   DataRow myDataRow;    //定义一个DataRow
   DataTable myDataTable;         //定义一个DataTable
   myDataTable = myDataSet.Tables["myTable"];      //引用DataSet中的一个DataTable
   myDataRow = myDataTable.Rows[0];       //得到一个要修改的DataRow
   myDataRow["MemberNickname"] = "释小龙";
   myDataAdapter.Update(myDataSet,"myTable");
   Response.Write("修改成功");
  }
  private void Delete(){
   SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString());
   myConnection.Open();
   SqlDataAdapter myDataAdapter = new SqlDataAdapter ();
   DataSet myDataSet = new DataSet ();
   string strCom ="select * from MemberTable where MemberId=3";
   myDataAdapter.SelectCommand = new SqlCommand (strCom,myConnection);
   SqlCommandBuilder myCB = new SqlCommandBuilder (myDataAdapter);
   myDataAdapter.Fill (myDataSet,"myTable");
   DataRow myDataRow;    //定义一个DataRow
   DataTable myDataTable;         //定义一个DataTable
   myDataTable = myDataSet.Tables["myTable"];      //引用DataSet中的一个DataTable
   myDataRow = myDataTable.Rows[0];        //得到一个要删除的DataRow
   myDataRow.Delete();
   myDataAdapter.Update(myDataSet,"myTable");
   Response.Write("删除成功");
 }

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/ITFLY8/archive/2005/11/16/530817.aspx