how to insert two different checkbox values in one column of table

Question

0.00/5 (No votes)

See more:

i am having two checkboxes for two languages. If user checked both of them then how to save both checked values in one language column of table.

Posted 2-Dec-14 19:57pm

Jayesh27j

Add a Solution

Comments

Karthik_Mahalingam 3-Dec-14 3:25am

use comma separated value mechanism.

4 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)

Sinisa Hajnal · Answer 1 · 2014-12-02T20:14:00

Simple answer is: YOU SHOULD NOT!

You should use additional table that will have foreign key on the main table and insert one or more rows into languages depending on the checkboxes. This is easily scalable (adding new languages changes only user interface), can be sorted, ordered, joined to other tables etc...

If you absolutely have to put them into single field, your best bet is comma separated list. Drawbacks of this severe: each time you have to access the field, you have to parse the values, you cannot search by it or order by it, you cannot join to other tables etc...

It would be better even to add a column separate for each language (also bad design, hope that you will never have to adapt to new language) then to put everything into single column.

If this helps please take time to accept the solution. Thank you.

Praveen Kumar Upadhyay · Answer 2 · 2014-12-02T20:52:00

Solution 3

Insert another row with another language selected or Store two checkbox values comma separated in column.

Posted 2-Dec-14 20:52pm

Praveen Kumar Upadhyay

vikaskallidantheyil · Answer 3 · 2014-12-02T21:28:00

you can use some delimeters like '^' and save data.

ex;
data stored in db would be like this
lang1^lang2.

when you want to access those values you can split it like this

take the whole value into one variable called lang after that you can do the below coding

lang1= lang.Split('^').First;
lang2= lang.Split('^').Last;

Badal Kumar · Answer 4 · 2014-12-02T20:05:00

Solution 1

Here you should use radio button or create another bit field in database i.e. one for English and another on for other language.

Posted 2-Dec-14 20:05pm

Badal Kumar

Comments

Thanks7872 3-Dec-14 2:18am

Radio button is used you have only one option to be selected. Here, user can select two options also.

how to insert two different checkbox values in one column of table

4 solutions

Solution 2

Solution 3

Solution 4

Solution 1

Add your solution here

Preview 0