Combo-box crashing Win-forms C# app

Application data source is an Entity Framework. The Combo-box is bound to the data using a bindingSource control and when I attempt to exit the application the combo-box goes blank and the application hangs. It doesnt close and no further mouse clicks are accepted.

Interestingly I see that the SelectedIndexChanged event happens multiple times when I move between records using the navigator even when I dont change the combo box and it seems as if something happens to the combo box as I attempt to close the app using the red top right hand x.

There is no other code other than what you see attached and what is generated by VS2010.
namespace Sales
{
    public partial class frmMain : Form
    {
        public frmMain()
        {
            InitializeComponent();
        }

        private void frmMain_Load(object sender, EventArgs e)
        {
            GetCustomers();
        }

        private void GetCustomers()
        {
            var myData = new IIAAModel.IIAAEntities();
            var customerQuery = from c in myData.tblCustomers
                                select c;

            tblCustomerBindingSource.DataSource = customerQuery.ToList();
            
        }
        
        /*private void GetOneCustomer(int CustomerID) 
        {
            var myData = new IIAAModel.IIAAEntities();
            var customerQuery = from c in myData.tblCustomers
                                where c.lngCustomerID == CustomerID
                                select c;
                               
            tblCustomerBindingSource.DataSource=customerQuery.ToList();


        }*/
        private void cboAccountNumber_SelectedIndexChanged(object sender, EventArgs e)
        {
            //GetOneCustomer(cboAccountNumber.SelectedIndex);

            try
            {
                MessageBox.Show("cbo Changed");
            }
            catch (Exception ex)
            {
                
                MessageBox.Show(ex.Message);
            }
        }

    }
}

Open in new window

Adapt2NLAsked:
Who is Participating?
 
rogerardConnect With a Mentor Commented:
in the form's onclose event, try setting the combobox datasource to no nothing
0
 
Adapt2NLAuthor Commented:
Do you have any idea why the SelectedIndexChanged keeps reoccurring?
0
 
rogerardCommented:
Sorry, no.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Adapt2NLAuthor Commented:
It works well on the close form event. However, the proble also occurs when moving from record to record using the navigation control.

What is the root cause of the issue? Is there a standard way of using combo boxes to move to records that match the ID in the combo box, in C# and Visual Studio 2010?
0
 
rogerardConnect With a Mentor Commented:
You should not link the combobox directly to the dataset, but rather fill it with the results of a query on a dataset so that it is a static copy that doesn't get impacted by any changes, unless you want them to happen - manually, to the underlying dataset.
0
 
rogerardConnect With a Mentor Commented:
An alternative would be to assign the dataset as the datasource of a bindingsource which is the datasource for the datagridview.  Then on the comboboxes Onselectionchanged event, set the bindsource filter to the criteria of the combobox selection.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.