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 :
Source Code
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="multipleselect.aspx.cs" Inherits="multipleselect" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:ListBox ID="ListBox1" runat="server" Height="100px" SelectionMode="Multiple" Width="174px">
<asp:ListItem>Apple</asp:ListItem>
<asp:ListItem>Grapes</asp:ListItem>
<asp:ListItem>Orange</asp:ListItem>
<asp:ListItem>Mango</asp:ListItem>
<asp:ListItem>Pea</asp:ListItem>
</asp:ListBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Save" />
</form>
</body>
</html>
What i do in code behind :
- Store the selected of ListBox items to the string type list.
- 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.
- 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="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:ListBox ID="ListBox1" runat="server" Height="100px" SelectionMode="Multiple" Width="174px">
<asp:ListItem>Apple</asp:ListItem>
<asp:ListItem>Grapes</asp:ListItem>
<asp:ListItem>Orange</asp:ListItem>
<asp:ListItem>Mango</asp:ListItem>
<asp:ListItem>Pea</asp:ListItem>
</asp:ListBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Save" />
</form>
</body>
</html>
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)
{
l1.Add(item.Text);
}
}
recordinserted(l1);
}
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";
stringbi.AppendFormat("{0}('{1}');",qry,item);
}
//throw new NotImplementedException();
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionStringtr"].ToString();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = stringbi.ToString();
cmd.Connection=con;
int a= cmd.ExecuteNonQuery();
if(a>0)
{
Response.Write("inserted");
}
}
}
Code Generates the following output :
Code Generates the following output :
