Hi,

This has to be simple. I have a windows form in vb.net opening tables in TableAdapters and DataAdapters.

I have 2 questions..

1. How can I check just before closing the form if any database information was modified? I want to give a save option if any mods were performed.

2. I have to open a DataAdapter so that I can use transactions and record locking. But I've only been able to pass the SQL in code into the SQLCommand. How do I retrieve the SQL from my dataset or use the Datasets in my project so that I don't have to hard code SQL in my code?

Thanks
Kia

hey kia,

1) use DataSet.HasChanges function to check whether it has been modified or not.

2) i m not able to understand wht u wanna ask...


bye,
ashu

Hi Ashu, thanks for your replies.

1. Thanks that's exactly what I needed.

2. I just re-read my own post and you're right.. It makes no sense! I'm having a little trouble explaining this problem, but here goes!

I want to do is setup a DataSet with the tables and selects, updates etc, as if I was going to use it in my form with TableAdapters. But...

In the form I have to use DataAdapters in order to make use of transactions. So, I wonder if its possible to hook up the DataAdapter to the SQL from a TableAdapter within a Dataset that is not on the form?

hey kia,

u can use a Global DataSet variable and use it in any form u require
u can see the following links regarding TableAdapter:

http://msdn2.microsoft.com/en-us/library/bz9tthwx(VS.80).aspx

http://msdn2.microsoft.com/en-us/library/kda44dwy(VS.80).aspx

Thanks again mate.. Got me out of the hole again.

Back to issue 1: Using HasChanges to see if there are changes to the BS..

I found that I first have to run "EndEdit" before "HasChanges" gets updated.

Problem is that there are required fields in the table, so if the user wants to leave the form without saving(say they click "new" and immediately close the form), they will be faced with the error from each required field before HasChanges is set and they get to the "Do you want to save" option.

Any ideas how to get around this? Currently I'm using a global variable that's set manually. Is there a way to detect changes without first executing EndEdit?