How to check for specific condition in data table

[ppr (Peter Preuss)]

@T_Y_Raju

i want all the values to checked in column 0 and if none of the values does not match then it should throw business exception

we can use LINQ ALL / Any Operator

[HowTo] LINQ – First Start # Any Operator

Introduction The “Any” operator is one of the quantifier operators in LINQ used to check if at least one element of a collection satisfies a given condition or not. If the condition is satisfied for at least one item within the collection, the outcome of the Any operator is true. Otherwise, the outcome from the Any operator is false. The evaluation condition must be mandatory to return a Boolean outcome. In other words: The result of the condition has to be True or False.

API Details

<a c…

[HowTo] LINQ – First Start # All Operator

Introduction The “All” operator is a quantifier operator in LINQ used to check if each element from the collection satisfies a given condition or not. If the condition is satisfied for each element within the collection, the outcome of the operator is true. Otherwise, the outcome is false The evaluation condition must be mandatory to return a Boolean outcome. In other words: The result of the condition has to be True or False. API Details

Summary

<a class="lightbox" href="…

Assign Activity

chkResult | Boolean =
dt_FirmName.AsEnumerable().Any(Function (x) Not x(0).toString.Trim.toUpper.Equals(“MCG…”))

Here we just looked for any value which is not MCG value. So we can tell, that not all values are MCG…

Then we can use an If Activity and evaluate chkResult

Kindly note:

toUpper has to check MSGILB…