Solved

Combo-box crashing Win-forms C# app

Posted on 2010-11-09
6
365 Views
Last Modified: 2013-12-17
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

0
Comment
Question by:Adapt2NL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 7

Accepted Solution

by:
rogerard earned 500 total points
ID: 34097264
in the form's onclose event, try setting the combobox datasource to no nothing
0
 

Author Comment

by:Adapt2NL
ID: 34097316
Do you have any idea why the SelectedIndexChanged keeps reoccurring?
0
 
LVL 7

Expert Comment

by:rogerard
ID: 34097342
Sorry, no.
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Author Comment

by:Adapt2NL
ID: 34101489
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
 
LVL 7

Assisted Solution

by:rogerard
rogerard earned 500 total points
ID: 34101539
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
 
LVL 7

Assisted Solution

by:rogerard
rogerard earned 500 total points
ID: 34102265
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

726 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