Select method is not wording for filtering data Table, Please let me Know any another way or solution



Hi , I have Excel data with Columns Name Like “EmpId, Name, Age, Department, Salary, Location”. reference use clicks below Image.

I want to get Data, whose Department is HR. But When I’m using the Select method, Getting error. Please resolve this


Hi @chinnapureddy03

Check if this works for you

Filtred_DT=Your_DT.AsEnumerable().Where(Function(row) row(“Coulmn Name of DT”).ToString=“txt toFilter”).CopyToDataTable()

Below is a related post


This is not working for me. Do we have to import something here ?


@Chand wt error u r getting


Hi @Chand,

Try this syntax:

or simpler:



it worked. thanks