How to Extract data from System.Data.DataRow type variable

Hello guys,

i am stuck in one issue, need to know the process for how to extract a row of data from a Master data table and after assigning that row to data row data table type of variable how can i access particular column in that data row.

Thanks in advance
-Asha

@asha_TN

DataTable is nothing but array of DataRows.

    dataRow = DataTable (index) 

You can read particular column value from DataRow like below.

           dataRow("ColumnName").Tostring

@asha_TN - Please check follow activity:

1 . Use For Each Row activity and provide Datatable variable as input.
2. You can access the row value row(“ColumnName”).ToString inside For Each row

Cheers

You can also use row(0).ToString
Here “0” is your first column and 1, 2, 3 so on.
It’s useful when your column name changes frequently. And you don’t have to change the column name in the Process.

Thank yo all for your help.

i understand the concept better now:)

-Regards,
Asha