How to show total of columns ?

Question

0.00/5 (No votes)

See more:

when it Contain String Char & i want it in Decimal eg Datatable Columns Contain Bal and it contain Values (10Dr,20Dr its Record of Column ) and i want only sum of (10+20) then how to get

What I have tried:

I tried this but it contain char DR which give Error object not set
means how to remove char "Dr" from columns value ie 5000Dr i want only 5000 values not 5000Dr..
decimal totalopening = table.AsEnumerable().Sum(row => row.Field<decimal>("Opening"));
gvReport.FooterRow.Cells[1].Text = "Total";
gvReport.FooterRow.Cells[1].HorizontalAlign = HorizontalAlign.Right;
gvReport.FooterRow.Cells[2].Text = totalopening.ToString("N2");

Posted 11-Apr-16 1:01am

Beginers*Devloper

Updated 11-Apr-16 3:34am

Add a Solution

1 solution

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)

Arvind Zamakia · Answer 1 · 2016-04-11T03:34:00

Solution 1

Grid View in Used template columns. and add Label then code behind to gridrowDatabown Event in add Calculation this and fined control to assign values.

Posted 11-Apr-16 3:34am

Arvind Zamakia

Comments

Beginers*Devloper 12-Apr-16 0:20am

But i want only sum of numbers not char it contain value 100Dr ,200Dr then how to remove this "Dr" and geting sum of this columns...

Beginers*Devloper 12-Apr-16 0:22am

ie columns Bal contain value(100Dr,200Dr) and i want sum (100+200) ..300
Bal
100Dr
200Dr
300...i except this300 ans

Arvind Zamakia 12-Apr-16 8:13am

following example help full

string sample ="100Dr";
sample = sample.replace("Dr","");

integer amount1 = convert.int32(sample );