Represents a SQL statement to execute against SQLite.
The following example uses the
ExecuteReader method of
SQLiteCommand, along with
SQLiteDataReader and
SQLiteConnection, to select rows from a table.
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();
}
}
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