I have got 5 dropdownlist in my page. Each one of them is connected with a data adapter. At run time I am changing the initial querry of each drop down so as to get the data based on some condition given at run time. Upon selection from the data grid a new querry is fired which gets the data fromteh database and shows in the text boxes. Now my coding is perfect. Querry is also working the main problem is that 3 out of those 5 dropdownlists doesn't go to their respective selectedIndexChanged function where the querry is written. Secondly the selected value comes back to the first value no matter which value I am selecting. I have done this over 100's of time before I know in pageload I have to write everything between
<highlight>
If not ispostback then

Endif
</highlight>

and I have to change the auto post back of every dropdownlist to TRUE. All ready done that. But only two of them are working properly the first three of them are not going to their respective functions upon selecting something from it.

Earlier I was having some problem in getting the data because of some database validation violation. So I changed the Enforce Constraint property of Datasets to FALSE. So can anybody tell me why 3 of the datagrid is not behaving as they are suppose to behave while the other 2 are working properly. Even though all 5 of them have the same property exactly same.