Use parameter for retrive row and column from a Output Data Table

I have a query that retrive data from a database into a Output data table.
I know how to retrive a specific row/column using DBConnection.Rows(0).Item(0).ToString.

I would like to replace the Rows no. (rNo) and Item no. (cNo) with an input parameter like
SQL_rc = “outSQL.Rows(” + rNo.ToString +“).Item(” + cNo.ToString +“).ToString”

The log message only give me the text “outSQL.Rows(0).Item(0).ToString” and not the value from the datatable.
I am not sure if I am using the correct variable type or how this could be made.
Any suggestions for a solution ??

remove the surrounding doublequotes, as these are making it to a string and not to a VB.Net statement

Hi @Ivan_Trampedach,

May I know you want to display the output of the output data table activity

Okay, why make it more complicated ?

dtSQL.Rows( rNo).Item( cNo)

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