Read data from an AX table using BusinessConnector




Read data from an AX table using BusinessConnector
 using System;  
 using Microsoft.Dynamics.BusinessConnectorNet;  
 namespace ReadAxRecord  
 {  
 class Program  
 {  
 static void Main(string[] args)  
 {  
 Axapta ax;  
 AxaptaRecord record;  
 Object Id, Brand, Year, mile;  
 try  
 {  
 // Create AX object and logon to AX  
 ax = new Axapta();  
 ax.Logon(null, null, null, null);  
 // Create an AxaptaRecord object from the  
 // table that will be used  
 using (record = ax.CreateAxaptaRecord("CarTable"))  
 {  
 // Execute the statement entered as parameter  
 record.ExecuteStmt("select * from %1  
 where %1.test like 'xa'");  
 // Loop through the result of the statement.  
 while (record.Found)  
 {  
 // Set our local variables to be  
 // equal to the fields in the table  
 // for the current record.  
 Id = record.get_Field("ID");  
 Brand = record.get_Field("BRAND");  
 Year = record.get_Field("YEAR");  
 mile = record.get_Field("MILE");  
 // Write the result to the console  
 Console.WriteLine(Id + "\t" +  
 Brand + "\t" +  
 Year + "\t" +  
 mile);  
 // Go to the next record in the result set  
 record.Next();  
 }  
 // End the AX session  
 ax.Logoff();  
 // Make sure the console stays up  
 // until a key is pressed  
 Console.ReadKey();  
 }  
 }  
 catch (Exception e)  
 {  
 Console.WriteLine(e.Message);  
 }  
 }  
 }  
 }