I have a dataSet in a C# class which in turn is saved in a Session variable. The dataset is intially loaded with SqlDataAdapters. As I go through various asp.net pages, I change data, etc. At the end, I pass the dataset to a Save routine that applies alot of biz logic before eventually saving everything to Sql Server. All that works fine.
But I've noticed that changed data is getting saved to the db even if the user doesnt hit the Save at the end of the process-- or closes the browser early. I've tried removing the the final Save() call-- I set breakpoints in the Save() to confirm its not being called, etc.
Somehow, IIS seems to be able to update the dataset "for me" even though I dont want that. I think the SqlDataAdapter sets properties to support its Update() and I've tried Copy() and Clone() to keep the data and lose the connection but nothing works.
Can anybody confirm this behavior for IIS and tell me how to turn it off?
tks much.