有没有象 sqlhelper 一样的访问 access数据库的类呢?

Question

一直用sqlhelper 做 sqlserver2000的项目,现在客户要求用access数据库,但是习惯sqlhelper 的语法了,那位大大有类似的或改造过的给俺一份啊?俺的分的不吝啬

Answer 1

SqlHelper比较垃圾，一般都是自己写~

Answer 2

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Data.OleDb;namespace Holley.Metering.BJGL.DataOperateLib
{
    public class SqlHelpher
    {
        public SqlConnection sqlConnection;
        public OleDbConnection oleDbConnection;
        private static string m_ServerName;
        private static string m_Uid;
        private static string m_PassWord;
        private static string m_DataBase;
        public SqlHelpher()
        {
            //sqlConnection = new SqlConnection();
            oleDbConnection = new OleDbConnection();
        }
        #region 属性
        public static string ServerName
        {
            get { return m_ServerName; }
            set { m_ServerName = value; }
        }
        public static string Uid
        {
            get { return m_Uid; }
            set { m_Uid = value; }
        }
        public static string PassWord
        {
            get { return m_PassWord; }
            set { m_PassWord = value; }
        }
        public static string DataBase
        {
            get { return m_DataBase; }
            set { m_DataBase = value; }
        }
        #endregion
        public bool Connection()
        {
            bool result = false;
            //string ConnectString = @"server=" + "ch" + ";uid=" + "sa" + ";pwd=" + "123456" + ";database=" + "MeterSystem";
            //string ConnectString = @"server=" + ServerName + ";uid=" + Uid + ";pwd=" + PassWord + ";database=" + DataBase;
            //sqlConnection.ConnectionString = ConnectString;            //try
            //{
            //    if (sqlConnection.State.ToString() == "Closed")
            //        sqlConnection.Open();
            //    result = true;
            //}
            //catch
            //{
            //    sqlConnection.Close();
            //    result = false;
            //}
            //Access数据库
            //string ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\MeterSystem.mdb"; 
            string ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath +"\\"+ DataBase; 
            oleDbConnection.ConnectionString = ConnectString;
            try
            {
                if (oleDbConnection.State.ToString() == "Closed")
                    oleDbConnection.Open();
                result = true;
            }
            catch
            {
                oleDbConnection.Close();
                result = false;
            }
            return result;
        }        public void Close()
        {
            //sqlConnection.Close();
            oleDbConnection.Close();
        }
    }
}