restrict to select checkbox inside the checkedlistbox

Question

0.00/5 (No votes)

See more:

its a windows application., i used checkedlist to show in the form dynamically., written code for mouse click even., here if user click more than one checkbox message should show like "already 1 items choosed" so the use will uncheck the previous item and then they will choose another 1., but in my case user can select more than 1 items since message box shown.,

C#

void ch9_MouseClick(object sender, EventArgs e)
       {
           try
           {


               gn.cnopen();
               string get_max_items = "select max_items from menu_group where group_name='icecream'";
               cmd = new SqlCommand(get_max_items, gn.cn());
               int max_items = Convert.ToInt32(cmd.ExecuteScalar());

               int count = ch9.CheckedItems.Count;

               if (count >= max_items)
               {
                   MessageBox.Show("Already Choosed--" + max_items.ToString() + "--Items");
                   return;
               }
           }
           catch (SqlException err)
           {
               MessageBox.Show(err.Message);
           }
       }

Posted 14-Nov-12 22:34pm

Umapathi K

Add a Solution

Comments

Erik Rude 16-Nov-12 11:26am

I'm not sure your question and your code are well aligned.
Looks to me like you're opening a connection to a database asking how many menuitems thare are in the Icecream group and then you're counting how many checkboxes you've got checked in ch9. if more than the number of menus then you show the message.

There are many issues in your code.

First when you open a connection you need to close it as well (or at least that is good practice)

Are you sure that select max_items from menu_group where group_name='icecream' returns the value you think it should do? It may, but if you really want a count you could do something like
select count(*) from menu_group where group_name='icecream'

Have you tried debugging your function so you can inspect the values (and hence better understand the behaviour)?

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)