Create a Store Procedure base on dropdownlist [Resolved]

Posted by Ssagard under Sql Server on 5/10/2016 | Points: 10 | Views : 566 | Status : [Member] | Replies : 2
Hello,
I am creating one report which is totally depend upon dropdownlist selection. when user select one by one dropdownlist value then as per selection report will be generate. Any one having sample? pls share with me.

thank you in advance




Responses

Posted by: A2H on: 5/10/2016 [Member] [MVP] Silver | Points: 50

Up
0
Down

Resolved
By report if you are talking about SSRS report then you can check the below links which explain the steps in details
http://www.tutorialgateway.org/drop-down-list-parameters-in-ssrs/
http://www.codeproject.com/Tips/603859/Generation-of-Dynamic-Parameterised-Report-with-Dr

Video Link
https://www.youtube.com/watch?v=bYw-gw27xVI

Thanks,
A2H
My Blog

Ssagard, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: A2H on: 5/10/2016 [Member] [MVP] Silver | Points: 25

Up
0
Down
If you are talking about fetching the data based on dropdown selection in c#, then its very much similar to how we fetch the data for any other operation. You need to ensure that you passed the value from dropdownlist like paramter for your SP.

To get the data based on dropdownlist selection you need to the OnSelectionIndexChanged event of dropdownlist.

Hope this helps you to get started.

Thanks,
A2H
My Blog

Ssagard, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response