Dear All ,

I'm trying to use more than one control parameter (using dropdown list control) to determine what comes out in a detailsview.

The situation is like this :

I have 2 dropdown list : (1) By Year : and (2) By Month.
and I also have a detailsview to show some details.

How can I control a detailsview by selecting year (1st dropdown list) and the narrow my detailsview by month (2nd dropdown list). The details should display details by what year and what month
(eg: Year :2007 Month : July).

Is there any changes in the sql query ? or any other modification should i do ? Thank you ..