State Property (PgSqlConnection)
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,
PgSqlConnection, sets its
ConnectionString, and displays its
State.
public void CreatePgSqlConnection()
{
PgSqlConnection pgConnection = new PgSqlConnection();
pgConnection.ConnectionString =
"host=server;database=test;user id=postgres;";
pgConnection.Open();
MessageBox.Show("Connection State: " + pgConnection.State.ToString());
pgConnection.Close();
}
Public Sub CreatePgSqlConnection()
Dim pgConnection As New PgSqlConnection()
pgConnection.ConnectionString = _
"host=server;database=test;user id=postgres;"
pgConnection.Open()
MessageBox.Show("Connection State: " + pgConnection.State.ToString())
pgConnection.Close()
End Sub