Send Multiple Checkox text to sql database using asp.net csharp [Resolved]

Posted by Salman under ASP.NET on 2/15/2013 | Points: 10 | Views : 2747 | Status : [Member] | Replies : 4
Hi,

Can anyone please help me with the code, i want to send the multiple checkbox text values to sql database i am using asp.net C sharp and sql server 2005 as database

Thanks in advance

Salman Farooqui


Responses

Posted by: Satyapriyanayak on: 2/15/2013 [Member] [MVP] Silver | Points: 50

Up
0
Down

Resolved
<%@ 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="Button1" runat="server" onclick="Button1_Click" Text="Button" />
</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 Button1_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");

}
}
}




Thanks
If this post helps you mark it as answer

If this post helps you mark it as answer
Thanks

Salman, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sakthi.Singaravel on: 2/15/2013 [Member] Silver | Points: 25

Up
0
Down
see the our old query...
http://www.dotnetfunda.com/codes/code908-to-insert-multiple-checkbox-list-values-into-database-in-single-column-usin.aspx

Regards,
Singaravel M

Salman, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Salman on: 2/16/2013 [Member] Starter | Points: 25

Up
0
Down
Thank you so much it worked for me...thanks again

Salman Farooqui

Salman, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Satyapriyanayak on: 2/16/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
If this post helps you mark it as answer

Thanks

If this post helps you mark it as answer
Thanks

Salman, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response