Last post Jun 20, 2006 10:37 PM by BenRosa
Jun 19, 2006 11:32 PM|BenRosa|LINK
I know my form is updating the db per viewing the table in the db. However, upon post-back, the new updates don't display. The Update stored procedure ends with a Commit Transaction statement...I've even set the form's cache value to 0...not sure what
the deal is.
Any and all guidance will be appreciated.
Ed in Tampa
Jun 20, 2006 03:59 AM|DWesthead|LINK
Jun 20, 2006 07:35 AM|BenRosa|LINK
My data displays in a series of textfields on a webform. I'm thinking I have the default set, which is, it think, EnableViewState = true (I'm at work now, my code is at home).
However, I did have success and see my updates upon closing-out my browser and going back in on the same record in the form.
One should not have to close-out their browser to see updates...what gives? I'm using everything locally, including a local version of SQL Server. Is there some db parameter I need to set? Is it a db caching issue?
Thank you for any and all guidance...
Jun 20, 2006 07:51 AM|DWesthead|LINK
Jun 20, 2006 07:59 AM|BenRosa|LINK
Yes, an associate here at work recomended putting the "Get" stored procedure (for loading the form's data), which fires upon the form load if a post-back, into a method and fire it off right afterthe Update stored procedure runs.
Thank you for the input and advice; I'll try it tonight and let you know.
Jun 20, 2006 10:37 PM|BenRosa|LINK
Ok, I've made a big discovery that may help...on other thread I found-out how to use VS '03's integrated debugger within a DNN custom module. Here's the guts of that thread: