Solved

Trouble with binding source and combo boxes in C#

Posted on 2014-02-04
5
531 Views
Last Modified: 2014-02-05
Hi experts

I need some help on binding source and combo box.
I have two combo boxes and both are bound to the same binding source.

           // There are two classes.
            public class SchoolClass
            {
                   public string ClassName {get;set;}
                   public int Id { get; set;}
                   public BindingList<Student> Students {get;set;}
            }

            public class Student
            {
                    public string Name {get;set;}
                    public int Id { get; set;}
            }

            public class Report
            {
                       int MyClass;
                       int MyStudent;
            }

            // Get a collection of school classes, and report.
            BindList<SchoolClass> classes = GetClasses();
            Report report = GetReport();

            // Create a binding source to bind to binding list.
            BindingSource bsClasses = new BindingSource();
            bsClasses.DataSource = classes;

          // Set up the binding for my two combo boxes.
            cbClass.DataBindings.Add("SelectedIndex", report , "MyClass", true, DataSourceUpdateMode.OnPropertyChanged, -1);
            cbClass.DisplayMember = "ClassName";
            cbClass.ValueMember = "Id";
            cbClass.DataSource = bsClasses;

            cbStudent.DataBindings.Add("SelectedIndex", report , "MyStudent", true, DataSourceUpdateMode.OnPropertyChanged, -1);
            cbStudent.DisplayMember = "Students.Name";
            cbStudent.ValueMember = "Students.Id";
            cbStudent.DataSource = bsClasses;

Open in new window


The advantage behind was when user selects a school class in cbClass, then cbStudent will automatically be populated by all students of the selected school class.

My trouble is when 'report' is later updated, change in 'cbClass' will automatically reset the 'SelectedIndex' in cbStudent to zero . But what I want is the 'SelectedIndex' in cbStudent to point to the 'MyStudent' in 'report'.

Could someone point to me what I had done wrong. Thanks.
0
Comment
Question by:dominicwong
  • 3
5 Comments
 
LVL 40

Accepted Solution

by:
Kyle Abrahams earned 250 total points
ID: 39836641
I would add a selectedIndexChanged eventHandler to do that:

protected void cbClass_selectedIndexChanged(object sender, eventargs e)
{
    cbStudent.SelectedValue = report.MyStudent.ToString();
}
0
 
LVL 13

Assisted Solution

by:Ashok
Ashok earned 250 total points
ID: 39837205
Try this.....

cbStudent.SelectedValue = ((Report)(bsClasses).CurrentItem).MyStudent;
0
 

Author Comment

by:dominicwong
ID: 39837500
Thanks Kyle and Ashok.

I'd tried as Kyle suggested.
While "report.MyStudent.ToString()" contains a valid value, setting " cbStudent.SelectedValue" didn't take any effect at all. The value of "cbStudent.SelectedValue " immediately after the setting still has value of "null". Don't know why??

Event handler "cbStudent_SelectedValueChanged" was called immediately after "cbClass_SelectedValueChanged". Inside the event handler "cbStudent_SelectedValueChanged", "cbStudent.SelectedValue" somehow (don't know how) has the value of the first element in the list (which is wrong).

I'd tried as Ashok suggested.
"bsClasses" has DataSource set to "BindList<SchoolClass>". Its 'CurrentItem' is of type 'SchoolClass', and can't be casted to type 'Report'. It threw an exception.

Anyway, I think the end result will still be the same. Somehow,  "cbStudent.SelectedValue" doesn't take any setting inside the event handlers "cbClass_selectedIndexChanged" or "cbClass_selectedValueChanged".
0
 

Author Comment

by:dominicwong
ID: 39837582
I managed to resolve the issue by setting the "cbClass.SelectedValue" and "cbStudent.SelectedValue" with the values from "report" on another method. As a result, when the form is brought up, the two combo boxes were already synchronized with binding source, and cbStudent will not be reset due to change in cbClass.

Thanks for your help.
0
 

Author Closing Comment

by:dominicwong
ID: 39837584
Thanks again.
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question