Calculate Sum Total in Column Gridview by Key Enter

Question

Please i need your help
I have 3 columns .. column Price ( 4 ) , columns Quantite ( 5 ) and column Total ( 6 ) .. I want by Key Press when i update cell in column Quantity ( 5 ) then the sum changes automatically in columns Total ( 6 ) .. i tried like this but it does not work ..
Private Sub GridView1_KeyDown(sender As Object, e As KeyEventArgs) Handles GridView1.KeyDown
If e.KeyCode = System.Windows.Forms.Keys.Enter Then
Auto_Row_Calculation()
End If
End Sub
Private Sub Auto_Row_Calculation()
Dim GridQuantite As Integer = 0
Dim GridPrice As Decimal = 0.0
Dim GridTotal As Decimal = 0.0
For I As Integer = 0 To GridView1.RowCount - 1
GridPrice = Me.GridView1.GetRowCellValue(I, GridView1.Columns(4)).ToString
GridQuantite = Me.GridView1.GetRowCellValue(I, GridView1.Columns(5)).ToString
GridTotal = Val(GridPrice) * Val(GridQuantite)
Me.GridView1.SetRowCellValue(I, 6, GridTotal.ToString)
Next
End Ssub
Thank you in advance for help

Sachin Singh · Answer

it would be easier if you use jquery public class Entity { public int ServiceId { get; set; } public decimal Rate { get; set; } public int Quantity { get; set; } public decimal Total { get { return Rate * Quantity; } } } "BodyContent" ContentPlaceHolderID= "MainContent" runat= "server" > "server" ID= "GridView1" AutoGenerateColumns= "false" > "ServiceID" ItemStyle-Width= "100px" > "lblServiceID" runat= "server" Text= ' ' > "Rate" ItemStyle-Width= "70px" > "lblRate" runat= "server" Text= ' ' CssClass= "rate" > "Quantity" > "txtQuantity" runat= "server" CssClass= "txtQty" Text= ' ' > "Total" > "lblTotal" runat= "server" CssClass= 'Total' > "Total" )%> $(document).ready(function () { $( '.txtQty' ).on( 'change' , function (evt) { var $row = $(this).parents( 'tr' ); var rate = Number($row.find( '.rate' ).text()); var qty = Number($(this).val()); var total = rate * qty; $row.find( '.Total' ).text(total); }); });

Mada Black · Answer

Thank you very much Sachin Singh .. But i use VB NET

Mada Black · Answer

Thank you Farhan Ahmed for help B ut i didn't understand all these codes I just want to convert my code to work with GridView DevExpress Thank you

Farhan Ahmed · Answer

https://www.c-sharpcorner.com/UploadFile/8c19e8/how-to-do-calculations-in-gridview/