数据库打开关闭操作

刚刚接触.net记录些东西慢慢学习，呵呵

记录些打开关闭的操作，希望浏览过的人有好的方法也提供下

 

 

Code public class DataBase:IDisposable      {         protected SqlConnection Connection;  //数据库连接对象         protected string ConnectionString;   //连接字符串变量         /// <summary>         /// 构造函数，获取连接字符         /// </summary>        public DataBase()         {             ConnectionString = "";         }         #region 数据库打开与关闭         /// <summary>         /// 打开连接         /// </summary>        protected void Open()         {             if (Connection == null)             {                 Connection = new SqlConnection(ConnectionString);             }             if(Connection.State.Equals(ConnectionState.Open()))             {                 Connection.Open();             }         }         /// <summary>         /// 关闭数据库连接         /// </summary>        public void Close()         {             if (Connection != null)             {                 Connection.Close();                 Dispose();             }         }         /// <summary>         /// 释放资源         /// </summary>        public void Dispose()         {             if (Connection != null)             {                 Dispose();                 Connection = null;             }         }     }

 

 

 

转载于:https://www.cnblogs.com/wzy0216/archive/2009/02/17/1392102.html