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 = pgCommand.ExecuteReader();
try
{
while (pgReader.Read())
{
Console.WriteLine(pgReader.GetInt32(0).ToString() + ", " + pgReader.GetString(1));
}
}
finally
{
// always call Close when done reading.
pgReader.Close();
// always call Close when done reading.
pgConnection.Close();
}
}