Filter column A and check if column B starts with "ABC"

[iamthejuan (Herb)]

Hi friends, is there a fast way of doing this using LINQ or select?

E.g.
Column A | Column B
Solid | Hello
Solid | World
Liquid | It’s
Liquid | Been
Gas | A
Gas | While

Filter Column A to Solid and check if Column B contains value that starts with “Wo”.

I need to filter Column A with Solid.

[ppr (Peter | MVP)]

@iamthejuan
give a try on following:

(From d In yourDtVar.AsEnumerable
Where d(0).toString.Trim.Equals(“Solid”) And d(1).toString.Trim.StartsWith(“Wo”)
Select d).toList

returning a list of datarows (e.g. assignment to variable: drResult)

with drResult.Count > 0 you can check if there was a result returned back or not and get a datatable
true: drResult.CopyToDataTable
false: yourDtVar.Clone

[iamthejuan (Herb)]

Thank you Peter @ppr!