Close Method (PgSqlDataReader)
The following example creates a
PgSqlConnection, a
PgSqlCommand, and a
PgSqlDataReader. The example reads through the data, writing it out to the console. Finally, the example closes the
PgSqlDataReader, then the
PgSqlConnection.
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