数据库类

using 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.OleDb;

/**//// <summary>
/// Class1 的摘要说明
/// </summary>
/// 
namespace  _lib
{
    public class Class1
    {
        private  static string FConnString;

        public Class1()
        {
            FConnString = GetConnString();

        }

        protected static string GetConnString()
        {
        string strConn;
        return strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]) + ";";
        }
      
        //执行一条sql语句

        public static int ExecuteNonQuery(string Query)
        {
            int Result;

            OleDbConnection myConnection = new OleDbConnection(FConnString);
            myConnection.Open();
            OleDbCommand myCommand = new OleDbCommand(Query, myConnection);
            Result = myCommand.ExecuteNonQuery(); 
      
            myConnection.Close();

            return Result;
        }

　　　　//返回一个Dataset;        　
        public DataSet OpenRset(string Query)
        {
            OleDbConnection FConnection = new OleDbConnection(FConnString);
            OleDbCommand FCommand = new OleDbCommand();
            FCommand.Connection = FConnection;
            OleDbDataAdapter FDataAdapter = new OleDbDataAdapter();
            FDataAdapter.SelectCommand = FCommand;
            

            DataSet FDataSet = new DataSet();

            FCommand.CommandText = Query;
            FDataAdapter.Fill(FDataSet);
            
            // 连接数据库
            //打开数据库连接
            //设置数据库连接对象　　比如command 
            
            //关闭数据库连接


            return FDataSet;
        }
    }
}