how to count a column name quantity yearwise and display it in gridview.

Question

0.00/5 (No votes)

See more:

how to count(sumtotal)of a certain field say quantity depending on year wise.

suppose i have 1 table name facsort and in that i have columns as qty,date,name etc.

now in 2013 year end, how many qty has been inserted in database, i want to display it in gridview.

i dont want month wise how many qty are inserted.

please kindly help.

i will be highly obliged.
thanks in advance.

Posted 15-Jul-13 18:34pm

sudeshna from bangkok

Add a Solution

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)

Abhinav S · Answer 1 · 2013-07-15T18:39:00

Solution 1

You can do this at the query level itself. Just run a total for the year within the query by using a subquery.

E.g.

select *, (select sum(qty) from table where data > '2013/01/01' from table)

Posted 15-Jul-13 18:39pm

Abhinav S

Comments

sudeshna from bangkok 16-Jul-13 1:02am

shall i write this query under combobox_selectedindexchanged?

sudeshna from bangkok 16-Jul-13 1:03am

can you give me the full subquery, the example which you gave is not working

sudeshna from bangkok 16-Jul-13 1:35am

Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
'Dim da As New SqlDataAdapter
Dim cmd As New SqlCommand
Dim ds As New DataSet

'Try

cmd.Connection = cn
cn.Open()

Dim da As New SqlDataAdapter("select count(qty)from facsort group by return_dt", cn)
ds = New DataSet
da.Fill(ds, "facsort")
For i As Integer = 0 To ds.Tables("facsort").Rows.Count - 1
If ComboBox2.SelectedItem = ds.Tables("facsort").Rows(i).Item("type").ToString() Then
TextBox1.Text = ds.Tables("facsort").Rows(i).Item("qty").ToString()
TextBox2.Text = ds.Tables("facsort").Rows(i).Item("wt_rtn").ToString()
End If
Next
cn.Close()

sudeshna from bangkok 16-Jul-13 1:54am

can you just expand the subquery?

**Nirav Prabtani** · Answer 2 · 2013-07-15T19:29:00

Solution 2

SQL

select count(qnt) from facsort group by DATEPART(yyyy, date )

Posted 15-Jul-13 19:29pm

Nirav Prabtani

Updated 15-Jul-13 19:41pm

v2

Comments

sudeshna from bangkok 16-Jul-13 1:35am

i have written this code. but showing error

sudeshna from bangkok 16-Jul-13 1:36am

i dont have any column as such only year. i have return_dt but it takes value from datetimepicker.

Nirav Prabtani 16-Jul-13 1:42am

I am not sure but,
try updated solution