State Property (MySqlConnection)
Gets the current state of the connection.
Property Value
A bitwise combination of the
System.Data.ConnectionState values. The default value is Closed.
The following example creates an instance of a derived class,
MySqlConnection, sets its
ConnectionString, and displays its
State.
public void CreateMySqlConnection()
{
MySqlConnection myConnection = new MySqlConnection();
myConnection.ConnectionString =
"User Id=root;Host=localhost;Database=Test;";
myConnection.Open();
MessageBox.Show("Connection State: " + myConnection.State.ToString());
myConnection.Close();
}
Public Sub CreateMySqlConnection()
Dim myConnection As New MySqlConnection()
myConnection.ConnectionString = _
"User Id=root;Host=localhost;Database=Test;"
myConnection.Open()
MessageBox.Show("Connection State: " + myConnection.State.ToString())
myConnection.Close()
End Sub