// Create the .NET Business Connector objects.
Axapta ax;
AxaptaRecord axRecord;
string tableName = "AddressState";

// The AddressState field names for calls to
// the AxRecord.get_field method.
string strNameField = "NAME";
string strStateIdField = "STATEID";

// The output variables for calls to the 
// AxRecord.get_Field method.
object fieldName, fieldStateId; 

try
{
    // Login to Microsoft Dynamics AX.
    ax = new Axapta();
    ax.Logon(null, null, null, null);

    // Create a query using the AxaptaRecord class
    // for the StateAddress table.
    using (axRecord = ax.CreateAxaptaRecord(tableName));
    {

        // Execute the query on the table.
        axRecord.ExecuteStmt("select * from %1");

        // Create output with a title and column headings
        // for the returned records.
        Console.WriteLine("List of selected records from {0}",
            tableName);
        Console.WriteLine("{0}\t{1}", strNameField, strStateIdField);

        // Loop through the set of retrieved records.
        while (axRecord.Found)
        {
            // Retrieve the record data for the specified fields.
            fieldName = axRecord.get_Field(strNameField);
            fieldStateId = axRecord.get_Field(strStateIdField);

            // Display the retrieved data.
            Console.WriteLine(fieldName + "\t" + fieldStateId);

            // Advance to the next row.
            axRecord.Next();
        }
    }
}

catch (Exception e)
{
    Console.WriteLine("Error encountered: {0}", e.Message);
    // Take other error action as needed.
}