how to save the checkbox selected value in database

Question

2.00/5 (1 vote)

See more:

Hi friends,

am working on asp.net c# and SQLSERVER 2005.

on my webpage i have gridview with checkboxes, user can select only one checkbox from list of checkboxes inside gridview.

In this gridview i have 3 columns as UserName,Password,Status

and also i have submit button outside gridview.

So my requirement is :
----------------------

when user select one checkbox and click on submit button. In Database table it must insert status =1

This must happen when chckbox slected and submit button clicked.

Please can you help me

Thanks.

Posted 5-Oct-13 21:28pm

Member239258

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)

sankarsan parida · Answer 1 · 2013-10-05T21:39:00

Please see the idea to get checkbox details from each row of gridview

foreach (GridViewRow row in GridView1.Rows)
            {
                CheckBox cb = (CheckBox)row.FindControl("CheckBoxID");
                if (cb.Checked)
                {
                //write your code
                }
                else {
                //write your code
                }
            }

sankarsan parida · Answer 2 · 2013-10-05T21:52:00

see i couldn't know your exact code but i am showing you how to do it

foreach (GridViewRow row in GridView1.Rows)
{
CheckBox cb = (CheckBox)row.FindControl("CheckBoxID");
HiddenField hdnid =(HiddenField) row.FindControl("hdnId");
//Bind your database primary key id in a hidden field, and find it here
if (cb.Checked)
{
//write your code
int ID = Convert.ToInt32(hdnid.Value);
string query = "update tableName set status=1 where id="+ID;
dal.UpadateTable(query);
}
else {
//write your code
}
}

how to save the checkbox selected value in database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0