Using in statement inside ADO.Net 2.0

Question

I am using this code to get rows from a datatable but it throws an exception

(Cannot perform '=' operation on System.Guid and System.String)

DataRow[] drows = dt.Select("RefID in('1e1cde8e-28b6-493d-b6ce-d1b81b69e83f','1e1cde8e-28b6-493d-b6ce-d1b81b69e83f')");

PS it works with strings and fails when working with guids.

Your help is appreciated.

 

Answer 1

Try using System.Guid.CompareTo

Answer 2

try

dv.RowFilter = "TypeId in (Convert('<guid>', 'System.Guid'), Convert('<guid>', 'System.Guid'

Hope will be do 

---

Sumit Kumar