dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteCommand Class / ExecuteReader Method / ExecuteReader() Method
Example

On this page
    ExecuteReader() Method
    On this page
    Sends the CommandText to the Connection and builds a SQLiteDataReader.
    Syntax
    'Declaration
     
    Public Overloads Shadows Function ExecuteReader() As SQLiteDataReader
    public new SQLiteDataReader ExecuteReader()

    Return Value

    Example
    The following example creates a SQLiteCommand, then executes it by passing a string that is SQL SELECT statement, and a string to use to connect to the data source.
    public void CreateSQLiteDataReader(string mySelectQuery,string sqLiteConnectionString)
    {
      SQLiteConnection sqLiteConnection = new SQLiteConnection(sqLiteConnectionString);
      SQLiteCommand sqLiteCommand = new SQLiteCommand(mySelectQuery, sqLiteConnection);
      sqLiteCommand.Connection.Open();
      SQLiteDataReader sqLiteReader = sqLiteCommand.ExecuteReader();
      try
      {
        while(sqLiteReader.Read())
        {
          Console.WriteLine(sqLiteReader.GetString(0));
        }
      }
      finally
      {
        sqLiteReader.Close();
        sqLiteConnection.Close();
      }
    }
    Public Sub CreateSQLiteDataReader(mySelectQuery As String, _
    sqLiteConnectionString As String)
      Dim sqLiteConnection As New SQLiteConnection(sqLiteConnectionString)
      Dim sqLiteCommand As New SQLiteCommand(mySelectQuery, sqLiteConnection)
      sqLiteCommand.Connection.Open()
      Dim sqLiteReader As SQLiteDataReader = sqLiteCommand.ExecuteReader()
      Try
        While sqLiteReader.Read()
          Console.WriteLine(sqLiteReader.GetString(0))
        End While
      Finally
        sqLiteReader.Close()
        sqLiteConnection.Close()
      End Try
    End Sub
    See Also