How to store checkboxlist value?

Question

1.00/5 (1 vote)

See more:

I want to store multiple value of checkboxlist

here is my checkbox list

XML

<asp:CheckBoxList ID="chkMaritalStatus" runat="server" CssClass="rb" RepeatDirection="Horizontal">
<asp:ListItem>Unmarried</asp:ListItem>
<asp:ListItem>Widow</asp:ListItem>
<asp:ListItem>Divorced</asp:ListItem>
<asp:ListItem>Awaiting divorce</asp:ListItem>
<asp:ListItem>Any</asp:ListItem>
</asp:CheckBoxList>

and i want to multiple items in my database how can i do that?

Posted 10-Jul-12 19:14pm

shinebudy

Updated 10-Jul-12 19:30pm

Rahul Rajat Singh

v2

Add a Solution

Comments

vangapally Naveen Kumar 11-Jul-12 1:15am

Can You elaborate more.....

2 solutions

Solution 2

C#

Here,chklstSubject is checkbox name and we are store selected items in sub.

          String sub="";
          for (int i = 0; i < chklstSubject.Items.Count; i++)
            {
                if (chklstSubject.Items[i].Selected)
                {
                    sub += chklstSubject.Items[i].Value + ",";
                }
            }
            sub = sub.TrimEnd(',');

insert sub into query,

String qr="insert into tabl1 values('"+sub+"')";

Posted 4-Sep-12 21:51pm

Member 9334390

Add a Solution

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

Vani Kulkarni · Accepted Answer · 2012-07-10T19:20:00

Assuming that your database contains single column called MaritalStatus which can accept comma separated values, see if below code helps you:

C#

string status= string.Empty; 
        foreach (ListItem item in this.CheckBoxList1.Items) 
            if (item.Selected) 
                status += item + ","; 
 
        SqlCommand cmd = new SqlCommand("Insert into Demo values('" + status+ "')", cn); //Write Your Query to insert into database table        
        cn.Open(); 
        int iCount = cmd.ExecuteNonQuery(); 
        cn.Close();

How to store checkboxlist value?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to store checkboxlist value?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us