EMPDT.Select(“[Department]='IT’or [Department]=‘Finance’ AND [Salary]<20000”).CopyToDataTable
I use the above query but I am getting output that is not correct. Where is my Mistake will someone please help me
Name,Date of Joining,Department,Salary
Can you try the following expression?
EMPDT.Select("([Department]='IT'or [Department]='Finance') AND [Salary]<20000").CopyToDataTable
Thanks Your query is working and issue resolved
EMTP.Select(“[Department]='IT’ or [Department]=‘Finance’ )AND ([Salary]<20000”).CopyToDataTable