Parameters
- name
- The column name.
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