///Db_Class 的摘要说明。///publicclassDb_Class
{publicOleDbConnection Conn;//构造函数publicDb_Class()
{
Conn=newOleDbConnection("Provider=SQLOLEDB;Server=(local);Pwd=123456;UID=sa;Database=test");
}//打开数据源链接publicOleDbConnection Db_Conn()
{
Conn.Open();returnConn;
}//返回DataReader数据集,下面的SQL可以动态生成publicOleDbDataReader Db_CreateReader(stringSQL)
{
Db_Conn();
OleDbCommand cmd=newOleDbCommand(SQL,Conn);
OleDbDataReader Rs=cmd.ExecuteReader();returnRs;this.close();
}//返回DataReader数据集,下面的SQL是存储过程publicOleDbDataReader Db_CommandReader(stringSQL)
{
Db_Conn();
OleDbCommand cmd=newOleDbCommand(SQL,Conn);
cmd.CommandType=CommandType.StoredProcedure;
OleDbDataReader Rs=cmd.ExecuteReader();returnRs;this.close();
}//返回数据DataSet数据集publicOleDbDataSet Db_CreateDataSet(stringSQL)
{
Db_Conn();
OleDbCommand cmd=newOleDbCommand(SQL,Conn);
OleDbDataAdapter Adpt=newOleDbDataAdapter(cmd,Conn);
DataSet Ds=newDataSet();
Adpt.Fill(Ds,"NewTable");returnDs;this.close();
}//返回数据DataReader数据集,不需要返回数据的修改,删除可以使用本函数publicboolDb_ExecuteNonquery(stringSQL)
{
Db_Conn();
OleDbCommand cmd=newOleDbCommand(SQL,Conn);try{
cmd.ExecuteNonQuery();returntrue;
}catch{returnfalse;
}this.close();
}//关闭数据链接publicvoidclose()
{
Conn.Close();
}
}
}
使用方法如下:usingSystem;usingSystem.Collections;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Web;usingSystem.Web.SessionState;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.HtmlControls;namespaceDbClass
{//WebForm1 的摘要说明。///publicclassWebForm1 : System.Web.UI.Page
{protectedSystem.Web.UI.WebControls.DataGrid DataGrid1;protectedSystem.Web.UI.WebControls.Button Button1;privatevoidPage_Load(objectsender, System.EventArgs e)
{//在此处放置用户代码以初始化页面//string SQL="select * from sysfiles";Db_Class Db_class=newDb_Class();
DataGrid1.DataSource=Db_class.Db_CommandReader("sp_tables");//使用SQLSERVER的存储过程。DataGrid1.DataBind();
}#regionWeb 窗体设计器生成的代码overrideprotectedvoidOnInit(EventArgs e)
{CODEGEN: 该调用是 asp.net Web 窗体设计器所必需的。//InitializeComponent();base.OnInit(e);
}//设计器支持所需的方法 - 不要使用代码编辑器修改///此方法的内容。///privatevoidInitializeComponent()
{this.Button1.Click+=newSystem.EventHandler(this.Button1_Click);this.DataGrid1.SelectedIndexChanged+=newSystem.EventHandler(this.DataGrid1_SelectedIndexChanged);this.Load+=newSystem.EventHandler(this.Page_Load);
}#endregion}
}