Item Property (DbDataReaderBase)
Gets the value of the specified column in its native format given the column name.
| Overload | Description |
|---|
| Item(String) | Gets the value of the specified column in its native format given the column name. |
| Item(Int32) | Gets the value of the specified column in its native format given the column ordinal. |
static void GetHireDate(PgSqlConnection myConnection) {
PgSqlCommand cmd = new PgSqlCommand("SELECT * FROM Test.emp");
cmd.Connection = myConnection;
myConnection.Open();
try {
PgSqlDataReader reader = cmd.ExecuteReader();
reader.Read();
DateTime recievedTime = (DateTime)reader["hiredate"];
reader.Close();
}
finally {
myConnection.Close();
}
}
Shared Sub GetHireDate(ByVal myConnection As PgSqlConnection)
Dim cmd As New PgSqlCommand("SELECT * FROM Test.emp")
cmd.Connection = myConnection
myConnection.Open()
Try
Dim reader As PgSqlDataReader = cmd.ExecuteReader
reader.Read()
Dim recievedTime As DateTime = CDate(reader("hiredate"))
reader.Close()
Finally
myConnection.Close()
End Try
End Sub