dataSet acceptChanges

[s-galit]

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.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"s-galit" <sg****@discussions.microsoft.com> wrote in message
news:F3**********************************@microsof t.com...

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

[s-galit]

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

[Yang Lu]

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

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

[s-galit]

thanks its working

"Yang Lu" wrote:

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