Convert AX table to System.Data.DataTable in AX2012

(0) Share

Report

Posted on by DanielBai

Hi Experts,

For using System.Windows.Forms.DataGridView in AX2012 form, I need to set the DataSource property for DataGridView, but the only way I got know is set the Column value in each row, it's very inefficient, is there any way to direct convert a AX table instance to System.Data.DataTable instance, so that I can set it to property DataSource of DataGridView.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi DanielBai,

Why do you need this control? What is the difference with the default grid control provided within the AOT?

Was this reply helpful? Yes No
Rudi Hansen 4,075 on at

Like (0)

Report

I am pretty sure there is no standard method to convert an AX table into System.Data.DataTable, especially since it would in some way have to handle how meany records you actually need to show in the DataGridView, and how would it know that?

So to get this done you would have to write your own converter, and I am not saying that could not be done, but again like André says WHY?

Was this reply helpful? Yes No
DanielBai 30 on at

Like (0)

Report

Since there's a requirement that need freeze the first column(or first several columns) of grid, just like in excel, to fulfill this requirement, we need to use DataGridView

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Would the (free) workaround be to export the contents to Excel and freeze it there?

Was this reply helpful? Yes No