State Property (DB2Connection)

On this page

Gets the current state of the connection.

Syntax

Visual Basic
C#


'Declaration Public Shadows Property State As ConnectionState


public new ConnectionState State {get; set;}

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 DB2Connection object.
From Open to Closed, using either the Close method or the Dispose() method of the DB2Connection object.

Example

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

csharp


public void CreateDB2Connection() { DB2Connection db2Connection = new DB2Connection(); db2Connection.ConnectionString = "user id=db2admin;server=db2;database=SAMPLE;"; db2Connection.Open(); MessageBox.Show("Connection State: " + db2Connection.State.ToString()); db2Connection.Close(); }

public void CreateDB2Connection()
{
  DB2Connection db2Connection = new DB2Connection();
  db2Connection.ConnectionString = 
      "user id=db2admin;server=db2;database=SAMPLE;";
  db2Connection.Open();
  MessageBox.Show("Connection State: " + db2Connection.State.ToString());
  db2Connection.Close();
}

Visual Basic


Public Sub CreateDB2Connection() Dim db2Connection As New DB2Connection() db2Connection.ConnectionString = _ "user id=db2admin;server=db2;database=SAMPLE;" db2Connection.Open() MessageBox.Show("Connection State: " + db2Connection.State.ToString()) db2Connection.Close() End Sub

Public Sub CreateDB2Connection()
  Dim db2Connection As New DB2Connection()
  db2Connection.ConnectionString = _
      "user id=db2admin;server=db2;database=SAMPLE;"
  db2Connection.Open()
  MessageBox.Show("Connection State: " + db2Connection.State.ToString())
  db2Connection.Close()
End Sub

Reference

DB2Connection Class
DB2Connection Members
ConnectionString Property

Send Feedback