dbconn.cs

商业源码

using System;

using System.Collections;
using System.Data;
using System.Data.OleDb;
using System.Configuration;

namespace SCard
{
	/// <summary>
	/// DBConn 的摘要说明。
	/// </summary>
	public class DBConn : System.Web.UI.Page
	{
		private OleDbConnection conn;

		public DBConn()
		{
			string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];
			string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath(DBPath);
			conn=new OleDbConnection(connStr);
			conn.Open();
		}

		public DBConn(string DBPath)
		{
			string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath(DBPath);
			conn=new OleDbConnection(connStr);
			conn.Open();
		}

		public void Close()//关闭数据库连接
		{
			conn.Close();
			conn = null;
		}

		public OleDbDataReader getDataReader(string SQLQuery)
		{
			OleDbCommand cmd = new OleDbCommand(SQLQuery,conn);
			return cmd.ExecuteReader();
		}

		public int ExecuteNonQuery(string SQLQuery)
		{
			OleDbCommand cmd = new OleDbCommand(SQLQuery,conn);
			return cmd.ExecuteNonQuery();
		}

		public DataSet getDataSet(string SQLQuery)
		{
			OleDbDataAdapter da = new OleDbDataAdapter(SQLQuery,conn);
			DataSet ds = new DataSet();
			da.Fill(ds);
			da.Dispose();
			da = null;
			return ds;
		}

		public ICollection CreateSource(string SQLQuery)
		{
			OleDbDataAdapter da = new OleDbDataAdapter(SQLQuery,conn);
			DataSet ds=new DataSet();
			da.Fill(ds,"mytable");
			return ds.Tables["mytable"].DefaultView;
		}




	}
}