Add column to data table in vb.net

Help Studio
,
1

Hi, because of some complexity in my project, I am using VB.net for a part of my robot (Invoke Code).

With this line, I want to add a column to a data table:
out_dt_TruckAssembling.Columns.Add(“testcol”, GetType(Integer))

out_dt_TruckAssembling is a data table given as an ‘Out’ argument for Invoke Code.
image

But at runtime, it gives this error:

image
image1028×23 1.62 KB

Am I wrong in use of the argument?

2

Hi,

Can you try to add the following at the beginning of the code?

out_dt_TruckAssembling = New DataTable()

Regards,

3

we can do the same within an Assign Activity and avoid the black box code activity

myCol = YourOriginDatTableVar.Columns.Add(“testcol”, GetType(Integer))

otherwise ensure that out_dt_TruckAssembling is initialized with a new DataTable() within the invoke code

4

We can also use Invoke Method for adding columns:

DataTable.Columns (“ColumnName”)) MethodName (SetOrdinal)

Same thing you can do it in your Vb code as well: to add a column

5

This does not work.
But I’ve found a workaround after your suggestion.

  1. Dim dt as New Datatable
  2. Do some things with dt (add columns etc…)
  3. out_dt_TruckAssembling = dt

After that, the argument is loaded in variable dt_TruckAssembling.

For information: imo, the code is to complex to do it all with UiPath activities. Coding it in VB.net makes it more clear.

6

It means out_dt_TruckAssembling hasn’t been initialized. It’s “nothing”

7

Hi,

I think we can directly create instance for out_dt_TruckAssembling as the following sample. Can you try this?

image
image712×552 23.6 KB

Sample20230610-1a.zip (2.5 KB)

Regards,

8

You could have initialized the datatable as well, New System.Data.Datatable.

Thanks.

9

But as mentioned in my first question, I need do program it in Invoke code. It is really dynamic.

10

Thank you, Yoichi. It works now.

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.