dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteCommand Class / SQLiteCommand Constructor / SQLiteCommand Constructor(String,SQLiteConnection)
The text of the query.
A SQLiteConnection object that represents the connection to SQLite.
Example

On this page
    SQLiteCommand Constructor(String,SQLiteConnection)
    On this page
    Initializes a new instance of the SQLiteCommand class with the text of the query and a SQLiteConnection object.
    Syntax
    'Declaration
     
    Public Function New( _
       ByVal commandText As String, _
       ByVal connection As SQLiteConnection _
    )
    public SQLiteCommand( 
       string commandText,
       SQLiteConnection connection
    )

    Parameters

    commandText
    The text of the query.
    connection
    A SQLiteConnection object that represents the connection to SQLite.
    Remarks
    The following table shows initial property values for an instance of SQLiteCommand.
    Properties Initial value
    CommandText commandText
    CommandTimeout 30
    CommandType System.Data.CommandType.Text
    Connection connection
    Example
    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
    See Also