Hi guys, I want to multiply or add the values of two or more cells in a datagridview control in a row and and should also be auto-saved in the database after entering datas in the cell. I am using SQL Server 2008 for my database.
Please do take a look at the screenshot attachment that I made for further details..
I don't know what code to use, so I did not put any codes in this discussion.
Dim iCell1 As Integer
Dim icell2 As Integer
Dim icellResult As Integer
iCell1 = DataGridView1.CurrentRow.Cells(1).Value
icell2 = DataGridView1.CurrentRow.Cells(2).Value
icellResult = iCell1 * icell2
DataGridView1.CurrentRow.Cells(3).Value = icellResult
Catch ex As Exception
Make sure the selectionMode is set to cellSelect. Once user leaves the cell 3 it will get the calculated values in it.
i tried code to calculate coloumn total amount and reach coloumn amount paid
If dgv.RowCount > 1 Then
Dim amount As Decimal = 0
For index As Integer = 0 To dgv.RowCount - 1
amount += Convert.ToDecimal(dgv.Rows(index).Cells(3).Value)
TextBox1.Text = amount
i reached this code after search but with this i only sum the last coloumn values into textbox like you did but i need to sum data from item amount and quantity and in the same time get sum of data in in textbox
hope this code help you
Hey, so I wanna ask how I need to create a method who will remove word if in that word is 2 same chars. Example: "Potato" in this word there is a 2 "o" chars so this word will need to be removed. "Forum" in this word there is no ...
Hi I'm having a problem implementing a mini shopping cart drop down in the header to show the user all the products they have in their shopping cart. It seems the only solution for this is Ajax, and I've looked all over and can't find anything that I could possibly ...