Filtering value from datatable with loop taking time

Help Studio
, ,
1

I am using for each row to check value of specific column from datatable and inside loop I am using if condition for checking whether value exists in the datatable or not.

Process is taking time can we do it without loop?

2

Hi,

You can check it with linq query.

Try this:
yourDT.AsEnumerable().Any(Function(x) x(“yourDatatableColumn”).ToString = DesiredValue)

3 Likes
3

Thanks @ghazanfar

4

Hi @lorun_hiper

DataTable.AsEnumerable.Where(Function(dr) Convert.ToString(dr(“YourSearch Column”)) = "YouSearchString")
it will return True Or false based on value exits

If You need to copy the value as datatable or list

DataTable.AsEnumerable.Where(Function(dr) Convert.ToString(dr(“YourSearch Column”)) = "YouSearchString").CopyToDatatable/List

Regards

1 Like
5

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