LINQ to find a value in a column?

[supermanPunch (Arpan)]

@aquinn

Hi, I have a column called Product Code and a corresponding field called Todays Stock

Hi @aquinn ,

I believe Todays Stock is a row value and corresponding to it you would require the Product Code column’s value. If that is the case, then you can check with the below Expression :

DT.AsEnumerable.Where(Function(x)x(0).ToString.Equals("Todays Stock")).Select(Function(x)x("Product Code").ToString).FirstOrDefault

In the above Expression, we have assumed that the row value Todays Stock will be present in the First Column, and hence we have used the index 0.

For Learnings on Linq, You could check the below Posts :

[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 …

Do Also note that, we have assumed your data representation also, If you could provide us with the Data format or Representation then we could confirm the working.