I Want to add values inside the datatable

Question

0.00/5 (No votes)

See more:

hi
i'm having values like
datatable dt;

C#

dt.row[0][0]=10,
dt.row[0][1]=20,
dt.row[0][2]=30,
dt.row[0][3]=40,
dt.row[0][4]=50,
dt.row[0][5]=60, //and soon....

now i want to add all the values in the datatable of different rows of first column...

i.e 10+20+30+........

can any one tell me how to do this thing...

Posted 30-Nov-11 22:10pm

surikarthi

Updated 30-Nov-11 22:24pm

Eduard Lu

v2

Add a Solution

Comments

[no name] 1-Dec-11 4:24am

EDIT: added "pre" tag

5 solutions

Solution 2

There are loads of ways!
The simplest to understand is:

C#

DataTable dt;
...
DataRow dr = dt.Rows[0];
int sum = 0;
foreach (object o in dr.ItemArray)
    {
    if (o is int)
        {
        sum += (int)o;
        }
    }

C#

for (int i = 0; i < dt.Rows.Count; i++)
                {
                   if (dt.Rows[i][1].ToString() != null)
                   {
                       string yy = dt.Rows[i][1].ToString();
                       count = yy + count;
                  }

                }

"but row[0][1] value not adding with the row[1][1] value.."
Try:

C#

int count = 0;
for (int i = 0; i < dt.Rows.Count; i++)
    {
    if (dt.Rows[i][1].ToString() != null)
       {
       count += (int) dt.Rows[i][1];
       }
    }

Posted 30-Nov-11 22:22pm

OriginalGriff

Updated 30-Nov-11 23:25pm

v2

Comments

surikarthi 1-Dec-11 4:34am

for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][1].ToString() != null)
{
string yy = dt.Rows[i][1].ToString();
count = yy + count;
}

}

but row[0][1] value not adding with the row[1][1] value..

OriginalGriff 1-Dec-11 5:25am

Answer updated

Solution 1

Its very very simple, you just need to put 2 FOR loops, 1 for rows and other for columns.
If you want addition of rows of only first column, you can use only 1 FOR loop.

Posted 30-Nov-11 22:21pm

nagendrathecoder

Comments

surikarthi 1-Dec-11 4:26am

sir already i'm following this manner..
but row[0][1] value not adding with the row[1][1] value...

for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][1].ToString() != null)
{
string yy = dt.Rows[i][1].ToString();
count = yy + count;
}

}

nagendrathecoder 1-Dec-11 4:33am

Do you want to add those integers or make a string of those numbers?
Take that string yy outside FOR loop.

surikarthi 1-Dec-11 4:38am

those number are dynamic we cant tell which number is coming next...

those numbers are taking from the db

nagendrathecoder 1-Dec-11 4:52am

What is count? is it a string variable?
try this:
count = count + yy;

surikarthi 1-Dec-11 5:11am

can u tell the correct manner...

if v write a=a+b or a=b+a both r same...

nagendrathecoder 1-Dec-11 5:14am

Thats why i asked you whether count is string or integer?
in the above case (a and b), if a and b are integers then both equations will be same. But if a and b are string then both quations will produce different result.

surikarthi 1-Dec-11 5:18am

those are integers....

nagendrathecoder 1-Dec-11 5:20am

But in your program, you are converting to string and then adding it to count, which means count variable has to be string.
Please clear me what are you intends to do then i can guide you.

surikarthi 1-Dec-11 5:29am

i'm having table many rows and 2 columns that stores values
1 23546.00
2 4567.00
3 45678.00
now i'm reading the those values to the datatable from the db and i want to add the row[0][1]+row[1][1]+row[2][1]+row[3][1]+....
by this i noticed column number will be same and rows are increasing...
now i want to add all the values i.e 23546.00 + 4567.00 + 45678.00+.....

can u help me how to do this...

nagendrathecoder 1-Dec-11 5:48am

Check my other solution, hope it'll solve ur problem.

Solution 3

C#

var sum = dt.AsEnumerable().Sum(x=>x.Field<int>("SomeProperty"));

Posted 30-Nov-11 22:28pm

Anuj Banka

Comments

surikarthi 1-Dec-11 5:19am

can u tell me Someproperty means.... from where ur passing this...

Anuj Banka 1-Dec-11 6:09am

Means Your Column name which you want.Just give the column name of the table.And in one shot it will give you the sum

Solution 9

<pre lang="c#">
//for this question we have different type of method.check the //below simple example

DataTable table = new DataTable();
table.Columns.Add("value", typeof(int));
table.Rows.Add(10);
table.Rows.Add(20);
table.Rows.Add(30);
table.Rows.Add(40);
table.Rows.Add(50);

foreach (DataRow drr in table .Rows)
{
console.writeline(drr["value"].ToString());
}
</pre>

Posted 1-Dec-11 19:29pm

ganeshbdas

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)

nagendrathecoder · Accepted Answer · 2011-11-30T23:48:00

Solution 8

Try this:

int count = 0;
for (int i = 0; i < dt.Rows.Count; i++)
                {
                   if (dt.Rows[i][1] != null)
                   {
                       int yy = Convert.ToInt32(dt.Rows[i][1]);
                       count = count + yy;
                  }
                           
                }

Posted 30-Nov-11 23:48pm

nagendrathecoder

Comments

surikarthi 1-Dec-11 5:50am

i have try this also but i'm not getting...

nagendrathecoder 1-Dec-11 5:52am

What error are you getting?
I tried it and i am getting perfect results.

surikarthi 1-Dec-11 5:58am

ya its working... Thank q sir... :)

thanks to all who helped me...

nagendrathecoder 1-Dec-11 6:00am

You welcome. Mark it as answer if this solves your problem.

surikarthi 1-Dec-11 6:01am

before i'm writing in this way
int yy = Convert.ToInt32(dt.Rows[i][1].ToString());
that time i got this below error..

Input string was not in a correct format.