Dropdown list with multiple selections

tombert · #1 (**permalink**) March 5th, 2007, 09:42 AM

hi all,

I have a small problem. Let me explain my situation first. I am making a website with a ms sql database. In the backend of my site i have some kind of an user administration.
The user is selected by a listbox what opens a detailsview with all user data (username, password, level etc) also there is a website admin where i can add websites (websitename, url etc)
My problem:
I want to have a listbox in this detailsview also, connect 1 user to 1 OR more websites. Therefor i made a 3rd table what contains the userid an websiteid(this user can edit multiple website so for each website there wil be a new record)
This list has an own sqldatasource as source(the website table). This already works but i want to select the websites that are connected to this user how can i do this?

The List (stands in a <asp:templatefield> within the detailsview)

Code:

<asp:ListBox runat="server" ID="lstWebsites" SelectionMode="Multiple" DataSourceID="websites" DataTextField="website_name" DataValueField="website_id"></asp:ListBox>

The sqlDatasource:

Code:

<asp:SqlDataSource ID="websites" runat="server" ConnectionString="<%$ ConnectionStrings:BugLoggerConnectionString %>" 
SelectCommand="SELECT website_id, website_name, (SELECT website_id FROM l_user_website  WHERE  website_id = w.website_id AND user_id = @user_id) AS edit FROM website w WHERE (deleted = 0)">
  <SelectParameters>
    <asp:ControlParameter ControlID="lst_Users" Name="user_id" Type="Decimal" />
    <asp:Parameter DefaultValue="false" Name="deleted" Type="Boolean" />     
  </SelectParameters>      
</asp:SqlDataSource>

dparsons · #2 (**permalink**) March 5th, 2007, 09:55 AM

I don't understand what you are asking, however, based on the title of your Post, a dropdownlist CANNOT have multiple selections within the list a listbox, however, can.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

tombert · #3 (**permalink**) March 5th, 2007, 09:57 AM

im sorry as you can see in the first codeblock i am using a listbox

dparsons · #4 (**permalink**) March 5th, 2007, 10:00 AM

Yes i see that. And, as I said, I based that response on the title of your post. In any case, you have not made it anymore clear to me as to what you are trying to accomplish??

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

tombert · #5 (**permalink**) March 5th, 2007, 10:10 AM

pff to bad. its hard enough for my to try to explain my problem :)
but here i go:

what i want is a listbox wich contains all the websites. And the websites that are connected to the selected user must be selected.
i can make this outside the detailsview and do the binding in the page_load by using a loop of something but that is not very practical. i want to try to make this without any codebehind code but i dont realy know if this is possible.

hope this clear it up a little

dparsons · #6 (**permalink**) March 5th, 2007, 10:17 AM

Doing it w/o code behind is not going to be probable if not impossible (I think).

Couple of things you may want to consider:

Handle the item onChanged event of the dropdown and pass the selected item of the dropdown into a stored procedure to return that particular users websites and populate the list box based on the values that are returned.

You may also want to consider looking into Data Relation, however, I don't have much experience using data relation with Datasets and such, but it may be a viable option for you.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

tombert · #7 (**permalink**) March 5th, 2007, 11:13 AM

i have got this now in my page_load:

Code:

  If lst_Users.SelectedValue > 0 Then
            Dim lst As ListBox = CType(Me.User_detail.FindControl("lstWebsites"), ListBox)
            Dim id
            Dim dt As ds_user.userDataTable = bl.getUserWebsites(lst_Users.SelectedValue)
            Dim sel As ds_user.userRow
            For Each sel In dt
                id = sel("website_id").ToString
                lst.Items.FindByValue(id).Selected = True
            Next
        End If

it returns a table with website_id's wich have to be selected. The first time the page
loads this works just fine but when i select an other user none of the items in the list
wil be selected. There is at least 1 website to be selected. but it doesnt. When i use
a break point the code wil go through the loop but still none of the websites is selected.
how is this possible?

dparsons · #8 (**permalink**) March 5th, 2007, 11:27 AM

You don't set any values to be selected in code?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

tombert · #9 (**permalink**) March 5th, 2007, 11:29 AM

nope only there

dparsons · #10 (**permalink**) March 5th, 2007, 11:36 AM

hmmm I am not really sure what is going on with this. Though I may change my condition to

If lst_Users.SelectedIndex > -1 Then

Of course that doesn't explain why your loop executes and no items are selected, of course, I would say that when you do your finditem the runtime doesn't see the value you are looking for or it doesnt exist.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Need to download code?

Navigation