>
>I'm thinking that having trnsaction.commit() right after BeginExecute may be causing the problem. Anyway, I left everything not working, but I called later and the manger told me that he fixed everything and moved my code to production and the original problem seems to be fixed.>
>Yes, that seems odd to commit the transaction right after you begin to execute the command. That doesn't make sense I don't think.
>
>So, he fixed the problem (the problem with the transaction?) ... what turned out to be the problem?
>
>~~Bonnie
Hi Bonnie,
My manager fixed the problem with the project asking for the _deploy accembly to be recompiled. I have no idea why this problem suddenly appeared (at the time I had to leave). Perhaps it was caused by page directive (since I managed to break the ASPX file we copied the older version of it).
He also wrote, that the changes I made today, fixed the original problem (the one I was trying to fix). So, with your generous help, I was able to achieve a small success <g>
The only significant changes I made were
1) Change from direct insert string to Parameters usage as you showed
2) Fix a mistyped INSERT command (INTO keyword was missing)
3) Changed BeginExecuteNoQuery to just ExecuteNonQuery.
I think, that the logic of this page would have to be re-written using yours and John's idea.
The reason I touched the page in design view was that I wanted to visually adjust placement on few controls. However, they are in UpdatePanel (the site is AJAX enabled) and I didn't yet figure out how to get to the actual controls.
Thanks a lot again for your help and have a wonderful New Year!
If it's not broken, fix it until it is.
My Blog