Data access page filter refresh the page

[taoge]

Hi All,

I have a data access page needs a filter by a dropdownlist, the dropdownlist used is a html control and I use javascript to filter the data programmaticlly in the onchanged event of the control.

MSODSC.DataPages(0).Recordset.Filter="AppID = 3";

My problem is, when this statement runs, the page refreshes. But I don't need the page refreshes, it set the dropdownlist text to the default text, not the value user select. The browser is IE7.

How can I stop the page refresh itself?

Thanks and Happy New Year!!

 

[steve-waters]

With having very little idea about the specifics, that I do not really know java script.

If you are causing the page to refresh with a scrupt can you save the selected dropdownlist items value to a variable and pass this to the page as it refreshes to set the drop down list to the selected value, if varible is null set to default position.