In this blog we will know how to insert multiple CheckBoxList
values to database in web.
<%@ Page Language="C#"
AutoEventWireup="true"
CodeBehind="Default.aspx.cs"
Inherits="Insert_multiple_Value_CheckBoxList._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:CheckBoxList ID="CheckBoxList1" runat="server">
<asp:ListItem>a</asp:ListItem>
<asp:ListItem>b</asp:ListItem>
<asp:ListItem>c</asp:ListItem>
</asp:CheckBoxList>
</div>
<asp:Button ID="btn_insert" runat="server"
Text="Insert"
onclick="btn_insert_Click" />
</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
Insert_multiple_Value_CheckBoxList
{
public partial class _Default : System.Web.UI.Page
{
string
connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlCommand
com;
protected
void btn_insert_Click(object
sender, EventArgs e)
{
SqlConnection
con = new SqlConnection(connStr);
string
s1 = string.Empty;
foreach
(ListItem item in
this.CheckBoxList1.Items)
{
if
(item.Selected)
{
s1 = item.ToString();
com = new SqlCommand("Insert into test values('" + s1 + "')", con);
con.Open();
com.ExecuteNonQuery();
con.Close();
}
}
Response.Write("Inserted Successfully");
}
}
}