How to validate input with datagrid control?

[suresh]

How to validate input with datagrid control? i tried
the following code from msdn...i have problem in adding
handler to the columnchanging event..its not working for
me? any bug in this code? is there any other way to
validate input with datagrid control? waiting for good
solution.thanks in advance.

-suresh

-----------------------------------------------------
Private Sub Customers_ColumnChanging(ByVal sender As
Object, _
ByVal e As System.Data.DataColumnChangeEventArgs)
' Only check for errors in the Product column
If (e.Column.ColumnName.Equals("Product")) Then
' Do not allow "Automobile" as a product.
If CType(e.ProposedValue, String) = "Automobile"
Then
Dim badValue As Object = e.ProposedValue
e.ProposedValue = "Bad Data"
e.Row.RowError = "The Product column contians an
error"
e.Row.SetColumnError(e.Column, "Product cannot
be " & _
CType(badValue, String))
End If
End If
End Sub
---------------------------------------------
Connect the event handler to the event.
Place the following code within either the form's Load
event or its constructor.

' Visual Basic
' Assumes the grid is bound to a dataset called
customersDataSet1
' with a table called Customers.
' Put this code in the form's Load event or its
constructor.
AddHandler customersDataSet1.Tables
("Customers").ColumnChanging, AddressOf
Customers_ColumnChanging

-----------------------------------------------------