Stored procedure for DropdownList

[ankeetshah]

hello friends

i have 5 dropdownlists in my aspx page and the datagrid displays results according to any drop down list selected

if i select 1 then only 1variable will be passed to stored proc and result will be displayed.if 2nd one is selected then two variables will be passed

the 1st being the previous one an 2nd one being the new one selected

so there is no order or numbering in selection of dropdowns

i have to design a stored proc for this event

the datagrid gets populated on the selected index changed event of the dropdownlist

[debasisdas]

You need to create the stored procedure with default parameters.

If only one or two paramete is passed then you need to execute with default parameters.