I am trying to filter data using select query

this what i am doing and getting error

  1. reading the excel
  2. saving it to dt
    3 the new dt = readdt.Select("[ScenarioName] = ‘AddressValidation’").CopyToDataTable

what i want to do if under ScenarioName AddressValidation is persent then i have to save it new dt

Hi @manojv02500

The function you have written is right but Strange is you re not getting any results.

Try like below!

dt.AsEnumerable().Where(Function(r) r(“ScenarioName”).ToString.Equals(“AddressValidation”)).CopyToDatatable

Regards

1 Like

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