I have a data table
I need to fill value from the above datatable into a another excel under each city based on the ID
the excel looks like below
Need Linquery or someother best approach
I have a data table
I need to fill value from the above datatable into a another excel under each city based on the ID
the excel looks like below
Need Linquery or someother best approach
You can apply filter based on the Id (or) you can apply filter using select.
Example -
dataTable.select(Id=‘value’)// get rows
//iterate rows using for each - you can get row and stored in a varabe item
item.ItemArray(0) - you get 1st column value
This iteration is time consuming…can u pls suggest linquery