Adding Col in datagridview

Question

1.00/5 (1 vote)

See more:

I have Columns 4 5 and 6 and i want to display them in colm 7

ex.
Name Col4 col5 col6 Total
Stephen 2 3 6
JOhn 5 9 11

this is what i have so far

Dim col1 As Integer
Dim col2 As Integer
Dim col3 As Integer
Private Sub dataGridView1_CellLeave(sender As Object, e As DataGridViewCellEventArgs)
If e.ColumnIndex = 4 Then
col1 = Integer.Parse(dataGridView1(1,e.RowIndex).Value.ToString())
col2 = Integer.Parse(dataGridView1(2,e.RowIndex).Value.ToString())
col3=col1+ col2;
dataGridView1(3, e.RowIndex).Value = (col3).ToString()
End If
End Sub

Posted 15-Aug-13 4:27am

PythonProgrammer

Add a Solution

Comments

sv sathish 15-Aug-13 10:39am

i help you but your question is not understandable so update your question in easy manner.
what is use of "Total" in Gridview1.

PythonProgrammer 15-Aug-13 10:46am

ok so i have 4 columns fruits, snacks, vegetables, and total....
Stepehn 5 7 15
John 6 19 23

I want to display the total in the columns

sv sathish 15-Aug-13 10:59am

U want like this
-----------------------------------------------
Name | Fruits | Snacks | Vegetables | Total
-----------------------------------------------
xxxx | 2 | 2 | 2 | 6
yyyy | 1 | 1 | 1 | 3
-----------------------------------------------

PythonProgrammer 15-Aug-13 11:00am

yes that is correct sorry for the explanation of this im a begginner at this and seeing what to do helps me understand it

PythonProgrammer 15-Aug-13 11:33am

im not using a database

2 solutions

Solution 2

http://www.dotnetperls.com/datagridview-vbnet[^]

http://vb.net-informations.com/datagridview/vb.net_datagridview_tutorial.htm[^]

view this links it's help full to you..

Posted 15-Aug-13 5:42am

sv sathish

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)

sv sathish · Accepted Answer · 2013-08-15T05:32:00

U can try this

Imports System.Data.OleDb
Public Class help
Dim con As OleDbConnection
Dim cmd As OleDbCommand
Dim adp As OleDbDataAdapter

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
con = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=D:\Database3.mdb")
con.Open()
Dim qry As String
qry = "INSERT INTO total( [name], [sal1], [sal2] , [sal3], [total]) VALUES('" & TextBox1.Text & "' ," & TextBox2.Text & " ," & TextBox3.Text & "," & TextBox4.Text & "," & Val(TextBox2.Text) + Val(TextBox3.Text) + Val(TextBox4.Text) & ")"
cmd = New OleDbCommand(qry, con)
cmd.ExecuteNonQuery()
MsgBox("Total Added ")
End Sub