ExecuteReader() Method

In This Topic

Sends the CommandText to the Connection and builds a SQLiteDataReader.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shadows Function ExecuteReader() As SQLiteDataReader

public new SQLiteDataReader ExecuteReader()

Return Value

A SQLiteDataReader object.

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.

csharp

public void CreateSQLiteDataReader(string mySelectQuery,string sqConnectionString)
{
  SQLiteConnection sqConnection = new SQLiteConnection(sqConnectionString);
  SQLiteCommand sqCommand = new SQLiteCommand(mySelectQuery, sqConnection);
  sqCommand.Connection.Open();
  SQLiteDataReader sqReader = sqCommand.ExecuteReader();
  try
  {
    while(sqReader.Read())
    {
      Console.WriteLine(sqReader.GetString(0));
    }
  }
  finally
  {
    sqReader.Close();
    sqConnection.Close();
  }
}

Visual Basic

Public Sub CreateSQLiteDataReader(mySelectQuery As String, _
sqConnectionString As String)
  Dim sqConnection As New SQLiteConnection(sqConnectionString)
  Dim sqCommand As New SQLiteCommand(mySelectQuery, sqConnection)
  sqCommand.Connection.Open()
  Dim sqReader As SQLiteDataReader = sqCommand.ExecuteReader()
  Try
    While sqReader.Read()
      Console.WriteLine(sqReader.GetString(0))
    End While
  Finally
    sqReader.Close()
    sqConnection.Close()
  End Try
End Sub

Reference

SQLiteCommand Class
SQLiteCommand Members
Overload List
SQLiteDataReader Class
SQLiteConnection Class

Send Feedback