State Property (UniConnection)

In This Topic

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

Example

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

csharp

public void CreateUniConnection()
{
  UniConnection myConnection = new UniConnection();
  myConnection.ConnectionString = "Provider=SQL Server;Data Source=SERVER;Initial Catalog=Northwind;User ID=sa";
  myConnection.Open();
  MessageBox.Show("Connection State: " + myConnection.State.ToString());
  myConnection.Close();
}

Visual Basic

Public Sub CreateUniConnection()
  Dim myConnection As New UniConnection()
  myConnection.ConnectionString = _
    "Provider=SQL Server;Data Source=SERVER;Initial Catalog=Northwind;User ID=sa"
  myConnection.Open()
  MessageBox.Show("Connection State: " + myConnection.State.ToString())
  myConnection.Close()
End Sub

Reference

UniConnection Class
UniConnection Members
ConnectionString Property

Send Feedback