I am having a data table (CC_DESC) like below,
I need to filter the data table based on CC column in the above table, for that i used the below query,
filtered_DT = CC_DESC.AsEnumerable().Where(Function(row) row(“CC”).ToString=test_division).CopyToDataTable()
After this i used For each row to read the filtered_DT and its fetching the correct data.
I need to compare this filtered_DT with an existing string. For value 46 in CC column having 3 values, so after did the filtering it returning pepsi,cock and maza for 46.
how i can compare these 3 values against that existing string?
can anyone help me on this?