dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteConnection Class / State Property
Example

State Property (SQLiteConnection)
Gets the current state of the connection.
Syntax
'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:
Example
The following example creates an instance of a derived class, SQLiteConnection, sets its ConnectionString, and displays its State.
public void CreateSQLiteConnection()
{
  SQLiteConnection sqConnection = new SQLiteConnection();
  sqConnection.ConnectionString = 
      "DataSource=mydatabase.db;";
  sqConnection.Open();
  MessageBox.Show("Connection State: " + sqConnection.State.ToString());
  sqConnection.Close();
}
Public Sub CreateSQLiteConnection()
  Dim sqConnection As New SQLiteConnection()
  sqConnection.ConnectionString = _
      "DataSource=mydatabase.db;"
  sqConnection.Open()
  MessageBox.Show("Connection State: " + sqConnection.State.ToString())
  sqConnection.Close()
End Sub
See Also