Parameters
- Name
- Name of the attribute to get value for.
static void ReadData(PgSqlConnection conn) { string str = "SELECT * FROM personnel"; PgSqlCommand pgCommand = new PgSqlCommand(str,conn); PgSqlDataReader pgReader = pgCommand.ExecuteReader(); while (pgReader.Read()) { Console.Write(pgReader.GetInt32(0) + "\t"); PgSqlRow pgRow = pgReader.GetPgSqlRow(1); if (pgRow == null) { Console.WriteLine(); continue; } Console.Write(pgRow[0] + "\t"); Console.WriteLine(pgRow["age"]); } pgReader.Close(); }
Sub ReadData(ByVal conn As PgSqlConnection) Dim str As String = "SELECT * FROM personnel" Dim pgCommand As PgSqlCommand = New PgSqlCommand(str, conn) Dim pgReader As PgSqlDataReader = pgCommand.ExecuteReader() While pgReader.Read() Console.Write(pgReader.GetInt32(0) & Chr(9)) Dim pgRow As PgSqlRow = pgReader.GetPgSqlRow(1) If pgRow Is Nothing Then Console.WriteLine() Else Console.Write(pgRow(0) & Chr(9)) Console.WriteLine(pgRow("age")) End If End While pgReader.Close() End Sub
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2