Connection Property (SQLiteCommand)
Gets or sets the
SQLiteConnection used by this instance of the
SQLiteCommand.
Property Value
The connection to a data source. The default value is a null reference.
The following example creates a
SQLiteCommand and sets some of its properties.
public void CreateCommand()
{
string mySelectQuery = "SELECT * FROM Dept ORDER BY DeptNo";
SQLiteCommand sqCommand = new SQLiteCommand(mySelectQuery);
sqCommand.Connection = new SQLiteConnection(
"DataSource=mydatabase.db;");
sqCommand.CommandType = System.Data.CommandType.Text;
}
Public Sub CreateCommand()
Dim mySelectQuery As String = _
"SELECT * FROM Dept ORDER BY DeptNo"
Dim sqCommand As New SQLiteCommand(mySelectQuery)
sqCommand.Connection = New SQLiteConnection( _
"DataSource=mydatabase.db;")
sqCommand.CommandType = System.Data.CommandType.Text
End Sub