Marge and add two row's value in datagridview

Question

0.00/5 (No votes)

See more:

i have a datagridview in vb2010 and have some coman value in it . i want to add those value and make it as a one singal row

i have a ex. i have a view who looks like :

name quantity unit

poteto 5 kg
poteto 10 gm
beance 10 gm
poteto 1 kg

here name quantiy and unit are three colams
But i want that its must bi looks like

name quantity unit

poteto 6.10 kg
beance 10 gm

anyone please provide a ex. or code , thanks
i am using vb2010 and sql2008

Posted 5-Aug-12 19:05pm

Vipin Sharma

Updated 5-Aug-12 19:06pm

v2

Add a Solution

Comments

AshishChaudha 6-Aug-12 1:41am

What you have tried so far...

Vipin Sharma 6-Aug-12 4:32am

please have a look , i use this code for add row's value bt it don't work properly

Private Sub calculateIngradient_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim a, b As String
For i = 0 To DataGridView1.RowCount - 1
a = DataGridView1.Rows(i).Cells(0).Value
For j = 0 To DataGridView1.RowCount - 1
b = DataGridView1.Rows(j).Cells(0).Value
If a = b Then
DataGridView1.Rows(i).Cells(1).Value = DataGridView1.Rows(i).Cells(1).Value + DataGridView1.Rows(j).Cells(1).Value
DataGridView1.Rows(i).Cells(2).Value = DataGridView1.Rows(i).Cells(2).Value & " / " & DataGridView1.Rows(j).Cells(2).Value
DataGridView1.Rows.Remove(DataGridView1.Rows(j))

End If
Next
Next
End Sub

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 · Accepted Answer · 2012-08-05T20:08:00

Solution 3

You can do a concatenation in your query results itself.

Posted 5-Aug-12 20:08pm

Abhinav S

Comments

Vipin Sharma 6-Aug-12 4:19am

i am trying this code for add the values of datagrid view
but it give some error can u solve that

Private Sub calculateIngradient_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim a, b As String
For i = 0 To DataGridView1.RowCount - 1
a = DataGridView1.Rows(i).Cells(0).Value
For j = 0 To DataGridView1.RowCount - 1
b = DataGridView1.Rows(j).Cells(0).Value
If a = b Then
DataGridView1.Rows(i).Cells(1).Value = DataGridView1.Rows(i).Cells(1).Value + DataGridView1.Rows(j).Cells(1).Value
DataGridView1.Rows(i).Cells(2).Value = DataGridView1.Rows(i).Cells(2).Value & " / " & DataGridView1.Rows(j).Cells(2).Value
DataGridView1.Rows.Remove(DataGridView1.Rows(j))

End If
Next
Next
End Sub

Vipin Sharma · Accepted Answer · 2012-08-05T22:13:00

i am trying a code for this
but it give me some error
can u cheak it plz ..

Private Sub calculateIngradient_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
      Dim a, b As String
      For i = 0 To DataGridView1.RowCount - 1
          a = DataGridView1.Rows(i).Cells(0).Value
          For j = 0 To DataGridView1.RowCount - 1
              b = DataGridView1.Rows(j).Cells(0).Value
              If a = b Then
                  DataGridView1.Rows(i).Cells(1).Value = DataGridView1.Rows(i).Cells(1).Value + DataGridView1.Rows(j).Cells(1).Value
                  DataGridView1.Rows(i).Cells(2).Value = DataGridView1.Rows(i).Cells(2).Value & " / " & DataGridView1.Rows(j).Cells(2).Value
                  DataGridView1.Rows.Remove(DataGridView1.Rows(j))

              End If
          Next
      Next
  End Sub