I Want To Fill a DropdownList using Store Procedure

Sir Thank You Very Much ,
I Got Almost good Solution For It N Ur Post Was Very Helpfull For Me Thank You Once Again Sir...

Well i presume that you need to pass only one parameter to your Stored Procedures every time. The way I would do it to create a generic method to dynamically call stored procedure passing the parameter.

Have a look at this post:

http://codereview.stackexchange.com/questions/44991/generic-class-to-call-table-parametered-stored-procedures


Modify this and get your collection and the bind it to your drop down itemsource.