C#访问Access数据类

配置web.config文件的链接参数

<configuration>

  <appSettings>
    <add key="connStr" value="/App_Data/abc.mdb" />
  </appSettings>
    <connectionStrings/>

C#代码

 

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;

namespace Conn
...{
    public class ConnDB
    ...{
        /**//// <summary>
        /// 连接数据库字符串
        /// </summary>
        private string connectionString;

        /**//// <summary>
        /// 存储数据库连接（保护类，只有由它派生的类才能访问）
        /// </summary>
        protected OleDbConnection Connection;

        /**//// <summary>
        /// 构造函数：数据库的默认连接
        /// </summary>
        public ConnDB()
        ...{
            string connStr;
            connStr = System.Configuration.ConfigurationSettings.AppSettings["connStr"]; //从web.config配置中读取

            connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Common.applicationPath + connStr;

            Connection = new OleDbConnection(connectionString);
        }

        /**//// <summary>
        /// 构造函数：带有参数的数据库连接
        /// </summary>
        /// <param name="newConnectionString">连接语句</param>
        public ConnDB(string newConnectionString)
        ...{
            connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Common.applicationPath + newConnectionString;
            Connection = new OleDbConnection(connectionString);
        }

        /**//// <summary>
        /// 获得连接字符串
        /// </summary>
        public string ConnectionString
        ...{
            get ...{ return connectionString; }
        }


        /**//// <summary>
        /// 执行SQL语句没有返回结果，如：执行删除、更新、插入等操作
        /// </summary>
        /// <param name="strSQL">SQL语句</param>
        /// <returns>是否成功</returns>
        public bool ExeSQL(string strSQL)
        ...{
            bool resultState = false;
            OleDbTransaction myTrans = null;
            OleDbCommand command = null;

            try
            ...{
                Connection.Open();
                myTrans = Connection.BeginTransaction();
                command = new OleDbCommand(strSQL, Connection, myTrans);
                command.ExecuteNonQuery();
                myTrans.Commit();
                resultState = true;
            }
            catch
            ...{
                if (myTrans != null)
                    myTrans.Rollback();
                resultState = false;
            }
            finally
            ...{
                Connection.Close();
            }
            return resultState;
        }

        /**//// <summary>
        /// 执行SQL语句返回结果到DataReader中
        /// </summary>
        /// <param name="strSQL">SQL语句</param>
        /// <returns>DataReader</returns>
        public OleDbDataReader ReturnDataReader(string strSQL)
        ...{
            OleDbDataReader dataReader = null;
            try
            ...{
                Connection.Open();
                OleDbCommand command = new OleDbCommand(strSQL, Connection);
                dataReader = command.ExecuteReader();
            }
            catch
            ...{
                Connection.Close();
            }
            return dataReader;
        }

        /**//// <summary>
        /// 执行SQL语句返回结果到DataSet中
        /// </summary>
        /// <param name="strSQL">SQL语句</param>
        /// <returns>DataSet</returns>
        public DataSet ReturnDataSet(string strSQL)
        ...{
            DataSet dataSet = null;
            try
            ...{
                Connection.Open();
                dataSet = new DataSet();
                OleDbDataAdapter OleDbDA = new OleDbDataAdapter(strSQL, Connection);
                OleDbDA.Fill(dataSet, "objDataSet");
            }
            finally
            ...{
                Connection.Close();
            }
            return dataSet;
        }

        /**//// <summary>
        /// 执行一查询语句，同时返回查询结果数目
        /// </summary>
        /// <param name="strSQL">SQL语句</param>
        /// <returns>结果数</returns>
        public int ReturnSqlResultCount(string strSQL)
        ...{
            int sqlResultCount = 0;

            try
            ...{
                Connection.Open();
                OleDbCommand command = new OleDbCommand(strSQL, Connection);
                OleDbDataReader dataReader = command.ExecuteReader();

                while (dataReader.Read())
                ...{
                    sqlResultCount++;
                }
                dataReader.Close();
            }
            catch
            ...{
                sqlResultCount = 0;
            }
            finally
            ...{
                Connection.Close();
            }
            return sqlResultCount;
        }

        /**//// <summary>
        /// 关闭连接
        /// </summary>
        public void close()
        ...{
            if (Connection != null)
                Connection.Close();
        }
    }
}