Check if SQL Connection is Open or Closed

Question

How do you check if it is open or closed I was using   if  SQLOperator SQLCONNECTION State Equals  Open      however  even the State is  Open  it fails on this check

User · Answer

I use the following manner sqlconnection state  if conexion state    connectionState open       conexion open

User · Answer

Here is what I m using   if  mySQLConnection State    ConnectionState Open        mySQLConnection Close        mySQLConnection Open        The reason I m not simply using   if  mySQLConnection State    ConnectionState Closed        mySQLConnection Open        Is because the ConnectionState can also be   Broken  Connnecting  Executing  Fetching   In addition to   Open  Closed   Additionally Microsoft states that Closing  and then Re-opening the connection  will refresh the value of State   See here http   msdn microsoft com en-us library system data sqlclient sqlconnection state v vs 110  aspx

User · Answer

To check OleDbConnection State use this   if  oconn State    ConnectionState Open        oconn Close        State return the ConnectionState  public override ConnectionState State   get      Here are the other ConnectionState enum  public enum ConnectionState                             Summary                 The connection is closed          Closed   0                        Summary                 The connection is open          Open   1                        Summary                 The connection object is connecting to the data source   This value is reserved                for future versions of the product           Connecting   2                        Summary                 The connection object is executing a command   This value is reserved for future                versions of the product           Executing   4                        Summary                 The connection object is retrieving data   This value is reserved for future                versions of the product           Fetching   8                        Summary                 The connection to the data source is broken  This can occur only after the connection                has been opened  A connection in this state may be closed and then re-opened                  This value is reserved for future versions of the product           Broken   16

User · Answer

you can also use this  if  SQLCON State    ConnectionState Closed         SQLCON Open

User · Answer

You should be using SqlConnection State  e g   using System Data   if  myConnection    null  amp  amp  myConnection State    ConnectionState Closed          do something

User · Answer

To check the database connection state you can just simple do the following  if con State    ConnectionState Open

User · Answer

Check if a MySQL connection is open         ConnectionState state   connection State  if  state    ConnectionState Open        return true    else       connection Open        return true

User · Answer

The  NET documentation says  State Property  A bitwise combination of the ConnectionState values  So I think you should check   myConnection State HasFlag ConnectionState Open    instead of   myConnection State    ConnectionState Open   because State can have multiple flags

User · Answer

This code is a little more defensive  before opening a connection  check state   If connection state is Broken then we should try to close it  Broken means that the connection was previously opened and not functioning correctly  The second condition determines that connection state must be closed before attempting to open it again so the code can be called repeatedly      Defensive database opening logic   if   databaseConnection State    ConnectionState Broken         databaseConnection Close       if   databaseConnection State    ConnectionState Closed         databaseConnection Open

[c#] Check if SQL Connection is Open or Closed

Examples related to c#

Examples related to ado.net

Examples related to sqlconnection