I Want To Fill a DropdownList using Store Procedure

Question

In My Application I Have Around 12 Dropdownlists I Want To Fill Them With Different Tables Using Store Procedure and Also I Dont Want To Repeat The Dropdownlist filling code so I Want A class file for filling them by passing parameters everytime to the class file Can Anybody help me out please???? Thanks In Advance...

Arunava Bhattacharjee · Answer

If it satisfies you please mark it as accepted answer :)

madhukeshwar murkibhavi · Answer

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...

Arunava Bhattacharjee · Answer

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.