MySqlConnection.State Property

MySQL Connector/Net

previous page next page
MySqlConnectionState Property
Gets the current state of the connection.

Namespace: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll) Version: 6.9.9
Syntax
Copy
public override ConnectionState State { get; }
Public Overrides ReadOnly Property State As ConnectionState
	Get
public:
virtual property ConnectionState State {
	ConnectionState get () override;
}
abstract State : ConnectionState with get
override State : ConnectionState with get

Return Value

Type: ConnectionState
A bitwise combination of the ConnectionState values. The default is Closed.

Implements

IDbConnectionState
Remarks
The allowed state changes are:
  • From Closed to Open, using the Open method of the connection object.
  • From Open to Closed, using either the Close method or the Dispose method of the connection object.
Examples
The following example creates a MySqlConnection, opens it, displays some of its properties, then closes the connection.
Copy
public void CreateMySqlConnection(string myConnString)
{
MySqlConnection myConnection = new MySqlConnection(myConnString);
myConnection.Open();
MessageBox.Show("ServerVersion: " + myConnection.ServerVersion +
"\nState: " + myConnection.State.ToString());
myConnection.Close();
}
Public Sub CreateMySqlConnection(myConnString As String)
Dim myConnection As New MySqlConnection(myConnString)
myConnection.Open()
MessageBox.Show("ServerVersion: " + myConnection.ServerVersion _
+ ControlChars.Cr + "State: " + myConnection.State.ToString())
myConnection.Close()
End Sub

No code example is currently available or this language may not be supported.

No code example is currently available or this language may not be supported.

See Also
previous page start next page