Skip to main content

Posts

Showing posts with the label Read data from an AX table using BusinessConnector

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"); ...