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">

<title>Untitled Page</title>

</head>

<body>

<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