How to filter the multiple column?

[ppr (Peter Preuss)]

[HowTo] LINQ - First Start # Where Operator

This HowTo introduces how to use the Where operator. Introduction The Where operator is used for filtering. For the filtering, a condition is provided. All items matching this condition will pass the filter and will be part of the returned result. The condition has mandatory to return a boolean outcome. In other words: The result of the condition has to be True or False. Example IPO Samples Comment Values: 20,3,17,22,10,25,5 A collection of Numbers Filter Condition: x > 15 x is th…

A sample Statement could look like:

(From d in dtData.AsEnumerable
Let v1 = d(0).ToString.Trim
Let v2 = CDbl(d("Amount").ToString().Trim)
Let v3 = d("ByPassInfo").toString.Trim
Where v1.Equals("Prio1") And (v2 < 250 Or v3.Equals("Yes"))
Select r = d).CopyToDataTable