pass value to drop down list from sqldatasource

Joma Rajab

10y1.8k.NET

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

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

please help

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
Accepted 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="<%$ ConnectionStrings:ConStr %>"
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
Manas Mohapatra10y ago
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 Rajab10y ago
Thanks Manas
can you please clarify name , control ID and property name in your code and provide the code behind as well
thanks
Bikesh Srivastava10y ago
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