ASP.Net: Insert multiple selected items of listbox to database as comma separated - Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial

ASP.Net: Insert multiple selected items of listbox to database as comma separated

In this article I am going to explain how to insert multiple selected items of Listbox to database as comma separated in ASP.Net using C# and VB.net
Implementation:

HTML Markup:
<fieldset style="margin-left: 40px;width:30%">
    <legend><strong>Multiple selected values of ListBox</strong></legend>
    <table>
    <tr><td>Select Technology :</td><td>  <asp:ListBox ID="lstboxtech" runat="server" SelectionMode="Multiple">
        <asp:ListItem>Asp.net</asp:ListItem>
         <asp:ListItem>Php</asp:ListItem>
          <asp:ListItem>Java</asp:ListItem>
        </asp:ListBox></td></tr>
    <tr><td></td><td> <asp:Button ID="btnsubmit" runat="server" Text="Submit" /></td></tr>
    </table>
    </fieldset>  

Add the namespace
C# code:
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

VB.net code
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration

Create sqlconnection
C# code:
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ToString());

VB.net code
Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("connection").ToString())

On button click write the given code
C# code:

protected void btnsubmit_Click(object sender, EventArgs e)
    {
        try
        {
            SqlCommand cmd = new SqlCommand("Insert into Tb_Technology(Technology) values(@technology)", con);
            String str = "";
            for (int i = 0; i <= lstboxtech.Items.Count - 1; i++)
            {
                if (lstboxtech.Items[i].Selected)
                {
                    if (str == "")
                    {
                        str = lstboxtech.Items[i].Text;
                    }
                    else
                    {
                        str += "," + lstboxtech.Items[i].Text;
                    }
                }
            }
            cmd.Parameters.AddWithValue("@technology", str);
            con.Open();
            cmd.ExecuteNonQuery();
            Response.Write("<script>alert('Record Insert SUccessfully');</script>");
            lstboxtech.SelectedIndex = -1;
        }
        catch (Exception ex)
        { }
    }

VB.net code
    Protected Sub btnsubmit_Click(sender As Object, e As System.EventArgs) Handles btnsubmit.Click
       Try
            Dim cmd As New SqlCommand("Insert into Tb_Technology(Technology) values(@technology)", con)
            Dim str As [String] = ""
            For i As Integer = 0 To lstboxtech.Items.Count - 1
                If lstboxtech.Items(i).Selected Then
                    If str = "" Then
                        str = lstboxtech.Items(i).Text
                    Else
                        str += "," + lstboxtech.Items(i).Text
                    End If
                End If
            Next
            cmd.Parameters.AddWithValue("@technology", str)
            con.Open()
            cmd.ExecuteNonQuery()
            Response.Write("<script>alert('Record Insert SUccessfully');</script>")
            lstboxtech.SelectedIndex = -1
        Catch ex As Exception
        End Try
    End Sub



What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.

Share this

Share on FacebookTweet on TwitterPlus on Google+


EmoticonEmoticon