Linq for fetching value from Datatable

[tharaninatarajan1901 (RPALearner)]

Hi

I have datatable with a column called “queueName” and “Maxretries” .I need to take value of Maxreties for given queueName . QueueName will be a variable . I need to used linq for it.

Please help

[tharaninatarajan1901 (RPALearner)]

Hi

I have datatable with a column called “queueName” and “Maxretries” .I need to take value of Maxreties for given queueName . QueueName will be a variable . I need to used linq for it.

Please help

[Anil_G (Anil Gorthi)]

@tharaninatarajan1901

Please try this

dt.AsEnumerable.Where(function(x) x("queueName").ToString.Equals("RequiredQueueName"))(0)("Maxretries").ToString

Assumption is you definitely have the queuename you are searchign in the table

cheers

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

[raja.arslankhan (Raja Muhammad Arslan khan)]

@tharaninatarajan1901

Dt.Select(“[Column1]=‘text’”).ElementAt(0)(“Column2”).ToString

[raja.arslankhan (Raja Muhammad Arslan khan)]

@tharaninatarajan1901
Try this

Dt.Select(“[Column1]=‘text’”).ElementAt(0)(“Column2”).ToString

[ppr (Peter Preuss)]

Duplicate of:

Linq for fetching value from Datatable

Hi I have datatable with a column called “queueName” and “Maxretries” .I need to take value of Maxreties for given queueName . QueueName will be a variable . I need to used linq for it. Please help

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @ppr,
Have merged the two and kept all posts intact. Thanks for spotting