IN clause in datatable.select
Posted on 2005-04-29
How to use an IN clause in Select method of DataTable.
I have a table with list of entities and parent relation as columns. I populated the rows from database to DataTable. I'm able to use query like below.
Dim Rows as DataRow()
Rows = DataTable.Select("ParentRelation = 'ID1' OR ParentRelation = 'ID2'")
But ultimatly I want to use something like what we do in SQL query
SELECT * FROM table1 WHERE ParentRelation IN ('ID1','ID2')
Any help would be much appreciated.
Thanks in advance