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 sqLiteConnectionString)
{
SQLiteConnection sqLiteConnection = new SQLiteConnection(sqLiteConnectionString);
SQLiteCommand sqLiteCommand = new SQLiteCommand(mySelectQuery, sqLiteConnection);
sqLiteCommand.Connection.Open();
SQLiteDataReader sqLiteReader = sqLiteCommand.ExecuteReader(CommandBehavior.CloseConnection);
while(sqLiteReader.Read())
{
Console.WriteLine(sqLiteReader.GetString(0));
}
sqLiteReader.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(CommandBehavior.CloseConnection)
While sqLiteReader.Read()
Console.WriteLine(sqLiteReader.GetString(0))
End While
sqLiteReader.Close()
End Sub |