Adding int datatypes in a database table

Question

0.00/5 (No votes)

See more:

Hi,

I have got a SQL database table in which i am querying from in my c# project. The table contains a column that takes in int as a datatype (Employers Age). I am querying from this column and I would like each and every record that is queried from this column to be added up and display the total of the records;

Code:

C#

int AddAge;
string getAge;

    Query = "SELECT * FROM TblEmp WHERE Id = '" + id + "' AND Position = '"+Manager+"'";
                       theReader = conn.ExecuteStatement(Query);
                       while(theReader.Read())
                       getAge = theReader["Age"].ToString();
                       AddAge = int.Parse(getAge);


                     AddAge + getAge;
                      // this is where i am stuck, How can I add up the ages and display the the total?

Posted 31-Mar-14 3:52am

1Future

Add a Solution

Comments

[no name] 31-Mar-14 10:15am

Look up the SQL SUM function.

PIEBALDconsult 31-Mar-14 19:44pm

As others have said, use SUM ; then use ExecuteScalar.

Other than that...

For one thing, your code requires braces around the statements that should be in the while loop.
For another, don't use ToString on the returned value when you know it's an integer -- just cast it -- this avoids the Parse.
For yet another, AddAge + getAge; does nothing even if it compiles at all.

Avoid using SELECT * when you don't actually want all the values.
And finally, you should be using a parameterized query.

2 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)

Peter Leow · Answer 1 · 2014-03-31T04:27:00

Let pause and ask yourself a question, how do you find out the age of a person? His date of birth, right. Age is not constant and is derivable from date of birth which is fixed for each individual. You should be storing date of birth, not age in the database table.
To find the age of a person, simply retrieve his date of birth from the table, do the calculation in code behind based on the current date and you will always get the correct age. In this way, you can sum the ages of all persons in code behind and always get the latest update.

CBadger · Answer 2 · 2014-03-31T04:18:00

Solution 1

If this query is used solely for the total age added together than use that in the query. Otherwise use another query to get only the sum

C#

Query = "SELECT SUM(Age) as totalAge FROM TblEmp WHERE Id = '" + id + "' AND Position = '"+Manager+"'";

When in doubt see w3School[+] ;-)

Posted 31-Mar-14 4:18am

CBadger

Comments

PIEBALDconsult 31-Mar-14 19:35pm

Use a parameterized query.