Parameters
- i
Return Value
The value of the specified column.
Call Devart.Common.DbDataReaderBase.IsDBNull to check for null values before calling this method.
static void GetMyDateTime(PgSqlConnection myConnection) { PgSqlCommand cmd = new PgSqlCommand("SELECT * FROM Test.AllTypes"); cmd.Connection = myConnection; myConnection.Open(); try { PgSqlDataReader reader = cmd.ExecuteReader(); reader.Read(); DateTime recievedDate = reader.GetDateTime(reader.GetOrdinal("DateCol")); reader.Close(); } finally { myConnection.Close(); } }
Shared Sub GetMyDateTime(ByVal myConnection As PgSqlConnection) Dim cmd As New PgSqlCommand("SELECT * FROM Test.AllTypes") cmd.Connection = myConnection myConnection.Open() Try Dim reader As PgSqlDataReader = cmd.ExecuteReader reader.Read() Dim recievedDate As DateTime = reader.GetDateTime(reader.GetOrdinal("DateCol")) reader.Close() Finally myConnection.Close() End Try End Sub