How to savel multiple checkbox values in database table on button clik

Question

1.00/5 (1 vote)

See more:

i am used 4 diffrent checkbox i want save them in database on button click
how done this.Pease Help me.anyone Thank you..

What I have tried:

i am not use this code i dont know how do this i am paste this code for only formalty.
Please see my simple question and help me

for (int i = 0; i <=CheckBoxList1.Items.Count-1; i++)
   {

       if (CheckBoxList1.Items[i].Selected)
       {

           if (str == "")
           {
               str = CheckBoxList1.Items[i].Text;
           }
           else
           {
               str += "," + CheckBoxList1.Items[i].Text;

           }

       }
   }
   con.Open();
   SqlCommand cmd = new SqlCommand("insert into aa(a)values('" +str + "')", con);
   cmd.ExecuteNonQuery();

Posted 11-Feb-19 6:07am

Member 14083059

Updated 19-Feb-19 22:14pm

v2

Add a Solution

Comments

Richard MacCutchan 11-Feb-19 12:17pm

Look at all the suggested answers on the right hand side ----------->

[no name] 11-Feb-19 13:01pm

A "check box" is either true or false; what do you expect to save?

YYYYYNNNN?
FFFFFTTTT?

Or?

Member 14083059 12-Feb-19 1:01am

i want save checkboxs values in database.suppose i have 4 CheckBox like 1st is Football 2nd is Cricket 3rd one Boxing ...so on

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)

Member 14083059 · Answer 1 · 2019-02-19T22:15:00

Here the solution for using multiple checkBox to save values in your databse table

String activity = "";

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

use this code on your button before insert query.
"String activity" is define for your Checkbox.you can use any name instance of "activity" then you use this difened activity in your insert query.
Like this

String update = "update StdRegistration_db set Name= @name,ParentsName= @parentsname,DOB= @DOB,Gender=@Gender,ContactsNo= @contacts ,EmailID= @email,Address=address @,<big>Hobbies= @activity</big> where id=@id";

CHill60 · Answer 2 · 2019-02-12T01:37:00

So what do you want to save for the value? A bit field (good idea), the words "True" or False, "Yes" or "No" (bad ideas)

The code you posted is not doing a great deal of good, you are clearly heading down the road to SQL Injection land - SQL Injection - OWASP[^]. Use the correct techniques - Injection Prevention Cheat Sheet - OWASP[^]. Use parameterised queries!

You are also building up a comma-separated list of the checkbox text not the values. Even if you were using the right property storing anything as a comma-separated list in a database is a Bad Idea. Give each text box it's own column.. it is much, much easier to get information in and out of the database that way.

In the bottom right corner of this page is a list of "Related Questions" - try the solutions there first (that is partly what we mean by "do some research"), write some proper code and try it out. If you are still having problems after that come back (with your code) and we will try to help you further.

When you do come back avoid using terms like "plzz hlp me". The words are "please" and "help" - not everyone has English as their first language and using text-speak just makes it harder for them to understand your question - and that means they won't be able to (or inclined to) help you

How to savel multiple checkbox values in database table on button clik

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0