State Property (PgSqlConnection)

In This Topic

Syntax
Remarks
Example
Requirements
See Also

Gets the current state of the connection.

Syntax

Visual Basic
C#

public new ConnectionState State {get; set;}

'Declaration
 
Public Shadows Property State As ConnectionState

Property Value

A bitwise combination of the System.Data.ConnectionState values. The default value is Closed.

Remarks

The allowed state changes are:

From Closed to Open, using the Open method of the PgSqlConnection object.
From Open to Closed, using either the Close method or the System.ComponentModel.Component.Dispose() method of the PgSqlConnection object.

Example

The following example creates an instance of a derived class, PgSqlConnection, sets its ConnectionString, and displays its State.

csharp

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();
}

Visual Basic

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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

PgSqlConnection Class
PgSqlConnection Members
ConnectionString Property

Send Feedback