createconnection.cs

提供数据库访问 直接调用你的方法 根据需求 合理使用

using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
namespace DBO
{
    public class CreateConnection
    {
        #region 创建连接数据库对象 Sql
        private static SqlConnection objConnection;
        public static SqlConnection ObjConnection
        {
            get
            {
                if (objConnection == null)
                {
                    objConnection =new  SqlConnection(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

    }
}