Multiple Control on Checkbox

Question

1.00/5 (1 vote)

See more:

Hi everyone,

I have a form with eight checkbox.

My intention is to control if the checkbox is checked, so I used this code:

C#

if(cbMouse.Checked == true) 
{
//do something
}

When checkbox is checked I want to insert the checkbox's name into a sql parameter.
For example:

C#

if(cbMouse.Checked == true)
{
string query = "INSERT INTO TEST (things) VALUES (@things)";
SqlCommand cmd = new SqlCommand(query, cn);

cmd.Parameters.Add("@things", cbMouse.Text.ToUpper());

My question is: how I can do a multiple control for eight checkbox and insert checkbox's name into a single sql parameter (@things) ?

Posted 26-Nov-14 21:19pm

nicola_melc

Add a Solution

Comments

Sergey Alexandrovich Kryukov 27-Nov-14 3:26am

"if (cbMouse.Checked == true)" is nonsense. cbMouse.Checked is Boolean, and then you compare a Boolean value with true, to get another Boolean.
If should be
if (cbMouse.Checked) //...

Sorry for not answering your question. You first need to sort out the basics.

As to your question... What is "multiple control"? What is checkbox's name? The property "Name"? Why using it?...
All that doesn't seem to make sense...

—SA

DamithSL 27-Nov-14 3:30am

SA, I know you mean "if (cbMouse.Checked)", but mistakenly past same code in your comment.

Sergey Alexandrovich Kryukov 27-Nov-14 3:49am

Oh, sure, thank you very much.
—SA

DamithSL 27-Nov-14 3:32am

assume two checkboxes checked out of 8 checkboxes, then what is the sql statement you want to build? what is the value you expected as @things?

nicola_melc 27-Nov-14 3:38am

So , I am creating an application to manage computer's repair.
When a customer leaves the PC , it could happen that leave the power adapter, mouse or some other object.
I use checkbox to manage this object.

I have 8 checkbox called : cb1, cb2, cb3, cb4, cb5, cb6, cb7, cb8.

I want to control if this 8 checkbox are checked.
And if are checked, write checkbox's name (cb1.Text or cb2.Text ....) into a sql parameter (@things).

For multiple control I refer to the if-else structure to do. Or how can i do? There is another way?

Maybe, now the problem is more clear.

1 solution

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)

Marcin Kozub · Accepted Answer · 2014-11-26T21:44:00

Hello,

Put Panel control (name it panThings) on your form and then move your checkboxes to that panel to group them.
Then use this code:

C#

var things = string.Join(",", panThings.Controls.OfType<CheckBox>().Where(x => x.Checked).Select(x => x.Text.ToUpper()));

string query = "INSERT INTO TEST (things) VALUES (@things)";
SqlCommand cmd = new SqlCommand(query, cn);

cmd.Parameters.Add("@things", things);

And don't forget to add System.Linq to your using clause at top of the file.

[Update 1]
Suppose that you have checkboxes with texts:
Mouse, Keyboard, Hard drive, Monitor and so on.
Then if you check i.e. Mouse and Monitor checkboxes output will be:

Mouse,Monitor

And that value will be stored in DB.

[Update 2 - Answer to comment]
To restore selected items do this:

C#

// Get your thing from DB
var thingsFieldValue = dt.Rows[0]["PUT_YOUR_THINGS_DB_FIELD_NAME_HERE"].ToString();
// Split them and store in string[] (array of string)
var things = thingsFieldValue.Split(",".ToCharArray());

// Iterate through all elements in array
foreach (var thing in things)
{
    // Find proper CheckBox control
    var checkBox = panThings.Controls.OfType<CheckBox>().Where(x => x.Text.ToUpper() == thing).FirstOrDefault();
    // If checkbox was found, set its Checked property
    if (checkBox != null)
    {
        checkBox.Checked = true;
    }
}

Cheers!