About Check Box List

Question

0.00/5 (No votes)

See more:

Dear Sir,

I'm developing windows application, in that one small requirement, Ist i'm getting city names from back end populating city names in the check box list,from that check box list what ever i select items i need to store in the back end.

Ex: Suppose if i select 5 items(Checkboxes) out of 10 i need to store five items in the back end.

Please provide the code for how to insert the multiple check boxes in the sql server 2005 by using c#.net and how to populate items to front end from back end.

Thanks
Venkataramaiah

Posted 13-Sep-11 21:46pm

VENKATNADENDLA

Updated 14-Sep-11 0:15am

Slacker007

v2

Add a Solution

Comments

Slacker007 14-Sep-11 6:15am

Edited for readability.

2 solutions

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)

Suresh Suthar · Answer 1 · 2011-09-14T00:31:00

Iterate all the Item of ListBox and check that that item is checked or not.

C#

string citye=string.Empty;
foreach (ListItem item in CheckBoxList1.Items)
           {
               if (item.Selected)
                   city += item.Value + "$";
           }

If you are using single column in your table to store city name you can add a unique separator e.g. $ or # to concatenate city name. (See above code sample)

Narendra S Patil · Answer 2 · 2011-09-14T00:33:00

Based on selected items in checkbox list, create coma (,) seperated string and insert the string in the column.

To populate and to display use following code

VB

arrTemp = Split(IIf(IsDBNull(MyDatarow("DeptName")), "", MyDatarow("DeptName")), ",")
                        For x = 0 To UBound(arrTemp)
                            For y = 0 To chkDepts.Items.Count - 1
                                If chkDepts.Items(y).Value = arrTemp(x) Then
                                    chkDepts.Items(y).Selected = True
                                End If
                            Next
                        Next

About Check Box List

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0