January 19, 2010 at 7:46 am
This is probably more a question for 4GuysFromRolla, but I figured I'd try here in the off-chance that someone knows this . . .
I've built a quick 'n dirty test app that pulls data from a SQL 2008 database and displays it in a SQLDataSource object. My back-end code uses a SelectCommand method where I'm defining the statement as something like "select * from
where UserID = jdoe"
Here's where it's giving me trouble.
I've also included a text box to change the User ID. However, when I try a user ID that's close to the previous one (e.g. "jadoe" instead of "jdoe"), it gives me the data for "jdoe."
I'm thinking it has something to do with the cache, but I have EnableCaching set to false (the default).
Has anyone else seen this? How do you get around it?
Thanks!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 19, 2010 at 8:19 am
For others' reference: I figured it out. The SQLDataSource object was refreshing just fine. The problem was with the GridView object. I had to refresh that as well.
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply