ASP.NET ListBox Insert Multiple selected item into database

February 16, 2016 , 0 Comments

In this article, I will show you how to insert multiple selected item in  database table. I have already done one projects on this topic i.e online movie ticket booking system. In this project, i selected multiple tickets by using comma symbol in TextBox. The same article i will do in different manner. In this we have a ListBox with multiple selection mode.
What i do in code behind :

  1. Store the selected of ListBox items to the string type list.
  2. For the each item, i will create a Query statement, Suppose your List contain two items i.e "Apple" and "Mango", Both are selected then use String builder class to Append Query.
  3. Like "insert into [tablename] (fruitname)values('Apple')";  and for second item  "insert into [tablename] (fruitname)values('mango')";

Source Code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="multipleselect.aspx.cs" Inherits="multipleselect" %>

<!DOCTYPE html>

<html xmlns="">
<head runat="server">
    <form id="form1" runat="server">

        <asp:ListBox ID="ListBox1" runat="server" Height="100px" SelectionMode="Multiple" Width="174px">
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Save" />

Code Behind Code

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class multipleselect : System.Web.UI.Page
    protected void Page_Load(object sender, EventArgs e)

    protected void Button1_Click(object sender, EventArgs e)
        List<string> l1 = new List<string>();
        foreach (ListItem item in ListBox1.Items)
            if (item.Selected)


    private void recordinserted(List<string> l1)
       StringBuilder stringbi = new StringBuilder(string.Empty);
        foreach (string item in l1)
const string qry = "insert into [Fruits](FruitName)values";
        //throw new NotImplementedException();
        SqlConnection con = new SqlConnection();
        con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionStringtr"].ToString();
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = stringbi.ToString();
        int a= cmd.ExecuteNonQuery();

Code Generates the following output : 

ASP.NET ListBox Insert Multiple selected item into database

Jacob Lefore

Some say he’s half man half fish, others say he’s more of a seventy/thirty split. Either way he’s a fishy bastard. Google