createconnection.cs

来自「提供数据库访问 直接调用你的方法 根据需求 合理使用」· CS 代码 · 共 36 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
namespace DBO.Access
{
    public class CreateConnection
    {
        #region 创建连接数据库对象 Access
        private static OleDbConnection objConnection;
        public static OleDbConnection ObjConnection
        {
            get
            {
                if (objConnection == null)
                {
                    objConnection = new OleDbConnection(ReadAppData.getConnString);
                }
                if (objConnection.State ==ConnectionState.Closed)
                {
                    objConnection.Open();
                }
                if (objConnection.State == ConnectionState.Broken)//状态中断
                {
                    objConnection.Close();
                    objConnection.Open();
                }
                //return new SqlConnection(getConnString);
                return objConnection;
            }
        }
        #endregion
    }
}