Save multiple selected list items in database from dropdown list when selected

In this blog we will know how to save multiple selected list items in database from dropdown list when selected.

 

 

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Save_multiple_select_item_dropdown._Default" %>

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

    <title>Untitled Page</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

     <asp:DropDownList ID="DropDownList1" runat="server"

        onselectedindexchanged="DropDownList1_SelectedIndexChanged">

    </asp:DropDownList>

    </div>

    </form>

</body>

</html>

 

 

 

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

namespace Save_multiple_select_item_dropdown

{

    public partial class _Default : System.Web.UI.Page

    {

        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

        string str;

        SqlCommand com;

 

        protected void Page_Load(object sender, EventArgs e)

        {

            DropDownList1.AutoPostBack = true;

            SqlConnection con = new SqlConnection(strConnString);

 

            if (!IsPostBack)

            {

                DropDownList1.Items.Add("Choose Name");

                con.Open();

                str = "select * from  employee";

                com = new SqlCommand(str, con);

                SqlDataReader reader = com.ExecuteReader();

                while (reader.Read())

                {

                    DropDownList1.Items.Add(reader["empname"].ToString());

                }

                reader.Close();

                con.Close();

            }

        }

 

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

        {

            SqlConnection con = new SqlConnection(strConnString);

            con.Open();

            for (int i = 0; i < DropDownList1.Items.Count; i++)

            {

                if (DropDownList1.Items[i].Selected == true)

                {

                    str = "insert into employee1 values('" + DropDownList1.Items[i].ToString() + "')";

                    com = new SqlCommand(str, con);

                    com.ExecuteNonQuery();

                    Response.Write("<script>alert('Items Inserted');</script>");

                }

            }

        }

    }

}

 

 

Thanks for reading

 

 

Ebook Download
View all
Learn
View all