ExecuteReader(CommandBehavior) Method
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. The
System.Data.CommandBehavior is then set to CloseConnection.
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(CommandBehavior.CloseConnection);
while(sqReader.Read())
{
Console.WriteLine(sqReader.GetString(0));
}
sqReader.Close();
}
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(CommandBehavior.CloseConnection)
While sqReader.Read()
Console.WriteLine(sqReader.GetString(0))
End While
sqReader.Close()
End Sub