Linq replacement for select query

Hi @Amrutha.mg

Try this

DT.AsEnumerable.Where(Function (x) x(str_CurrentVC).ToString.Contains(str_CurrentSCValue)).ToArray

Query version

(From r in DT
Where r(str_CurrentVC).ToString.Contains(str_CurrentSCValue)
Select r).ToArray
1 Like