Alternative to Cell End Edit in Datagridview ?

Question

Hi....

I am using windows application (VB.NET). I have a form with datagridview with columns qty , unit price and cost . The Cost column is qty * unit price column. When i enter unit cost in unit price column i wrote this calculation in cell end edit event for datagridview but when mouse left the focus only the event do calculations.. Is there any other event to do calculation in data gridiview so that calculation is correct.

Thanks and Regards
Sankar

ali tuncer · Answer

I think you can use KeyPressEventHandler it is probably the same in VB but I don't know the syntax. Here is a C# code for your reference: private void dataGridView1_EditingControlShowing(object sender DataGridViewEditingControlShowingEventArgs e) { DataGridViewTextBoxEditingControl tb = (DataGridViewTextBoxEditingControl)e.Control; e.Control.KeyPress += new KeyPressEventHandler(dataGridViewTextBox_KeyPress); } private void dataGridViewTextBox_KeyPress(object sender KeyPressEventArgs e) { MessageBox.Show(e.KeyChar.ToString()); }

Shakti Singh Dulawat · Answer

I think the one you are using is perfect please follow same scenario here http://www.sourcecodester.com/tutorials/visual-basic-net/how-calculate-two-columns-datagridview.html