Validating Data Entry with a datagrid

[Nucleus]

I have loaded data into the grid and the next thing that I want to be able to do is:

1. Validate user entry that is make sure they haven't placed alphas where I only wanted numbers. Anyone got any suggestions?

2. Limit the number of characters users can put in the grid. Again suggestions appreciated.

[Lethal]

Hmm...I haven't used the data grid extensively, but does it expose properties on a per column basis? I've used alot of grids that allow this, but as I stated, I really havent used the data grid.

[Nucleus]

found out how to do 2, you can play with this sorta stuff with
DataGridTextBoxColumns

eg
txtCol.TextBox.MaxLength= x

but still need to work out how to validate user entry?

[Nucleus]

Originally posted by Lethal
Hmm...I haven't used the data grid extensively, but does it expose properties on a per column basis? I've used alot of grids that allow this, but as I stated, I really havent used the data grid.

Yeah the new datagrid is pretty cool in that it allows you to directly bind multiple tables to a datagrid at once and the user can just select which table they want to see. The only problem that I am finding is that as soon as you want to start mucking around with the defaults, you gotta learn the object model beneath the control and in this case there are a couple such as DataGridTableStyle and GridColumnStyles that you have to get comfy with. So I am flying in the dark a little here, but I guess it is kinda fun, like having your girlfriend think it's funny to wax your leg, "no sweetie my leg is killing, don't go any higher and do my arms"

[Lethal]

How bout something like this?

    Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
        Dim iDigit = System.Convert.ToInt32(e.KeyChar)
        Dim bSpace = (iDigit = 32)
        Dim bBackSpace = (iDigit = 8)

        If Not System.Char.IsDigit(e.KeyChar) Then
            If (Not bSpace And Not bBackSpace) Then
                e.Handled = True
            End If
        End If
    End Sub

[Nucleus]

Tried this but nothing was printed in the debug window

Private Sub DataGrid1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles DataGrid1.KeyPress
        Debug.WriteLine(Me.DataGrid1.CurrentCell.RowNumber)
        Debug.WriteLine(e.KeyChar)
        ' check for your active column to restrict input
        'If Not System.Char.IsDigit(e.KeyChar) Then
        '    If Not System.Char.IsControl(e.KeyChar) And Not e.KeyChar = CType(e.KeyChar, Char) Then
        '        e.Handled = True
        '    End If
        'End If

    End Sub