Pass the selected value of the drop-down list to the parameter

Question

I have a grid and a drop down list. I want to filter the values ​​in a grid by selecting a dropdown.

My code is

<asp:DropDownList ID="DDLVisitedVol" runat="server" AutoPostBack="true" DataSourceID="DsVisitedVol" DataTextField="VisitedVol" DataValueField="VisitedVol" Width="244px"> </asp:DropDownList> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="" ProviderName="" SelectCommand="SELECT [ID],[UserName], [Email], [visitedVol] FROM [HitTracker] where visitedVol=@VisitedVol "> <SelectParameters> <asp:Parameter Name="VisitedVol" Type="String"/> </SelectParameters> </asp:SqlDataSource> 

How to pass the selected dropdown value to @VisitedVol?

Answer 1

Use ControlParameter:

 <asp:ControlParameter ControlID="DDLVisitedVol" Name="VisitedVol" PropertyName="SelectedValue" Type="String"/> 

Answer 2

ControlParameter is your friend:

 <asp:ControlParameter Name="VisitedVol" ControlID="DDLVisitedVol" PropertyName="SelectedValue"/> 

Answer 3

You must handle the ddl selectedIndexChanged event and re-bind the data after filtering by the value of the selected ddl element.