How to pass value to drop down list from sqldatasource

Question

0.00/5 (No votes)

See more:

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.

What I have tried:

ASP.NET

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

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

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

Posted 21-Jul-16 0:30am

Member 12618369

Updated 21-Jul-16 3:59am

Vincent Maverick Durano

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vincent Maverick Durano · Accepted Answer · 2016-07-21T03:59:00

Solution 1

I'm not really a fan of SqlDataSource, but if you are trying to extract the value from your SqlDataSource so you can use it to populate your DropDown then you could try something like this:

C#

protected void Page_Load(object sender, EventArgs e)
{

    DataView dvSql = (DataView)SqlDataSource8.Select(DataSourceSelectArguments.Empty);
    foreach (DataRowView drvSql in dvSql)
    {
        string moduleName = drvSql["MName"].ToString();
        DropDownList1.Items.Clear();
        DropDownList1.Items.Add(moduleName);
    }
}

Posted 21-Jul-16 3:59am

Vincent Maverick Durano

Comments

Member 12618369 21-Jul-16 10:28am

Thanks for this but I could not find DataView in the c# library is it DataSourceView?

Richard Deeming 21-Jul-16 10:33am

Make sure you've got a using System.Data; line at the top of your code file.

Vincent Maverick Durano 21-Jul-16 10:35am

Thanks for that, Richard.

Member 12618369 21-Jul-16 10:47am

Thanks Richard
I got error with SqlDataSource8 red under line says that afield initializer cannot reference the non static field, method or property

Richard Deeming 21-Jul-16 10:52am

So you're not using the code that Vincent posted?

Member 12618369 21-Jul-16 11:00am

No i am using it but I got red under line

Richard Deeming 21-Jul-16 11:03am

Well, you're not, because the code Vincent posted didn't have a field initializer.

It sounds like you've tried to post at least part of the code directly within the class, rather than within the body of a method within the class. In Vincent's code, the method is Page_Load.

Member 12618369 21-Jul-16 11:10am

Yeah Thanks very much I figured it out the last error but now when I run the program I got object reference not set to an instance of an object
at this line foreach (DataRowView drvSql in dvSql)

Richard Deeming 21-Jul-16 11:15am

Probably because you haven't provided a value for the @uid parameter, and the data source defaults to cancelling the select query if any parameter is null.

You'll need to retrieve the user ID from somewhere, and add the following line before calling Select:
SqlDataSource8.SelectParameters["@uid"].DefaultValue = theUserId;

Member 12618369 21-Jul-16 11:29am

thanks
the user id should be taken for the current user who are currently logged in but to take it no idea can please you provide example
I sorry If I annoying you
please help

Richard Deeming 21-Jul-16 11:30am

If you're just looking for the username, it's User.Identity.Name.

If you're looking for something else, then you'll need to tell us where the ID comes from.