Class 'System.Data.Datatable' cannot be indexed error

Help
1

Hi experts

I am automating a process that uses a DataTable and DataRow variable. In my workflow I am assigning the DataRow by using the assign activity:

myDataRow = myDataTable(rowCounter)

But I getting the following validation error:

“Class ‘System.Data.DataTable’ cannot be indexed because it has no default property.”

Which default property is the error referring to?

1 Like
2

You forgot the .Rows

myDataRow = myDataTable.Rows(rowCounter)

4 Likes
3

Thanks Karthik

I can see that the validation error is resolved. However I am wondering why that error is not occuring in another process where the .Rows is left out (?)

4

It might be array of data rows not data table.
or the assign activity is used in a loop (so no need to use .Rows)

5

Always make sure the syntax you’re using is correct. As mentioned by @KarthikByggari it must have been an ARRAY of data rows instead of a DATATABLE which is an OBJECT of System.Data.Datatable class.

An array of data rows can be indexed, not a datatable object. However, a datatable would have Rows() as one of its properties which is a collection of Datarow objects, and hence can be indexed.

6

image
image1366×768 106 KB

system.data.datatable cannot be indexed

1 Like
7

Please any help to resolve above issue

8

Use: customerData.Rows(RowNumber)(‘firstname’).tostring

4 Likes
9

Thank you Now its working

10

I am thankful for the solution as well. as i was also getting same error.

i just have one query. why we have received this error and how .Rows rectify that.

thank you

11

this works fine. thanks for the guidance

12

thanks… now it’s working for me