Adding rows in datagridviews

Question

0.00/5 (No votes)

See more:

Hey guys how are you doing.

i was wondering about how to add rows in a data grid view.

So one row would equal one number and another row would equal another number and pressing a button would add both rows.

It might be wrong but this is the current code

Seat_PlanDataGridView.CurrentCell.Value = Button2.Text

and help is much apperciated

Posted 26-Mar-13 8:07am

safianm

Updated 26-Mar-13 8:39am

v2

Add a Solution

Comments

Kschuler 26-Mar-13 16:02pm

Do you mean add two rows as in "create another row in the grid" or add two rows as in "mathematically perform addition on the values contained in two rows"?

safianm 28-Mar-13 9:29am

Calculation

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)

Maciej Los · Answer 1 · 2013-03-26T09:01:00

Solution 1

If you want to add row to Windows.Forms.DataGridView, see this: http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.rows%28v=vs.80%29.aspx[^]

Posted 26-Mar-13 9:01am

Maciej Los

Kschuler · Answer 2 · 2013-03-28T03:40:00

You've said you want to calculate the addition on two rows so....I'm not sure exactly what you are having trouble with, but to access the data in a row, you would access the row's cell's value something like this (Assuming that the data you want is in the first row and first column):
dgvGrid.Rows(0).Cells(0).Value

So if you had two rows in the grid and only one column you would add them together like this (Assuming that the cells contain decimal values):

VB

Dim decAddedValue As Decimal = dgvGrid.Rows(0).Cells(0).Value + dgvGrid.Rows(1).Cells(0).Value

Your best bet would be to create a function that makes sure a value IS what you expect it to be and/or returns a converted value...for example, it may be possible to have a null value in your cell, in which case the above code will fail. I'd do something like this:

VB

Private Sub btnCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalc.Click
    Dim decAddedValue As Decimal = CvtObjDec(dgvGrid.Rows(0).Cells(0).Value) + CvtObjDec(dgvGrid.Rows(1).Cells(0).Value)
    MsgBox("Value is: " & decAddedValue.ToString)
End Sub

Public Function CvtObjDec(ByVal obj As Object) As Decimal
   If obj Is DBNull.Value Then Return 0
   If obj Is Nothing Then Return 0
   If obj.ToString.Trim.Length = 0 Then Return 0
   If Not IsNumeric(obj.ToString) Then Return 0
   Return CDec(obj.ToString)
End Function