dataset.haschanges()

[Humaira Laila]

i want the system to check if there is changes in form, so if there is changes in the form, user will be prompt a msgbox that ask user either to save the changes or not.
so i use dataset.haschanges() in order to detect the changes. but the problem is, the result always shows there is changes even i didn't make changes. i notice that, it is happen because the dataset involves many other table.so, if other table changes, that is why my form also show have changes. so , do u guys have any idea/solution for my problem? i wonder, if there is any way to detect changes in form? tqvm~

 

[jmcilhinney]

If you only care about a specific table then call GetChanges on that table. If there are no changes then that method will return Nothing.

 

[Humaira Laila]

ok..i will try it..tq..

 

[jmcilhinney]

To be specific, rather than this:

If myDataSet.HasChanges() Then

do this:

If myDataSet.Tables("MyTable").GetChanges() IsNot Nothing Then

 

[Humaira Laila]

i try to change from dataset to table..
If myDataSet.Tables("MyTable").GetChanges()
but it show error that table(MyTable) data cannot be converted to boolean..