How to remove the checkbox values ?

Question

0.00/5 (No votes)

See more:

I have a checkbox which consists of values(Eg: Names) taken from a datatable. I need to remove the checked values after saving the details in a form.

Eg: If the checkbox has values like "Sam","Ferin","Robin" etc.., and if i select only "Sam" and Save the form, "Sam" should not be seen after the save event. Once the form is submitted, "Sam" should be removed and the checkbox should show only "Ferin" and "Robin".

Can anyone help me out with this???

Thanks in advance..

Posted 10-Mar-15 2:07am

Sam Ferin

Add a Solution

Comments

Santosh K. Tripathi 10-Mar-15 8:10am

what you have tried?

Sam Ferin 10-Mar-15 8:17am

I've tried this..

for (int i = 0; i < ChkEmpNoName.Items.Count; i++)
{
if (ChkEmpNoName.Items[i].Selected == true)
{
ChkEmpNoName.Items.RemoveAt(i);
}
}

But this isn't working..

[no name] 10-Mar-15 8:11am

You must be saving the value for which checkbox is selected.
Then just set visible = true for only those whose value is returned false from DB

Sam Ferin 10-Mar-15 8:19am

Actually the values can be saved "n" times.. So the same Name can repeat.

Praveen Kumar Upadhyay 10-Mar-15 8:41am

Are you loading checkbox dynamically?
You are fetching Names from database to show in checkbox.

Show some code, how you are loading checkbox values

Sam Ferin 10-Mar-15 8:46am

I'm loading the checkboxlist values by fetching it from database..

sQuery = "SELECT EmpNo, EmpName, Dept,(EmpName) + ' - ' + 'Month' + Convert(VARCHAR,Month) AS 'EmpData' FROM"
+ " PB_PayBillPreparedDetails

if (dtblEmpData.Rows.Count >= 1)
{
ChkEmpNoName.DataSource = dtblEmpData;
ChkEmpNoName.DataTextField = "EmpData";
ChkEmpNoName.DataValueField = "EmpNo";
ChkEmpNoName.DataBind();
}

Rajesh waran 10-Mar-15 9:04am

You mention that "If i select Sam and Save the form" then sam should remove.
Are you storing that selected(Sam) value to another table. If yes it is possible to load Checkbox without "Sam".

Sam Ferin 11-Mar-15 1:03am

Yes.. when i save "Sam" it will get stored in a datatable..

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Mar-15 10:32am

Where exactly you are storing the values for checkbox? What is that table structure?

Sam Ferin 11-Mar-15 1:09am

Firstly, I am fetching the names form another table and loading the names in the checkboxlist in a form. and the checked values will be saved in a different table. Now my requirement is to remove the checked name from the checkboxlist.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 11-Mar-15 3:17am

Refer my answer.

Sam Ferin 11-Mar-15 4:48am

Ok.. Thanks..

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 11-Mar-15 6:27am

Most welcome. :)

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2015-03-10T21:17:00

Quote:
Firstly, I am fetching the names form another table and loading the names in the checkboxlist in a form. and the checked values will be saved in a different table. Now my requirement is to remove the checked name from the checkboxlist.

While getting the names, you can just join the other table and get only those which don't have the checked status in that other table.

As easy as that !!!