一个C#针对Access的简单DataHelper

写个C#针对Access的简单DataHelper!! 但愿能够对大家有帮助

 

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>
/// Summary description for DBConn
/// </summary>
public class AccessDataHelper
{
    private System.Data.OleDb.OleDbConnection myCon;
    private static String strFile = HttpContext.Current.Request.PhysicalApplicationPath + ConfigurationManager.AppSettings["connectString"];

	public AccessDataHelper()
	{
        string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFile;
        this.myCon = new System.Data.OleDb.OleDbConnection(strCon);
        this.myCon.Open();
    }
    
    public void Close()
    {
        if (this.myCon.State == ConnectionState.Open)
        {
            myCon.Close();
            myCon = null;
        }
    }
    public OleDbDataReader getDataSet(String strSql, params Object[] obj)
    {
        OleDbCommand sqlcom = new OleDbCommand(strSql, myCon);
        for (int i = 0; i < obj.Length; i++)
        {
            sqlcom.Parameters.Add(new OleDbParameter("P" + (i + 1), obj[i]));
        }
        return sqlcom.ExecuteReader();
    }


    public int ExecudeSql(String strSql, params Object[] obj)
    {
        OleDbCommand sqlcom = new OleDbCommand(strSql, myCon);
        for (int i = 0; i < obj.Length; i++)
        {
            sqlcom.Parameters.Add(new OleDbParameter("P"+(i+1),obj[i]));
        }
        return sqlcom.ExecuteNonQuery();
    }

    public static AccessDataSource getAccessDataSource(String strSql)
    {
        AccessDataSource ds = new AccessDataSource();
        ds.DataFile = strFile;
        ds.SelectCommand = strSql;
        return ds;
    }
}

 

主要方法有三个，一个查询，一个更新，还有一个是为了绑定而返回的DataSource

目前功能比较少，以后有时间再完善！

：）

注意：Access使用Parameters时，最好按照设定顺序从前到后来设参数！