哪个能帮我解释一下下面这个dataset 里带的参数的意思吗?
System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
UseDataAdapter();
} /// <summary>
/// 使用SqlDataAdapter在数据库和DataSet之间架起桥梁
/// </summary>
void UseDataAdapter()
{
//1 连接数据库
SqlConnection myCon = new SqlConnection();
myCon.ConnectionString = "server=.;database=ABC;user id=sa;password=";
myCon.Open();
Page.Response.Write("已连接数据库<br />"); //2 创建一个SqlDataAdapter对象
SqlDataAdapter adapter = new SqlDataAdapter(); //3 利用SqlDataAdapter查询数据,并把数据放在DataSet中
SqlCommand selectCmd = new SqlCommand();
selectCmd.Connection = myCon;
selectCmd.CommandText = "SELECT id, name FROM cba;";
adapter.SelectCommand = selectCmd;
DataSet dataSet = new DataSet("Suppliers"); adapter.Fill(dataSet);//Fill数据
Page.Response.Write("已连查询数据,并放入DataSet中<br />"); //4 利用SqlDataAdapter对象操作语句
//4.1 Update
SqlCommand updateCmd = new SqlCommand();
updateCmd.Connection = myCon;
updateCmd.CommandText = "UPDATE cba SET name='KFC' WHERE id = 2";
adapter.UpdateCommand = updateCmd;
//4.2 Delete
SqlCommand deleteCmd = new SqlCommand();
deleteCmd.Connection = myCon;
deleteCmd.CommandText = "DELETE cba WHERE id = 3";
adapter.DeleteCommand = deleteCmd;
//4.3 Insert
SqlCommand insertCmd = new SqlCommand();
insertCmd.Connection = myCon;
insertCmd.CommandText = "INSERT INTO cba(id) values (44)";
adapter.InsertCommand = insertCmd;
//4.4 执行操作
adapter.Update(dataSet);
Page.Response.Write("已连操作数据,包括:修改、删除、插入<br />"); //5 关闭数据库连接
myCon.Close();
Page.Response.Write("已关闭数据库<br />");
}
}
System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
UseDataAdapter();
} /// <summary>
/// 使用SqlDataAdapter在数据库和DataSet之间架起桥梁
/// </summary>
void UseDataAdapter()
{
//1 连接数据库
SqlConnection myCon = new SqlConnection();
myCon.ConnectionString = "server=.;database=ABC;user id=sa;password=";
myCon.Open();
Page.Response.Write("已连接数据库<br />"); //2 创建一个SqlDataAdapter对象
SqlDataAdapter adapter = new SqlDataAdapter(); //3 利用SqlDataAdapter查询数据,并把数据放在DataSet中
SqlCommand selectCmd = new SqlCommand();
selectCmd.Connection = myCon;
selectCmd.CommandText = "SELECT id, name FROM cba;";
adapter.SelectCommand = selectCmd;
DataSet dataSet = new DataSet("Suppliers"); adapter.Fill(dataSet);//Fill数据
Page.Response.Write("已连查询数据,并放入DataSet中<br />"); //4 利用SqlDataAdapter对象操作语句
//4.1 Update
SqlCommand updateCmd = new SqlCommand();
updateCmd.Connection = myCon;
updateCmd.CommandText = "UPDATE cba SET name='KFC' WHERE id = 2";
adapter.UpdateCommand = updateCmd;
//4.2 Delete
SqlCommand deleteCmd = new SqlCommand();
deleteCmd.Connection = myCon;
deleteCmd.CommandText = "DELETE cba WHERE id = 3";
adapter.DeleteCommand = deleteCmd;
//4.3 Insert
SqlCommand insertCmd = new SqlCommand();
insertCmd.Connection = myCon;
insertCmd.CommandText = "INSERT INTO cba(id) values (44)";
adapter.InsertCommand = insertCmd;
//4.4 执行操作
adapter.Update(dataSet);
Page.Response.Write("已连操作数据,包括:修改、删除、插入<br />"); //5 关闭数据库连接
myCon.Close();
Page.Response.Write("已关闭数据库<br />");
}
}
DataSet dataSet = new DataSet("Suppliers");
Response.Write(dataSet.DataSetName);