Return Value
true if there are more rows; otherwise, false.
While the PgSqlDataReader is in use, the associated PgSqlConnection is busy serving it until you call Close.
public void ReadMyData(string myConnString) { string mySelectQuery = "SELECT DeptNo, DName FROM Test.Dept"; PgSqlConnection pgConnection = new PgSqlConnection(myConnString); PgSqlCommand pgCommand = new PgSqlCommand(mySelectQuery,pgConnection); pgConnection.Open(); PgSqlDataReader pgReader; pgReader = pgCommand.ExecuteReader(); // Always call Read before accessing data. while (pgReader.Read()) { Console.WriteLine(pgReader.GetInt32(0) + ", " + pgReader.GetString(1)); } // always call Close when done reading. pgReader.Close(); // Close the connection when done with it. pgConnection.Close(); }
Public Sub ReadMyData(myConnString As String) Dim mySelectQuery As String = "SELECT DeptNo, DName FROM Test.Dept" Dim pgConnection As New PgSqlConnection(myConnString) Dim pgCommand As New PgSqlCommand(mySelectQuery, pgConnection) pgConnection.Open() Dim pgReader As PgSqlDataReader pgReader = pgCommand.ExecuteReader() ' Always call Read before accessing data. While pgReader.Read() Console.WriteLine(pgReader.GetInt32(0).ToString() + ", " _ + pgReader.GetString(1)) End While ' always call Close when done reading. pgReader.Close() ' Close the connection when done with it. pgConnection.Close() End Sub