ASP中连接数据库出错(在线等)

namespace MyOfficeBBL
{
  public class GetConnection
    {
        private static SqlConnection _connection;
      /// <summary>
      /// 获取数据库连接桥
      /// </summary>
        private static SqlConnection Connection
        {
            get 
            {
                string connectionString = "Data Source=.;Initial Catalog=MyOffice;Integrated Security=True";
                if (_connection == null)
                {
                    _connection = new SqlConnection(connectionString);
                    _connection.Open();
                }
                if (_connection.State == ConnectionState.Closed)
                {
                    _connection.Open();
                }
                if (_connection.State == ConnectionState.Broken)
                {
                    _connection.Close();
                    _connection.Open();
                }
                return GetConnection._connection; 
            }
          
        }
      /// <summary>
      /// 获取表数据
      /// </summary>
      /// <param name="sql"></param>
      /// <returns></returns>
        public static SqlDataReader GetDataRead(string sql)
        {
            SqlCommand command = new SqlCommand(sql, Connection);
            SqlDataReader read = command.ExecuteReader();
            return read;
        }
        public static int NoSelect(string sql) 
        {
            SqlCommand command = new SqlCommand(sql, Connection);
            int row = command.ExecuteNonQuery();
            return row;
        }
        public static DataTable GetDataTable(string sql) 
        {
            SqlCommand command = new SqlCommand(sql, Connection);
            DataTable dt = new DataTable();
            SqlDataAdapter sda = new SqlDataAdapter(command);
            sda.Fill(dt);
            return dt;
        }    }
}
你可以参考、参考