SUM function of sql not returning value..

Question

0.00/5 (No votes)

See more:

hi!! i need to return the sum of price from purchases table, but i am not getting the value...

the value is displayed on label..

this is the code...

string stat = "SELECT SUM(Price)as Price from Purchases WHERE [Month of Purchase] = '" + purch_month + "'";

OleDbCommand cmd = new OleDbCommand(stat, con);

can someone help me with this problem..

Thanks in Advance.. :)

Posted 24-Feb-13 3:53am

Member 7849477

Add a Solution

Comments

braop 24-Feb-13 10:13am

i think problem is with your sql query:
1). if u to display ur values in a label why do u use "as Price"
2). what is [Month of Purchase] is it a field in table purchase or what? use MonthofPurchase
3). the two coats ('') on your purch_month indicate its a string, yet month is supposed to be date

can u try using parametrized queries or look for way to convert purch_month to date

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)

S. M. Ahasan Habib · Answer 1 · 2013-02-24T03:58:00

You do not mention where the problem or find any exception or not. First of all make sure that your sql query is fine. You just retrive stat value from your application by debugging. That stat variable value you copy and directly past it to sqlserver Management studio and see it returns any value or not. If it return value then if you can use cmd.ExecuteScalar method then it will return the sum value.

RedSakura · Answer 2 · 2013-02-24T06:29:00

Solution 2

" [Month of Purchase] "
this is wrong

i dont remember but i guess you shoud use some thing like:
month(Purchase.Date) = something!

Posted 24-Feb-13 6:29am

RedSakura