myconn类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.OleDb;

/// <summary>
/// Class1 的摘要说明
/// </summary>
public class superConn
{
    private OleDbConnection cnn;
    private OleDbCommand cmd;
    private OleDbDataReader datar;
    private int ch_number;
    public superConn(string mdbFileName)
    {
        string _path = "~\\app_data\\" + mdbFileName;
        string str_conn = "Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=" + HttpContext.Current.Server.MapPath(_path);
        cnn = new OleDbConnection(str_conn);
      
    }

    public void open(){

        cnn.Open();
        }
    public void close()
    {
        cnn.Close();
    }
   
        public OleDbDataReader GetDataReader(string _sql)
    {
        cmd = new OleDbCommand(_sql, cnn);
        datar=cmd.ExecuteReader();
        return datar;
    }

    public int GetChangeNumber(string _sqlchange)
    {
        cmd = new OleDbCommand(_sqlchange, cnn);
        ch_number  = cmd.ExecuteNonQuery();
        return ch_number ;

    }


}