dropdownlist.text returning incorrect value after autopostback on another dropdownlist


Can't quite see what's going wrong here, and it's a little complicated so i'll try and explain as best i can. I have a number of dropdownlists (we'll call this set 1) which are all databound and filled using sqldatasources. If I select one of them, it fills another dropdownlist using some javascript (we'll call this set 2), then the user selects one of those options clicks a button and the data required is returned. That all works fine.

So, I can switch between the different dropdownlists fine and the correct value is always returned (from set 1). However, 1 of the dropdownlists in set 1 is an autopostback dropdownlist. And this is where the problem occurs. If I hit the autopostback dropdownlist that works fine. But, if I then go to hit another dropdownlist of set 1, which fills set 2 and user clicks a button... I find that the dropdownlist.text value which is returned is incorrect (it is always the first element of the dropdownlist). If I hit the dropdownlist again, then the correct value is returned.

This is the order of the problem:
(1) Select value in databound autopostback dropdownlist. Data returns fine.
(2) Select value in one of the other databound dropdownlists (not autopostback). First value in dropdownlist is seen in codebehind even though i selected some other value
(3) Perform step two for a second time. Correct value now shown in codebehind.

What's going on here can anyone see?
Who is Participating?
John ClaesConnect With a Mentor Senior .Net Consultant & Technical AnalistCommented:
As far as I know this issue this is not a ADO issue but a Access Issue.

Databases are made to cache a lot of data to make Queries Quicker.
It seems that you were requesting data from the Cache while you already changed the recordset itself.
I had this 3 years ago when I was working on a Access Database. I used that to get the customer to a SQL DB and I never had that issue again.


poor beggar
Paul JacksonSoftware EngineerCommented:
Sounds like you are repopulting the contents of the dropdownlist on pageload, maybe not checking for Page.IsPostBack. POst your code so we can determine what's going on.
John ClaesSenior .Net Consultant & Technical AnalistCommented:
it looks like your changing the text, but the element is not changed (not found)
Therefor the element can't be set and using the postback the first element is returned as selected Item.

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

AidenAAuthor Commented:
the dropdownlists are databound with sqldatasources... so the text can't change in any of them (only in the set 2 dropdownlists... but i'm not looking for those values... i'm looking at set 1 dropdown values which are all databound)...

that's what's weird about this... the data must be populating with the same values each time the page loads... so there should be no possiblity of the data not being there. + it only doesn't work immediately after the dropdownlist with autopostback is selected. After that (i.e. the second time I click the button looking for the selected value of the non autopostback dropdown) there is no problem... the value which was selected is found?
AidenAAuthor Commented:
and just to be clear, the sqldatasources are on the page... i'm not binding dynamically or creating any datasources dynamically...
Paul JacksonSoftware EngineerCommented:
Can you post your code so we can try and help further
AidenAAuthor Commented:
sorry I figured it out. It's an MS Access problem, or a general database problem, I'm not sure. Although I'm sitting here trying to remember exactly what the issue was and since i was fixing so many things over the last few days i just can't exactly remember.

I'm pretty sure though it was to do with the fact that I was running a query on an MS Access database, and then directly afterwards extracting the result and putting it into a label on the page so i could search through it in javascript and fill the dropdowns. Anyway, what i found what that if after running the first query i put a thread.sleep for 10 seconds before extracting the results into the label, it worked ok, but if i didn't do that, then what was extracted was not the updated table.

So, it looks like access needs a few moments to update it's query, but when I'm running the second query to extract the updated results, the table isn't updated yet. How do you get around this problem? I think for those queries i was just using ado recordsets. I assume though the problem would be the same with ADO.NET? What about in Oracle... would you have a similar problem and how to solve?
AidenAAuthor Commented:
ok, i was assuming it was an ms access problem. The website will be migrated to oracle soon... but then i'll have a whole new set of problems i'm sure.

thanks for help..

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.