sorting by month & adding the column value

Question

0.00/5 (No votes)

See more:

i am doing a c# project i working with visual studio and i have a winform in that there is two combobox the first is of month and second is of year and a button by the side. and i have a table. in that table there is two column named "date" which is having datatype smalldatetime. and another is "price" which is varchar when the button is clicked i want that according to the month and year it checkes the table and display the total sum of the column of price in a label. is that possible to do? i am not using any datagrid or anything dataview such type. i am using a label to display can i calculate and show the sum?

Posted 15-Jan-13 2:46am

shaikh-adil

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)

MT_ · Accepted Answer · 2013-01-15T02:54:00

Solution 1

Following query may help

SQL

select sum(price)
from yourtable
where
datepart(mm,yourDateColumn)=yourMonthSelected
and
datepart(yy,yourDateColumn)=yourYearSelected

Don't have SQL access at present, so check syntax, though logically thsi si correct

Hope that helps
Milind

Posted 15-Jan-13 2:54am

MT_

Comments

Hemant Singh Rautela 15-Jan-13 9:12am

datepart(), it returns numeric value

For Detail

http://msdn.microsoft.com/en-us/library/ms174420.aspx

MT_ 15-Jan-13 9:15am

Yes Hemantrautela, it will return integer. OP hasn't made clear what heshe has got in the combobox though. But you can always convert in to number.

shaikh-adil 15-Jan-13 9:44am

sir i am using entity framework. Then it will help? This query can be used to display sum in a label.text?

Hemant Singh Rautela 15-Jan-13 10:29am

Why not try it yourself...

It is valid sql query & you get the sum of price. then you can use this value anywhere...

shaikh-adil 15-Jan-13 12:45pm

sir your answer is correct (thank you really for helping me and newbies) can you further help me that can i count the total number of rows in that column? what i have to made changes?