Hi, I have a datatable, in which have to get the count of a value available in particular column. Kindly suggest a Linq Query to this scenario. Thanks in advance

Hi, Can you try the following expression? dt.AsEnumerable.Count(Function(r) r("Invoice Number").ToString="INV002") Regards,

Linq Query to get the count of a value in particular column of datatable

nithyac (Nithyac) October 21, 2021, 7:05am 3

Hi,

Thank you for your response

Consider that i need to get the count of invoice number INV002 in this Data table.

Filter the Column Values and get it Count in linq

Topic		Replies	Views
Count is similar names present in the list and save it as datatable Activities datatable , excel , selector , uiautomation , orchestrator , robot , activities , studio , data_scraping , studiox , question , activities_panel , linq , linq-query , linq-quey	6	932	January 11, 2023
How to count row in specific column (Column C)? Help excel , activities , question	6	6014	January 12, 2021
Count of a column in excel Activities excel , activities , question	5	2208	July 26, 2021
How to get the number of rows in a particular Column in Datatable Activities excel , activities , question	11	2636	April 27, 2023
How to get the count of each unique value occurrences in data table column using linq query? Studio studio , question	3	872	August 2, 2023