ACCESS通用类

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;

 

 

/// <summary>
///AccessDBHelper 的摘要说明
/// </summary>
public class AccessDBHelper
{
    private  string connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Jet Oledb:Database Password=mingmei114;Data Source=";
    
    public AccessDBHelper()
    {
        
    }
    public AccessDBHelper(string AsaFilePath)
    {
        connectionString += AsaFilePath;
    }
    private  OleDbConnection connection;

 

 

public  OleDbConnection Connection
    {
        get 
        {
            if (connection == null)
            {
                connection = new OleDbConnection(connectionString);
                connection.Open();
            }
            else if (connection.State == System.Data.ConnectionState.Closed)
            {
                connection.Open();
            }
            else if (connection.State == System.Data.ConnectionState.Broken)
            {
                connection.Close();
                connection.Open();
            }
            return connection;
        }
    }

 

 

 

public  int ExecuteCommand(string safeSql)
    {
        OleDbCommand cmd = new OleDbCommand(safeSql,Connection);
        int result = cmd.ExecuteNonQuery();
        return result;
    }

 

 

public  int ExecuteCommand(string sql, params SqlParameter[] values)
    {
        OleDbCommand cmd = new OleDbCommand(sql, Connection);
        cmd.Parameters.AddRange(values);
        return cmd.ExecuteNonQuery();
    }

 

 

public  int GetScalar(string safeSql)
    {
        OleDbCommand cmd = new OleDbCommand(safeSql, Connection);
        int result = Convert.ToInt32(cmd.ExecuteScalar());
        return result;
    }

 

 

public  int GetScalar(string sql, SqlParameter[] values)
    {
        OleDbCommand cmd = new OleDbCommand(sql, Connection);
        cmd.Parameters.AddRange(values);
        int result = Convert.ToInt32(cmd.ExecuteScalar());
        return result;
    }

 

 

public  OleDbDataReader GetReader(string safeSql)
    {
        OleDbCommand cmd = new OleDbCommand(safeSql, Connection);
        OleDbDataReader reader = cmd.ExecuteReader();
        return reader;
    }

 

 

public  OleDbDataReader GetReader(string sql, SqlParameter[] values)
    {
        OleDbCommand cmd = new OleDbCommand(sql, Connection);
        cmd.Parameters.AddRange(values);
        OleDbDataReader reader = cmd.ExecuteReader();
        return reader;
    }

 

 

public  DataTable GetDataSet(string safeSql)
    {
        DataSet ds = new DataSet();
        OleDbCommand cmd = new OleDbCommand(safeSql, Connection);
        OleDbDataAdapter da = new OleDbDataAdapter(cmd);
        da.Fill(ds);
        return ds.Tables[0];
    }

 

 

public  DataTable GetDataSet(string sql, SqlParameter[] values)
    {
        DataSet ds = new DataSet();
        OleDbCommand cmd = new OleDbCommand(sql, Connection);
        cmd.Parameters.AddRange(values);
        OleDbDataAdapter da = new OleDbDataAdapter(cmd);
        da.Fill(ds);
        return ds.Tables[0];
    }

 

}

 

用法:

protected string BindDrName(string srk) //收款人 销售员
    {
        if (Session["shopid"] == null)
            Response.Redirect("MemberLogin.aspx");
        string myshopDB = Session["shopid"].ToString();

 

 

string asafilepath = System.Web.HttpContext.Current.Server.MapPath("~/App_Data/" + myshopDB + ".asa");
        AccessDBHelper acc = new AccessDBHelper(asafilepath);
        string sql = "select * from dr where dr_hm='" + srk +"'";
        DataTable dt = acc.GetDataSet(sql);
        string drname = "";
        foreach (DataRow item in dt.Rows)
        {
            drname = item["dr_name"].ToString();
        }
        return drname;
    }