pass value to drop down list from sqldatasource

Question

I am trying to pass value to drop down list based on the current used who current logged in

I mean I need to show the module name where the current who logged in now user has these module these module will be retrieved from module relation table where user id in it and in the logging session the user id is retrieved from users table and they have relation

this the code

<asp:SqlDataSource ID="SqlDataSource8" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT [MId], [MName] FROM [ModuleRelation] WHERE [UId]=@uid">

<asp:Parameter Name="uid" Type="string"/>

</SelectParameters>

</asp:SqlDataSource>

please help

Manas Mohapatra · Answer

Let's say there is dropdown ddlUid which has all user ids. And you want load data based on userid select in dropdown.Uid is the variable which map between filter expression with filter parameter. Follow with below code: asp:SqlDataSource ID = GridDataSource runat = server ConnectionString =   SelectCommand = SELECT [MId] [MName] FROM [ModuleRelation] FilterExpression = UId= '{0}' > FilterParameters > asp:ControlParameter Name = Uid ControlID = ddlUid PropertyName = SelectedValue /> FilterParameters > asp:SqlDataSource > SelectCommand – Here we need to set the default SQL Query without any WHERE Clause or filter. FilterExpression – Here we need to set the filter part of the SQL Query with a placeholder {0}. The placeholder {0} will be replaced by the value of the ControlParameter i.e. the DropDownList’s Selected Value FilterParameters – Here we specify the Control Parameters to be used by the FilterExpression

Bikesh Srivastava · Answer

Hi You can check this link it may be helpful. http://www.aspsnippets.com/Articles/Pass-DropDownList-Selected-Value-as-Parameter-to-SqlDataSource-in-ASPNet.aspx

Manas Mohapatra · Answer

ddlUid - ID attribute of dropdown. Uid - Name of variable which maps between FilterExpression and ControlParameter. SelectedValue - The property of dropdown list means value of dropdown. Thank you.

Joma Rajab · Answer

Thanks Manas can you please clarify name  control ID and property name in your code and provide the code behind as well thanks