App_Code/AccessHelp.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Data.OleDb;
using System.Web.UI.HtmlControls;
using System.Xml;


namespace CommonLib
{
    /// <summary>
    /// AccessHelper 的摘要说明
    /// Access数据库数据访问公共类
    /// </summary>
    public class AccessHelper
    {
        //数据库连接串
        public static readonly string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBLink"].ConnectionString;

        #region 数据库连接对象操作
        /// <summary> 
        /// 打开数据库连接 
        /// </summary> 
        private static OleDbConnection OpenConnection()
        {
            try
            {
                OleDbConnection conn = new OleDbConnection(connectionString);
                if (conn.State != ConnectionState.Open)
                    conn.Open();
                return conn;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 关闭数据库连接释放资源
        /// </summary>
        /// <param name="Conn">数据库连接对象</param>
        public static void DisposeConnection(OleDbConnection Conn)
        {
            if (Conn != null)
            {
                Conn.Close();
                Conn.Dispose();
            }
        }

        #endregion

        #region SQL操作语句

        /// <summary>
        /// 执行Sql查询语句 
        /// </summary>
        /// <param name="strSQL">传入的Sql语句</param>
        /// <returns>返回受影响的行数</returns>
        public static int ExecuteSql(string strSQL)