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("删除成功");
}
{
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("删除成功");
}