Problem with datagridview cell data formatting

sumith · May 24th, 2012, 12:51 AM

Hi All,
I am working on a vb6 to vb.net migration project using vs 3.5. I have a datagridview.in a particular cell of this grid, user has to enter only numeric data. but after user enter data, itshould become concainated with a $ symbol (eg: if user enter 34, the cell value should become $34). And if he/she presses the hyphen ("-") in the key board, the data (ie. $34) should become -$34 and if again presses the hyphen button in key board, the data should become $34.

Any idea of how to do this.Any help appreciated.

Regards,
Sumith

sumith · May 25th, 2012, 08:29 AM

I got it.
First, need to format the column as currency

Code:

DataGridView1.Columns("C").DefaultCellStyle.Format = "c"

Next, add eventhandler for cells

Code:

Private Sub dataGridView1_EditingControlShowing(ByVal sender As Object, _       ByVal e As DataGridViewEditingControlShowingEventArgs) _       Handles DataGridView1.EditingControlShowing       Dim txtEdit As TextBox = e.Control       RemoveHandler txtEdit.KeyPress, AddressOf txtEdit_Keypress       AddHandler txtEdit.KeyPress, AddressOf txtEdit_Keypressend sub

And, in txtedit_keypress,

Code:

Private Sub txtEdit_Keypress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs)
 If e.KeyChar = "-" Then
                Dim curCell As DataGridViewCell = DataGridView1.CurrentCell
                If curCell.ColumnIndex = 2 Then
                    curCell.Value = -CDec(curCell.Value)
                    DataGridView1.RefreshEdit()
                    e.Handled = True
                End If
            End If
end sub

This will work as desired.