how to compute the total in datagridview vb 2010?

handsome · #1 (**permalink**) November 4th, 2012, 07:57 AM

Hye, i am using vb 2010. i need help in order to do a program that can calculate the total of all the values in the specific column in the datagridview, something like in the link below. Thanks

http://i.stack.imgur.com/Nzoeu.jpg

Ian Ryder · #2 (**permalink**) November 4th, 2012, 08:10 AM

Hi,

You can do this will the following code:-

Code:

Dim totalValue As Integer
For Each dgvRow As DataGridViewRow In DataGridView1.Rows
  If Not dgvRow.IsNewRow Then
    totalValue += CInt(dgvRow.Cells(1).Value)
  End If
Next
MsgBox(totalValue)

Hope that helps.

Cheers,

Ian

handsome · #3 (**permalink**) November 4th, 2012, 09:07 AM

it works!
thank you very much

handsome · #4 (**permalink**) November 4th, 2012, 10:04 AM

one more question

can i set one of the column to be visible = false by programming?

ive tried dgvRow.Cells(1).Visible =false but error occurred

Ian Ryder · #5 (**permalink**) November 4th, 2012, 10:14 AM

Hi,

Yes you can but you do not do it by trying to set an individual cell's visibility to false. You do it by using:-

DataGridView1.Columns(1).Visible = False

Hope that helps.

Cheers,

Ian

handsome · #6 (**permalink**) November 5th, 2012, 05:32 AM

thank you so much, you've helped a lot ^__^

Btw, can i set the delete button to delete selected rows or cells only?
i used BindingNavigatorDeleteItem.PerformClick() but that will delete all rows

Ian Ryder · #7 (**permalink**) November 5th, 2012, 05:52 AM

Hi,

You can clear cells but you cannot physically delete cells. If you want to delete a row however then you can do this:-

Code:

If DataGridView1.SelectedRows.Count > 0 Then
  For Each dgvRow As DataGridViewRow In DataGridView1.SelectedRows
    DataGridView1.Rows.Remove(dgvRow)
  Next
Else
  MsgBox("Nothing To Delete!")
End If

Hope that helps.

Cheers,

Ian

handsome · #8 (**permalink**) November 5th, 2012, 11:33 PM

thanks

but i have another problem
i cannot insert decimal points into the cell in dtagridview...
when i run the program, then i insert for example 2.3 into the datagridview, an error will pop up..like in the link below
https://fbcdn-sphotos-c-a.akamaihd.n...44840074_n.jpg

how can i fix this?

Ian Ryder · #9 (**permalink**) November 6th, 2012, 12:40 AM

Hi,

The answer to your question is the first word on the second line of the error statement that you have posted. You need to look at how you have created your DataGridView columns to allow decimal values. If you create the column as DataGridViewTextBoxColumn you will have no problem with decimal values.

Hope that helps.

Cheers,

Ian

handsome · #10 (**permalink**) November 13th, 2012, 07:01 PM

hye there :)

i juz want to know how can i save the data inside the datagridview?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
New to VB 2010 - I need help with OLEDB	toconce	Visual Basic 2010 General Discussion	10	May 25th, 2015 03:10 AM
Moving up from VB5 to VB 2010	VB2010Newbie	Visual Basic 2010 General Discussion	5	June 17th, 2011 09:33 AM
Trouble getting form to appear - VB 2010	jericho	Visual Basic 2010 General Discussion	1	June 6th, 2011 06:50 AM
Beginning Microsoft VB 2010	Tony1997	.NET 4 and Visual Studio 2010 General Discussions	2	April 3rd, 2011 11:19 AM
Sum of numbers that was insert will automatic compute and appear in total text field	newphpcoder	PHP Databases	0	December 23rd, 2010 02:34 AM