how to insert the values of checkboxlist to sql database in web based application

Question

0.00/5 (No votes)

See more:

Sir,
I am getting error in this line:

MIDL

foreach(ListItem 1stitem in CheckBoxList1.Items)
        {
            if(1stitem.Selected==true)
            {
                s+=&quot;,&quot;+1stitem.Text;
            }

Here ListItem is not coming automatically and it is not accepting the object of ListItem.What is the problem?Why it is accepting?

My all codings are:

C#

SqlConnection cn = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=Q;Integrated Security=True");
    string s;
    protected void Page_Load(object sender, EventArgs e)
    {
        CheckBoxList1.Items.Add("BBSR");
        CheckBoxList1.Items.Add("BLR");
        CheckBoxList1.Items.Add("KJR");
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        cn.Open();
        foreach(ListItem 1stitem in CheckBoxList1.Items)
        {
            if(1stitem.Selected==true)
            {
                s+=","+1stitem.Text;
            }
        }
        Label1.Text=s;
        //SqlCommand cm = new SqlCommand("insert into registration values('"+CheckBoxList1.Text+"')",cn);
        //cm.ExecuteNonQuery();
        cn.Close();

    }

XML

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_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:CheckBoxList>
        <br />
        <br />
        <asp:Button ID="Button1" runat="server" Text="Submit" />

    </div>
    <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
    </form>
</body>
</html>

Posted 5-Jun-11 23:47pm

Banajyotsna

Updated 5-Jun-11 23:49pm

v2

Add a Solution

2 solutions

Solution 1

According to my understanding of the question,instead of:
if(1stitem.Selected==true)
{
s+=","+1stitem.Text;
}

you can write the code as below:
if(1stitem.Selected)
{
s+=","+1stitem.Value;
}

This will give you the value.
Hope this works.

Posted 6-Jun-11 0:05am

HinaMehta

Comments

Banajyotsna 6-Jun-11 6:50am

foreach(ListItem 1stitem in CheckBoxList1.Items)
Sir problem is in this line.The ListItem is not coming automatically and also my visual studio is not accepting the object of ListItem.Showing error 1stitem.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Toniyo Jackson · Accepted Answer · 2011-06-06T00:05:00

Solution 2

Everything is correct. But, the problem is in this variable 1stitem. You cannot use a integer in the first word of declaration. So just replace that and try. That's all your problem.

C#

foreach(ListItem stitem in CheckBoxList1.Items)
{
    if(stitem.Selected==true)
    {
        s += "," + stitem.Text;
    }
}

Posted 6-Jun-11 0:05am

Toniyo Jackson

Updated 6-Jun-11 1:16am

v3

Comments

Banajyotsna 6-Jun-11 6:51am

foreach(ListItem 1stitem in CheckBoxList1.Items)
Sir problem is in this line.The ListItem is not coming automatically and also my visual studio is not accepting the object of ListItem.Showing error 1stitem.

Banajyotsna 6-Jun-11 6:52am

here my visual studio is not accepting the object of ListItem

Toniyo Jackson 6-Jun-11 7:12am

see my updated answer

Banajyotsna 7-Jun-11 6:03am

Thanks a lot sir.It is running perfectly now.

Banajyotsna 7-Jun-11 6:03am

Thanks a lot sir.It is running perfectly now.Sir is this concept possible in window based application?Can you tell me this concept in window based application?Please sir

Toniyo Jackson 7-Jun-11 6:12am

You can not create a variable starts with integer in anywhere(windows, web).

Toniyo Jackson 7-Jun-11 6:12am

If it helps you vote and accept the answer :)

Banajyotsna 7-Jun-11 6:16am

i voted you and accepted this ans also.

Toniyo Jackson 7-Jun-11 6:18am

Okay. Thanks :)