DataSet SqlCommandBuilder添加修改删除数据

来源：互联网发布：中国统计年鉴2017数据编辑：程序博客网时间：2024/05/01 14:10

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