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; sqReader = sqCommand.ExecuteReader(); // Always call Read before accessing data. while (sqReader.Read()) { Console.WriteLine(sqReader.GetInt32(0) + ", " + sqReader.GetString(1)); } // always call Close when done reading. sqReader.Close(); // Close the connection when done with it. 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 sqReader = sqCommand.ExecuteReader() ' Always call Read before accessing data. While sqReader.Read() Console.WriteLine(sqReader.GetInt32(0).ToString() + ", " _ + sqReader.GetString(1)) End While ' always call Close when done reading. sqReader.Close() ' Close the connection when done with it. sqConnection.Close() End Sub