How to bind a checkedlistbox to a combobox and a textbox at the same time in C#?

Question

5.00/5 (1 vote)

See more:

, +

I have database in ms access. I have connected it to C#.
The user needs to select a crane type through a combobox. The moment that user selects the item in the combobox I want to have some items related to that choice in a checkedlistbox, which I have done this part. The next step which I do not know how to do is that to refine the items in the checkedlistbox, there are 2 textboxes for minimum and maximum capacity of the crane. When user enters the minimum number I want the checkedlistbox updated and again when user enters the maximum capacity in the second textbox the last filter applied the final items populated in the checkedlistbox.

This is my table in the database

| Crane Index | Crane Model Number |  Crane Type | Crane Capacity Rating (tons) |
|:-----------:|:------------------:|:-----------:|:----------------------------:|
| 221         | LR 1400-1          | Crawler     | 440                          |
| 258         | CC 2800            | Crawler     | 660                          |
| 262         | CC 2400-1          | All Terrain | 400                          |
| 265         | CC 6800            | Crawler     | 1375                         |
| 277         | LR 11350           | All Terrain | 1250                         |

What I have tried:

C#

<pre>List<string> crane_type = new List<string>();
            for (int i = 0; i< test.Tables["cranemaintable"].Rows.Count; i++)
            {
                if (!crane_type.Contains(test.Tables["cranemaintable"].Rows[i]["crane type"]))
                {
                    crane_type.Add(Convert.ToString(test.Tables["cranemaintable"].Rows[i]["crane type"]));
                }                
            }        
            //bind the crane_type list to the combobox1
            comboBox1.DataSource = crane_type;

C#

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
       {
           //clear the checkedboxlist everytime that the combobox itme is changed
           checkedListBoxCrane.Items.Clear();
           //loop through the "cranemaintable" table and if the item that selected in the combobox is
           //equal to the "crane type" column then populate that item into the checkedlistbox
           foreach(DataRow item in test.Tables["cranemaintable"].Rows)
           {
               if (Convert.ToString(item["crane type"]) == Convert.ToString(comboBox1.SelectedItem))
               {
                   checkedListBoxCrane.Items.Add(Convert.ToString(item["crane model number"]));
               }

           }

       }

Posted 12-Sep-20 19:39pm

Ramtin992

Updated 14-Sep-20 6:31am

Add a Solution

Comments

[no name] 13-Sep-20 10:46am

In this case, you're better off setting the checkboxes when you "save", or try to save. Because, you also need to "uncheck" if the user starts reverting their original choices.Sounds like some "completed checklist" so checking "at the end" is not uncommon.

Ramtin992 13-Sep-20 15:19pm

Could you please explain a little more? I am pretty new to c#
Thank you.

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)

BillWoodruff · Accepted Answer · 2020-09-14T06:32:00

Solution 1

I'm not going to write our code for you, but, I hope I can give you some ideas:

1 to fill the ComboBox with a set of nom duplicate items:

// dt is the DataTable
// c2 is the #2 DataColumn

var cval = dt.AsEnumerable().Select(row => row[c2]).Distinct().Select(rw => rw.ToString()).ToList();

comboBox1.DataSource = cval;

2 filling the CheckdListBox when the ComboBox selection changes:

private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
{
    checkedListBox1.Items.Clear();

    string csel = comboBox1.SelectedValue.ToString();

    foreach(DataRow row in dt.Rows)
    {
        if (row[2] == csel)
        {
            checkedListBox1.Items.Add($"{row[1]}\t\tMax Tons: {row[3]}");
        }
    }
}

Here, I made a choice to append the max tons to the string displayed in the CheckedListBox.

3 At this point we come to your goal to filter the CheckedListBoxItems by minimum and maximum capacity values. I suggest you use NumericUpDown Controls for user input.

It's too bad that CheckedListBoxItems do not have a 'Tag property you could stick the max capacity in. I suggest you create a reference Dictionary to map the ComboBoxItems to the combination of (perhaps a Tuple ?) of CraneModel and max capacity: then, when the user changes the capacity, min, or max, you can iterate this Dictionary to rebuild/update the CheckedListBoxItems,

// sketch Dictionary<comboboxitem, list<(?,="" ?.capacity)="">

Does the end-user really need to enter both min and max ?

Posted 14-Sep-20 6:32am

BillWoodruff

Comments

Ramtin992 14-Sep-20 13:22pm

Thanks for your response.
No, the user does not have to put a number there, it is optional to refine the results if he or she wants.

I got an error for this section:
string csel = comboBox1.SelectedValue.ToString();
it says: Object reference not set to an instance of an object
How can I fix this? I know the reason but how can I fix it?
I have comboBox1.SelectedItem = null; as I want the combobox be null at the beginning of the program.

BillWoodruff 14-Sep-20 17:25pm

Now is the good part :) where you learn to debug. Start by putting breakpoints in the ComboBox: if you never hit the breakpoint, then you haven't wired up the SelectedValueChanged eventhandler for the ComboBox.

if the ComboBox throws an error on string csel = comboBox1.SelectedValue.ToString();

Then use a breakpoint before that line and examine if you have actually added the values to the ComboBox.

The code examples I showed you are all dependent on the DataTable being fully configured. GThe first example requiress you have an instance of a DataColumn in a variable 'c3.

Ramtin992 14-Sep-20 21:06pm

Thanks again for your help. I could fix it.
I should mention that I really liked your idea.
Also this part is great :
checkedListBox1.Items.Add($"{row[1]}\t\tMax Tons: {row[3]}");
There is a weird problem here, it is working but in a weird way
There are 13 items that populate in the checkelistbox and all of them are aligned with eachother except for two of them, it seems that those to items do not accept the " \t\t" in the code and attache to the {row[1]}.
If it happened for all of them I thought that I have done something wrong, but it is just for 2 items that happend always. Those two does not align with the rest of the items.

BillWoodruff 15-Sep-20 5:14am

hypothesis: the /t is a tab character ... probably the line was cut off because it was too long to fit the boundaries of the CheckedListBox control ... try replacing the tabs with a few spaces and see ...

Ramtin992 15-Sep-20 9:48am

I have done this:
checkedListBox1.Items.Add($"{row[1]}>>\tMax Tons: {row[3]}");
It is working perfectly.
Thank you.

BillWoodruff 15-Sep-20 10:12am

fyi: you could use a ListView which will show CheckBoxes, and has multiple columns.

please vote on solutions: feedback, pro, or con, helps the CP community.

Ramtin992 15-Sep-20 10:17am

Yes, I am sure there are so many other ways to do it better, but as you might notice I am pretty new to programming and especially c#. I will try to improve my code. Thanks for your help and also being patient with me.
Sure I will vote.

BillWoodruff 15-Sep-20 10:41am

Don't worry, everyone here was a beginner at some point in time :) And, depending on your goals and means, you may need to be a "perennial" student ... to keep up with language, and framework, evolution.

Yes, there are many ways you could implement a UI for presenting this type of data, and giving the app-user methods to manipulate the views.

I think it's always good to keep asking the question: "what does the user need to do, and, want to do?"

Sometimes programmers get intoxicated by the options, and the latest features, controls, etc. :)

TheRealSteveJudge 16-Sep-20 3:15am

5* for good solution and encouraging as well as useful comments

BillWoodruff 16-Sep-20 6:05am

Thank you, Steve, your comment is valued !