how to set checkedlistbox check ture only for data present in dataset C# VS 2008

Question

0.00/5 (No votes)

See more:

VS2008

Hello everyone,
I am having a problem with checkedlistbox, can anyone help me, or give me some idea what should i do to fix this thing..

I have a Checkedlistbox with jobs in it.
I want to check the jobs assigned to employees from dataset and check only those jobs true..
The problem is when it checks the 1st Job true,
it comes out of foreach loop and throws exception.
"List that this enumerator is bound to has been modified. An enumerator can only be used if the list does not change."
This is the code i have written,

C#

string sSQL="select JOBNO from RentalVehicle";
dataset ds = munshi.executeDS(sSQL,"Jobs").Tables["Jobs"];

                    foreach(DataRow Erow in ds.Rows)	
		    {
                    int CLB_RowNo = 0;
                    string[] JNos = Erow["JOBNO"].ToString().Split(', ');	//Jobdetail(2010-0191, HWS-01, ISB-6,KAD2-2, MAINT-01, PMO-2011-0052)

                    string SelectedJob = "", AJob = "";
                    foreach (Object obj in CLB_JobNo.Items)	// Looping CLB_JobNo(CheckedListBox)
                    {
                        int i = 0;
                        SelectedJob = obj.ToString();
                        foreach (string part in JNos)
                        {
                            AJob = JNos[i].ToString();
                            if (SelectedJob == AJob)
                            {
                                CLB_JobNo.SetItemChecked(CLB_RowNo, true);
                            }
                            i++;
                        }
                        CLB_RowNo++;
                    }

Thanks for every reply..

Posted 2-Oct-12 19:47pm

zainknoman

Updated 2-Oct-12 20:44pm

DaveAuld

v3

Add a Solution

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)

Mohd. Mukhtar · Accepted Answer · 2012-10-02T21:05:00

Hi,

Your inner loop traversal is incorrect.

In innner loop you have used foreach but accessing item with i(variable);

Modify the inner loop code as below.

C#

string sSQL="select JOBNO from RentalVehicle";
dataset ds = munshi.executeDS(sSQL,"Jobs").Tables["Jobs"];

foreach(DataRow Erow in ds.Rows)
{
   int CLB_RowNo = 0;
   string[] JNos = Erow["JOBNO"].ToString().Split(', ');
   //Jobdetail(2010-0191, HWS-01, ISB-6,KAD2-2, MAINT-01, PMO-2011-0052)

   string SelectedJob = "", AJob = "";
   foreach (Object obj in CLB_JobNo.Items) // Looping CLB_JobNo(CheckedListBox)
   {
        SelectedJob = obj.ToString();
        foreach (string part in JNos)
        {
            AJob = part.ToString();
            if (SelectedJob == AJob)
            {
                  CLB_JobNo.SetItemChecked(CLB_RowNo, true);
            }
         }
         CLB_RowNo++;

    }
}