Using DotNet DataTable in C/AL

viperk · 2011-03-14

Hi,

I'm trying to send a datatable from a C# app. to a codeunit in NAV.
My problem is that i can't figure out how to use the Rows property on my datatable.
I would like to select a specific column by using this syntax (in C/AL)

myCALVariable := myDataTableFromDotNet.Rows.ToString();

but when i compile i get a compilation error saying that the Rows variabel is defined with fewer dimensions. Is there a way around this or shouldn't i use datatables from dotnet in my c/al code?

thanks in advance

ara3n · 2011-03-14

One thing I've seen is that methods that are overloaded, they appear as separate lines when you hit F5. And you select the one with correct parameters.
You might have selected the wrong one. Or probably just pasted your code? I would try that.

viperk · 2011-03-14

The exception comes from the property "Rows" not a method.
And there is only one "Rows" property to choose. This property returns a collection, but when using it in C# i can also call it with an index (Rows[x]) to retrieve a specific column.
But i don't seem to be able to use this index in C/AL.

smalkmus · 2011-03-14

This may not be much help but we had a similar problem trying to consume .net arrays because we could not access the array index. What we ended up doing was creating a wrapper DLL that adding a methods to return the size of the array and added getObject(int i) and setObject(object o, int i) methods for getting and setting objects. A similar approach might be an option for you if you can't find another way of consuming the data table in C/AL.

kine · 2011-03-14

Try to search for method ".Value(index)" or ".Item(index)" instead [] operator.

viperk · 2011-03-16

thanks a lot! I'll try your suggestions

henrikm · 2011-03-24

As suggested by kine you have to use the Item() method, the [] will not work in C/AL.

/henrik

Using DotNet DataTable in C/AL

Comments

Categories