How can i Validate a Datagrid??????

Question

I need to check during Editable mode of Datagrid that it should accept only numbers??????? how can i accomplish that....???

Answer 1

1. Make sure you have a validation function set up for updates in aspx page (mine is called DataUpdateCO):




2. Do validation by using ".FindControl" from the DataGridCommandEventArgs obj. My controls name is "CO_ID".


Sub DataUpdateCO(ByVal Sender As Object, ByVal E As DataGridCommandEventArgs)

Dim txtID As Integer = CInt(CType(E.Item.Cells(0).FindControl("CO_ID"), Label).Text)

If txtID = "" then
Msg.TExt = "Error the ID is empty!
'do not update the grids data and re-bind
Else
'update the drids data and re-bind
End IF

End Sub

Answer 2

Use regular expression validator control