dataSet acceptChanges

[Guest]

when im doing dataSet1.tables(0).acceptChanges the rowChanging event is called
and im getting an error -"cannot find columns 8"
i dont know why im getting this error
can someone tell me what is wrong??

Private Sub exercise_rowchanging(ByVal sender As Object, ByVal e As
System.Data.DataRowChangeEventArgs)

Dim num1 As New Integer
Dim num2 As New Integer
Dim num3 As New Integer
num1 = e.Row.Item(0)
num2 = e.Row.Item(1)
num3 = e.Row.Item(2)
If CInt(num3) <> CInt(num1) + CInt(num2) Then
e.Row.RowError = "The result column contians an error"
e.Row.SetColumnError(e.Action, "Result cannot be " & CStr(num3))
End If
End sub

thanks

 

[Miha Markic [MVP C#]]

Hi,

Instead of column (or column index) you are passing e.Action parameter to
SetColumnError method.

 

[Guest]

i tried e.row.item("res") but its not working...
??

 

[Guest]

Have you tried this:
e.Row.SetColumnError("res", "Result cannot be " & CStr(num3))

 

[Guest]

thanks its working