Open Method (PgSqlConnection)
Opens a PostgreSQL connection with the property settings specified by the
ConnectionString.
The following example creates a
PgSqlConnection, opens it, displays some of its properties, and then closes the connection.
public void CreatePgSqlConnection(string myConnString)
{
PgSqlConnection pgConnection = new PgSqlConnection(myConnString);
pgConnection.Open();
MessageBox.Show("ServerVersion: " + pgConnection.ServerVersion
+ "\nState: " + pgConnection.State.ToString());
pgConnection.Close();
}
Public Sub CreatePgSqlConnection(myConnString As String)
Dim pgConnection As New PgSqlConnection(myConnString)
pgConnection.Open()
MessageBox.Show("ServerVersion: " + pgConnection.ServerVersion _
+ ControlChars.Cr + "State: " + pgConnection.State.ToString())
pgConnection.Close()
End Sub