seleceting multiple values from checkbox

Question

1.00/5 (1 vote)

See more:

hi....
is this possible to store 2 or more selected check-box values in same column in data base.i am using asp.net 3.5 and sql 2005..

Actually i want to say that if select one check-box then it stored in one column in database but if i select multiple check-box at one time then also its value should stored in same column....
please help me out........
thanks

Posted 3-Aug-11 19:09pm

vivek_cool

Add a Solution

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)

Abhinav S · Accepted Answer · 2011-08-03T20:02:00

What you are doing is not quite correct.
You should ideally be storing all the values of the list in a table.

Based on what the user chooses, we should save a key and all the values selected as separate rows in a table used for tracking what the user has selected.

Saving items in a concatenated format violates first normal form.

m@dhu · Accepted Answer · 2011-08-03T19:15:00

Solution 1

CheckBoxList
Yes you can use a delimiter and append all the selected values and insert into single database column. Split using the delimiter while retrieving from database.

[update]

C#

StringBuilder sb = new StringBuilder();
           foreach (ListItem item in CheckBoxList1.Items)
           {
               if (item.Selected == true)
               {

                   sb.Append(item.Text + "|");
               }
           }
           //Response.Write(sb.ToString());
           //insert the sb value into the database

[/update]

Posted 3-Aug-11 19:15pm

m@dhu

Updated 3-Aug-11 19:37pm

v2

Comments

vivek_cool 4-Aug-11 1:29am

hey thanks.. for your reply but how we can do that ca u please tell me brifly

m@dhu 4-Aug-11 1:38am

I have updated the solution with code check it.

Abhinav S 4-Aug-11 1:56am

Reasonable solution. 5. No need to downvote it at all.
But what the user is doing violates the first normal form.

m@dhu 4-Aug-11 2:09am

But what the user is doing violates the first normal form.
That explains it. Thanks.

vivek_cool 4-Aug-11 5:13am

k i get it thanks and By the way we can also used Comma separator also na

vivek_cool 4-Aug-11 5:13am

k i get it thanks and By the way we can also used Comma separator also na