Retrieving data using SELECT

Execute a SELECT statement to retrieve information from an UltraLite database and handle the result set that is returned.

Prerequisites

There are no prerequisites for this task.

Task

Declare a ULCommand object to holds the query.
ULCommand cmd;

Assign a statement to the object.

cmd = conn.CreateCommand();
cmd.CommandText = "SELECT MyColumn FROM MyTable";

Execute the statement.

Query results can be returned as one of several types of objects. In this example, a ULDataReader object is used.

ULDataReader customerNames = cmd.ExecuteReader();
int fc = customerNames.GetFieldCount();
while( customerNames.MoveNext() ) {
  for ( int i = 0; i < fc; i++ ) {
    System.Console.Write(customerNames.GetString( i ) + " " );
  }
  System.Console.WriteLine();
}

Results

The result of the SELECT statement contains a string, which is then output to the command prompt.

Discuss this page in DocCommentXchange.