写个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时,最好按照设定顺序从前到后来设参数!