SQLiteCommand Class

Visual Basic
C#

'Declaration
 
Public Class SQLiteCommand 
   Inherits Devart.Common.DbCommandBase
   Implements System.ComponentModel.IComponent, System.Data.IDbCommand, System.ICloneable, System.IDisposable

public class SQLiteCommand : Devart.Common.DbCommandBase, System.ComponentModel.IComponent, System.Data.IDbCommand, System.ICloneable, System.IDisposable

The SQLiteCommand class provides the following methods for executing commands against the SQLite database:

Item	Description
ExecuteReader	Executes commands that return rows.
Devart.Common.DbCommandBase.ExecutePageReader	Returns a specific subset of rows when paging through the results of a query.
ExecuteNonQuery	Executes SQL commands such as INSERT, DELETE, UPDATE.
ExecuteScalar	Retrieves a single value (for example, an aggregate value) from a data source.

If execution of the command results in a fatal SQLiteException, the SQLiteConnection may close. However, the user can reopen the connection and continue.

This class supports cross-form data binding with the InterForm Technology.

The following example uses the ExecuteReader method of SQLiteCommand, along with SQLiteDataReader and SQLiteConnection, to select rows from a table.

csharp

public void ReadMyData(string myConnString)
{
  string mySelectQuery = "SELECT DeptNo, DName FROM Dept";
  SQLiteConnection sqConnection = new SQLiteConnection(myConnString);
  SQLiteCommand sqCommand = new SQLiteCommand(mySelectQuery,sqConnection);
  sqConnection.Open();
  SQLiteDataReader sqReader = sqCommand.ExecuteReader();
  try
  {
    while (sqReader.Read())
    {
      Console.WriteLine(sqReader.GetInt32(0).ToString() + ", " + sqReader.GetString(1));
    }
  }
  finally
  {
  // always call Close when done reading.
  sqReader.Close();
  // always call Close when done reading.
  sqConnection.Close();
  }
}

Visual Basic

Public Sub ReadMyData(myConnString As String)
  Dim mySelectQuery As String = "SELECT DeptNo, DName FROM Dept"
  Dim sqConnection As New SQLiteConnection(myConnString)
  Dim sqCommand As New SQLiteCommand(mySelectQuery, sqConnection)
  sqConnection.Open()
  Dim sqReader As SQLiteDataReader = sqCommand.ExecuteReader()
  Try
    While sqReader.Read()
      Console.WriteLine(sqReader.GetInt32(0).ToString() + ", " _
        + sqReader.GetString(1))
    End While
  Finally
      ' always call Close when done reading.
      sqReader.Close()
      ' always call Close when done with connection.
      sqConnection.Close()
  End Try
End Sub

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.Common.DbCommand
            Devart.Common.DbCommandBase
               Devart.Data.SQLite.SQLiteCommand

Reference

SQLiteCommand Members
Devart.Data.SQLite Namespace
SQLiteDataReader Class
SQLiteConnection Class