LINQ - Sum of numbers stored as string

Question

0.00/5 (No votes)

See more:

Name Price
A ABC
B CBA
C 20
D 22
F 12
G 32
H 12

datatable will get thease value but i want to get the sum of Price column.when ever string value will be in row, It would be consider as a 0, Please provide solution for this.

Thanks,
Amod Kumar

Posted 29-Oct-12 0:18am

Amod72

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andreas Gieriet · Answer 1 · 2012-10-29T12:15:00

The following LINQ statement sums the values that can be converted into an int:

C#

DataTable dt = ...
...
string col = "Price";
int sum = dt.AsEnumerable()
            .Aggregate(0,(n, r)=>
               {
                   int v;
                   return int.TryParse((r[col] as string) ?? string.Empty, out v)
                          ? n + v 
                          : n;
               }
             );

Or a bit easier to read:

C#

DataTable dt = ...
...
int sum = dt.AsEnumerable().Aggregate(0,(n,r)=>PriceField(r)+n);
...
static int PriceField(DataRow r)
{
    int v;
    return int.TryParse((r["Price"] as string) ?? string.Empty, out v) ? v : 0;
}

Or a further alternative:

C#

DataTable dt = ...
...
int sum = dt.AsEnumerable().Aggregate(0,SumPriceField);
...
static int SumPriceField(int n, DataRow r)
{
    int v;
    return int.TryParse((r["Price"] as string) ?? string.Empty, out v) ? n + v : n;
}

Cheers
Andi

Amod72 · Answer 2 · 2012-10-29T20:12:00

Solution 3

SQL

double SgAmount = (from DataRow row in dt.Rows
                            where Double.TryParse(row.Field<string>("Test"), out total_SG) == true
                            select total_SG).Sum();

Posted 29-Oct-12 20:12pm

Amod72

Street Racers · Answer 3 · 2012-10-29T00:30:00

The following is the complete working and tested sample code.

C#

public static void main()
{
DataTable dt = new DataTable();
            dt.Columns.Add("Price");
            var dr = dt.NewRow();
            dr["Price"] = "12";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["Price"] = "A1";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["Price"] = "1";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["Price"] = "2";
            dt.Rows.Add(dr);

            var sum = (from datarow in dt.AsEnumerable()
                       where (Program.NullableTryParseInt32(datarow["Price"].ToString()) != null)
                       select datarow["Price"]).ToArray().Sum(x => Convert.ToInt32(x));
}

C#

public static int? NullableTryParseInt32(string text)
       {
           int value;
           return int.TryParse(text, out value) ? (int?)value : null;
       }

let me know whether this solved your problem.

Amod72 · Answer 4 · 2012-10-29T20:33:00

Solution 4

SQL

double SgAmount = (from DataRow row in dt.Rows
                            where Double.TryParse(row.Field<string>("Test"), out total_SG) == true
                            select total_SG).Sum();

Thanks a lot Rajkumar_N and andy

Posted 29-Oct-12 20:33pm

Amod72

Comments

Andreas Gieriet 30-Oct-12 12:08pm

Why post twice and why post a solution to your answer yourself?
Please remove at least one of these.
Andi

LINQ - Sum of numbers stored as string

4 solutions

Solution 2

Solution 3

Solution 1

Solution 4

Add your solution here

Preview 0