how to sum values per row in datagrid view?

Question

0.00/5 (No votes)

See more:

Hi Experts,

How can i possibly add every row values for two column then the result could be in the next or third column in datagridview. vb.net

Thank you in advance,

Raz

Posted 8-Dec-15 18:47pm

craft_trone

Add a Solution

Comments

Animesh Datta 9-Dec-15 1:13am

what have u tried ?

craft_trone 9-Dec-15 2:43am

my code only add all rows in a column, all i want is, add only a row from two columns.

MayurDighe 9-Dec-15 15:36pm

show your code...

craft_trone 9-Dec-15 20:40pm

this is my code @MayurDighe:

Private Sub LoadForPayroll()
Dim totalAmount As Double
Try
sqL = "SELECT remittance_no, remit_date, messenger, item, item_value, rate.product, rate.product_value FROM remittance INNER JOIN rate ON rate.product=remittance.item where rate.ratecode =@rcde and remittance.messenger =@msgr and remit_date between @dfrom and @dto"
ConnDB()
cmd = New MySqlCommand(sqL, conn)
cmd.Parameters.AddWithValue("@rcde", txtRateCode.Text)
cmd.Parameters.AddWithValue("@msgr", txtMessenger.Text)
cmd.Parameters.AddWithValue("@dfrom", dtFrom.Value.Date)
cmd.Parameters.AddWithValue("@dto", dtTo.Value.Date)
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
dgw.Rows.Clear()
totalAmount = 0
Do While dr.Read = True
dgw.Rows.Add(dr("remittance_no"), dr("remit_date"), dr("messenger"), dr("item"), dr("item_value"), dr("product_value"))
totalAmount += (dr("product_value") * dr("item_value"))
Loop
lblTotal.Text = Format(totalAmount, "#,##0.00")
Catch ex As Exception
MsgBox(ex.Message)
Finally
cmd.Dispose()
conn.Close()
End Try
End Sub

craft_trone 9-Dec-15 20:21pm

this is my code @MayurDighe:

Private Sub LoadForPayroll()
Dim totalAmount As Double
Try
sqL = "SELECT remittance_no, remit_date, messenger, item, item_value, rate.product, rate.product_value FROM remittance INNER JOIN rate ON rate.product=remittance.item where rate.ratecode =@rcde and remittance.messenger =@msgr and remit_date between @dfrom and @dto"
ConnDB()
cmd = New MySqlCommand(sqL, conn)
cmd.Parameters.AddWithValue("@rcde", txtRateCode.Text)
cmd.Parameters.AddWithValue("@msgr", txtMessenger.Text)
cmd.Parameters.AddWithValue("@dfrom", dtFrom.Value.Date)
cmd.Parameters.AddWithValue("@dto", dtTo.Value.Date)
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
dgw.Rows.Clear()
totalAmount = 0
Do While dr.Read = True
dgw.Rows.Add(dr("remittance_no"), dr("remit_date"), dr("messenger"), dr("item"), dr("item_value"), dr("product_value"))
totalAmount += (dr("product_value") * dr("item_value"))
Loop
lblTotal.Text = Format(totalAmount, "#,##0.00")
Catch ex As Exception
MsgBox(ex.Message)
Finally
cmd.Dispose()
conn.Close()
End Try
End Sub

CHill60 11-Dec-15 11:40am

Your comments don't match up with your question - do you want this total calculated for every row and shown in an additional column OR do you want the total across all rows displayed in a label?

craft_trone 11-Dec-15 22:13pm

I want a total calculated for every row and shown in an additional column

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)

CHill60 · Answer 1 · 2015-12-12T01:01:00

Thank you for clarifying the requirement.

If you want the additional data then you can do the calculation in the sql rather than within the gridview i.e.

VB

sqL = "SELECT remittance_no, remit_date, messenger, item, item_value, rate.product, rate.product_value, rate.product_value * item_value as total_value FROM remittance INNER JOIN rate ON rate.product=remittance.item where rate.ratecode =@rcde and remittance.messenger =@msgr and remit_date between @dfrom and @dto"

and then

VB

dgw.Rows.Add(dr("remittance_no"), dr("remit_date"), dr("messenger"), dr("item"), dr("item_value"), dr("product_value"), dr("total_value"))
 'not required now totalAmount += (dr("product_value") * dr("item_value"))

Note that instead of the loop you can populate the DataGridView semi-directly from the reader using a DataTable :

C#

Dim dt = new DataTable()
dt.Load(dr)
dgw.AutoGenerateColumns = True
dgw.DataSource = dt
dgw.Refresh()

(credit[^])