How can add the Data Scraping Rows Value

[Rajiduraikannu_Santhosh_G (Santhosh)]

Hi All,
I want to add the all rows value. So I Scrape the Data and Stored in ExpectDataTable variable [Varivable type as >> DataTable] How can add the integer rows value?

[Srini84 (Srinivas)]

@Rajiduraikannu_Santhosh_G

I want to add the all rows value. So I Scrape the Data and Stored in ExpectDataTable variable [Varivable type as >> DataTable] How can add the integer rows value?

@Rajiduraikannu_Santhosh_G

You can do this with LinQ function

Check below for your reference

How to add all the values of a column in Datatable by using Linq (without using for each)

Hey @tgopalas, Use this: dt.AsEnumerable().Sum(function(x) x.Amount ) OR dt.AsEnumerable().Sum(function(x) x.Field(“Amount”) )

Hope this will help you

Thanks

[Rajiduraikannu_Santhosh_G (Santhosh)]

i got this error @Srini84

[Srini84 (Srinivas)]

@Rajiduraikannu_Santhosh_G

Okay, write as below

dt.AsEnumerable.Sum(Function(x) Convert.ToInt32(x(“Column1”).ToString).ToString

If this also not works then you can try on second post function

Hope this help you

Thanks

[Rajiduraikannu_Santhosh_G (Santhosh)]

Hi @Srini84 ,
Its working Thnks for ur quick response