DA_Admin.csusing System;
using System.Data;
using System.Data.OleDb;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;//using Db;namespace Db
{
// <summary>
// View 的摘要说明。
// </summary>
public class View : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataList Message;
protected System.Web.UI.WebControls.Label lbRecordCount;
protected System.Web.UI.WebControls.Label lbCurrentPage;
protected System.Web.UI.WebControls.Label lbPageCount;
protected System.Web.UI.WebControls.LinkButton butPrev;
protected System.Web.UI.WebControls.LinkButton butNext;
protected System.Web.UI.WebControls.DropDownList dlsPageIndex;
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load); }
#endregion
private void Page_Load(object sender, System.EventArgs e)
{
string SQL;
OleDbDataReader myDR;
SQL="select product.*";
SQL= SQL + " from [product]";
SQL= SQL + " order by ParentID,iOrder";
myDR = Db.BaseClass.dataReader(SQL);
Message.DataSource=myDR;
Message.DataBind();
}
}
}DB.CSusing System;
using System.Data;
using System.Data.OleDb;
using System.Configuration; namespace Db
{
public class BaseClass
{
public BaseClass( )
{
//
// TODO: 在此处添加构造函数逻辑
//
}
protected static OleDbConnection conn ;
protected static OleDbCommand cmd = new OleDbCommand();
protected static OleDbDataAdapter da = new OleDbDataAdapter();
protected static DataSet ds = new DataSet( );
protected static DataView dv = new DataView( );
protected static string strSp; // <summary>
// 打开数据库连接
// </summary>
public void openConnection()
{
if (conn.State == ConnectionState.Closed)
{
//读取webconfig中连接字符串,如:"server=localhost;database=databasename;uid=sa;pwd=;"
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\ASP.NET\\work\\0\\DB\\db.mdb";
cmd.Connection =conn;
try
{
conn.Open();
}
catch(Exception e)
{
throw new Exception(e.Message);
}
}
}
// <summary>
// 关闭当前数据库连接
// </summary>
// <summary>
// 执行Sql查询语句
// </summary>
// <param name="sqlstr">传入的Sql语句</param>
public void ExecuteSql(string sqlstr)
{
try
{
openConnection();
cmd.CommandType =CommandType.Text ;
cmd.CommandText =sqlstr;
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
//closeConnection();
}
}
/// <summary>
/// 返回指定Sql语句的OleDbDataReader,请注意,在使用后请关闭本对象,同时将自动调用closeConnection()来关闭数据库连接
/// 方法关闭数据库连接
/// </summary>
/// <param name="sqlstr">传入的Sql语句</param>
/// <returns>OleDbDataReader对象</returns>
public OleDbDataReader dataReader(string sqlstr)
{
OleDbDataReader dr=null;
try
{
openConnection();
cmd.CommandText =sqlstr;
cmd.CommandType =CommandType.Text ;
dr=cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch
{
try
{
dr.Close();
//closeConnection();
}
catch
{
}
}
return dr;
}
}
}
using System.Data;
using System.Data.OleDb;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;//using Db;namespace Db
{
// <summary>
// View 的摘要说明。
// </summary>
public class View : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataList Message;
protected System.Web.UI.WebControls.Label lbRecordCount;
protected System.Web.UI.WebControls.Label lbCurrentPage;
protected System.Web.UI.WebControls.Label lbPageCount;
protected System.Web.UI.WebControls.LinkButton butPrev;
protected System.Web.UI.WebControls.LinkButton butNext;
protected System.Web.UI.WebControls.DropDownList dlsPageIndex;
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load); }
#endregion
private void Page_Load(object sender, System.EventArgs e)
{
string SQL;
OleDbDataReader myDR;
SQL="select product.*";
SQL= SQL + " from [product]";
SQL= SQL + " order by ParentID,iOrder";
myDR = Db.BaseClass.dataReader(SQL);
Message.DataSource=myDR;
Message.DataBind();
}
}
}DB.CSusing System;
using System.Data;
using System.Data.OleDb;
using System.Configuration; namespace Db
{
public class BaseClass
{
public BaseClass( )
{
//
// TODO: 在此处添加构造函数逻辑
//
}
protected static OleDbConnection conn ;
protected static OleDbCommand cmd = new OleDbCommand();
protected static OleDbDataAdapter da = new OleDbDataAdapter();
protected static DataSet ds = new DataSet( );
protected static DataView dv = new DataView( );
protected static string strSp; // <summary>
// 打开数据库连接
// </summary>
public void openConnection()
{
if (conn.State == ConnectionState.Closed)
{
//读取webconfig中连接字符串,如:"server=localhost;database=databasename;uid=sa;pwd=;"
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\ASP.NET\\work\\0\\DB\\db.mdb";
cmd.Connection =conn;
try
{
conn.Open();
}
catch(Exception e)
{
throw new Exception(e.Message);
}
}
}
// <summary>
// 关闭当前数据库连接
// </summary>
// <summary>
// 执行Sql查询语句
// </summary>
// <param name="sqlstr">传入的Sql语句</param>
public void ExecuteSql(string sqlstr)
{
try
{
openConnection();
cmd.CommandType =CommandType.Text ;
cmd.CommandText =sqlstr;
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
//closeConnection();
}
}
/// <summary>
/// 返回指定Sql语句的OleDbDataReader,请注意,在使用后请关闭本对象,同时将自动调用closeConnection()来关闭数据库连接
/// 方法关闭数据库连接
/// </summary>
/// <param name="sqlstr">传入的Sql语句</param>
/// <returns>OleDbDataReader对象</returns>
public OleDbDataReader dataReader(string sqlstr)
{
OleDbDataReader dr=null;
try
{
openConnection();
cmd.CommandText =sqlstr;
cmd.CommandType =CommandType.Text ;
dr=cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch
{
try
{
dr.Close();
//closeConnection();
}
catch
{
}
}
return dr;
}
}
}
解决方案 »
- 求助 关于数组问题 为什么我取不到这个数组的值呢
- 关于AjaxControlToolkit中的Accordion使用
- <span href= 求高人解释span标签的href属性是干什么用的
- 网站的序列号,一般取客户电脑上的什么硬件标识好呢,
- 打开窗口的问题
- 问下,asp.net使用mvc模式后是不是就和java那套东西一样了?
- 问一下大家asp.net页面前台代码都用什么工具来开发?
- 请教有关<!--#include file="inc/conn.aspx"-->在ASP.NET里的使用方法
- 关于ajaxpro的返回问题(急!)
- 文件的读取问题!c#写!求助!!
- 关于select语句参数的一个问题
- 请各位大虾帮帮忙!!!!!!
BaseClass bc =new BaseClass();
bc.ExecuteSql(strSQL);