Converting a Time Value Using the GetDateTime Method

Use the GetDateTime method to convert a time value.

1. Declare and initialize a connection object:

   For C#:

   AseConnection conn = new AseConnection(
      c_connStr );

   For Visual Basic .NET:

   Dim conn As New AseConnection( _
      c_connStr )

2. Open the connection:

   For C#:

   conn.Open();

   For Visual Basic .NET:

   conn.Open()

3. Add a Command object to define and execute a SQL statement:

   For C#:

   AseCommand cmd = new AseCommand( 
      "SELECT title_id, title, pubdate FROM titles", 
      conn );

   For Visual Basic .NET:

   Dim cmd As New AseCommand( _
      "SELECT title_id, title, pubdate FROM titles", _
      conn)

4. Call the ExecuteReader method to return the DataReader object:

   For C#:

   AseDataReader reader = cmd.ExecuteReader();

   For Visual Basic .NET:

   Dim reader As AseDataReader = cmd.ExecuteReader()

   The following code uses the GetDateTime method to return the DateTime value:

   For C#:

   while ( reader.Read() )
   { 
      String tid = reader.GetString(0);
      String title = reader.GetString(1);
      DateTime time = reader.GetDateTime(2);
      // do something with the data
   }

   For Visual Basic .NET:

   While reader.Read()
      Dim tid As String = reader.GetString(0)
      Dim title As String = reader.GetString(1)
      Dim time As DateTime = reader.GetDateTime(2)
      ' do something with the data....
   End While

5. Close the DataReader and Connection objects:

   For C#:

   reader.Close(); 
   conn.Close();

   For Visual Basic .NET:

   reader.Close()
   conn.Close()