State Property (SQLiteConnection)
Gets the current state of the connection.
Property Value
A bitwise combination of the
System.Data.ConnectionState values. The default value is Closed.
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