how to insert multiple selected items from listbox to database

Question

I have two listboxes and i want to insert multiple selected values from both listboxes to database. Let me explain :-

<asp:ListBox ID="ddlSuperior" runat="server" SelectionMode="Multiple">
<asp:ListBox ID="ddlSubordinate" runat="server" SelectionMode="Multiple">

and a submit button

<asp:Button ID="btnSubmit" runat="server" Text="Submit" />

Suppose i select 2 values from ddlSuperior and 1 value from ddlSubordinate. How can i do that..?

On submit button click, i want to insert - 2 selected values from ddlSuperior and 1 selected value from ddlSubordinate to a database 'tblPosition' with columns - id,superior and subordinate. — David
– David, Commented Jan 15, 2013 at 13:54
You have one column for superior but the user must select two? I would suggest to add another superior column then. — Tim Schmelter
– Tim Schmelter, Commented Jan 15, 2013 at 13:57

Community · Accepted Answer · 2017-05-23 11:50:50Z

0

Well, there are quite a few ways.

    Dim superiorIndexes = ddlSuperior.GetSelectedIndices
    Dim vals = superiorIndexes.Select(Function(i) ddlSuperior.Items(i).Value)
    Dim subordinateIndexes = ddlSubordinate.GetSelectedIndices()

    vals = vals.Concat(subordinateIndexes.Select(Function(i) ddlSubordinate.Items(i).Value))

    For Each val As String In vals

        ' Code to do db insert

    Next

Find db example here: C# SQL insert command Look at Marc_S answer.

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered Jan 15, 2013 at 13:44

Darthg8r

12.7k15 gold badges66 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to insert multiple selected items from listbox to database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related