Use datatable select get datarow, however, when I add data column per array, system exception

[Lori (Li)]

I use datatable select get datarow, I want to add result into datarow, however, when I add data column per array, system exception

[Yoichi]

HI,

Can you check if you set DB_SumAPInvNew (not butDB_SumAPInvNewResult) at DataTable property?

And as DR_temp is DataRow array, we need to set index for it because AddDataRow can add only 1 datarow.

Regards,

[Gokul001 (Gokul Balaji)]

HI @Lori

Can you check if the Data Table is initialized. May be DataTable is null.

Check out this thread XAML file for reference

Add Data Row Object reference not set to an instance of an object

Hello @himanshur Try the attached xaml file. TotalDueAmount.xaml (8.9 KB)

This video link is for reference how this issue occur and solving

How to Fix Object Reference Not Set To An Instance of an Object

Regards
Gokul

[Anil_G (Anil Gorthi)]

Hi @Lori

You have to give a structure to db_SumAPInvNewResult so please use assign like this before for loop

Db_SumAPInvNewResult = Db_SumAPInVNew.clone()

Cheers

[Lori (Li)]

@Yoichi @Gokul001 @Anil_G

Thanks, I had initialized. get another error.

[Yoichi]

Hi,

@Yoichi

And as DR_temp is DataRow array, we need to set index for it because AddDataRow can add only 1 datarow.

For now, can you try the following expression at ArrayRow property?

DR_temp(0).ItemArray

If you need to add all items of DR_temp, we need to add ForEach activity and add all the item.

Regards,

[Lori (Li)]

@Yoichi
Yes, It works and only can add one row into datatable, how to get current row index? thanks.

[Yoichi]

Hi,

If need to add all the datarow, can you try either of the following?

Use ForEach

Use MergeDataTable

Regards,

[Lori (Li)]

I use for each and it works well, thanks for your great help!