Create a Store Procedure base on dropdownlist [Resolved]

Posted by Ssagard under Sql Server on 5/10/2016 | Points: 10 | Views : 893 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

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

Latest Posts