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 mySqlConnection = new MySqlConnection();
mySqlConnection.ConnectionString =
"User Id=root;Host=localhost;Database=Test;";
mySqlConnection.Open();
MessageBox.Show("Connection State: " + mySqlConnection.State.ToString());
mySqlConnection.Close();
} |
|
|---|
Public Sub CreateMySqlConnection()
Dim mySqlConnection As New MySqlConnection()
mySqlConnection.ConnectionString = _
"User Id=root;Host=localhost;Database=Test;"
mySqlConnection.Open()
MessageBox.Show("Connection State: " + mySqlConnection.State.ToString())
mySqlConnection.Close()
End Sub |