SQLiteCommand Constructor(String,SQLiteConnection)
Initializes a new instance of the
SQLiteCommand class with the text of the query and a
SQLiteConnection object.
The following example creates a
SQLiteCommand and sets some of its properties.
|
|---|
public void CreateCommand()
{
SQLiteConnection sqLiteConnection = new SQLiteConnection(
"DataSource=mydatabase.db;");
string mySelectQuery = "SELECT * FROM Dept";
SQLiteCommand sqLiteCommand = new SQLiteCommand(mySelectQuery, sqLiteConnection);
sqLiteCommand.FetchSize = 100;
} |
|
|---|
Public Sub CreateCommand()
Dim sqLiteConnection As New SQLiteConnection( _
"DataSource=mydatabase.db;")
Dim mySelectQuery As String = _
"SELECT * FROM Dept"
Dim sqLiteCommand As New SQLiteCommand(mySelectQuery, sqLiteConnection)
sqLiteCommand.FetchSize = 100
End Sub |