WinApp Form Loads Too Much Data During a Load Event

Question

I have a form that loads quite a lot of data from an SQL server. Below is the code that will give some good advice:

private void BranchCenter_Load(object sender, EventArgs e) {
  //Combo boxes:
  LoadCities();
  LoadCoordinators();
  LoadComputerSystems();

  //Actual entity
  LoadBranch();
}

private void LoadCities() {
  //LINQ2SQL to load data. ~5000 records.
}

private void LoadCoordinators() {
  //LINQ2SQL to load data. ~50 records.
}

private void LoadComputerSystems() {
  //LINQ2SQL to load data. ~550 records.
}

private void LoadBranch() {
  LoadBranchInit();
  LoadBranchDetails();
  LoadBranchTimings();
  LoadBranchServices();
  LoadBranchLocumsHistory();
  LoadBranchJobs();
  LoadBranchNotes();
}

private void LoadBranchInit() {
  //LINQ2SQL to load the Branch object based upon the Branch ID
}

private void LoadBranchDetails() {
  //LINQ2SQL to load basic branch stuff. 38 fields. Mixed editors.
}

private void LoadBranchTimings() {
  //LINQ2SQL to load timings info into 80 date-time controls
}

private void LoadBranchServices() {
  //LINQ2SQL to load services offered at branch info into 20 check-boxes controls
}

private void LoadBranchLocumsHistory() {
  //LINQ2SQL to load branch history info into grid control. Always increasing # of rows :(
}

private void LoadBranchJobs() {
  //LINQ2SQL to load branch jobs info into grid control. Always increasing # of rows :( 
}

private void LoadBranchNotes() {
  //LINQ2SQL to load branch notes info into grid control
}

The user interface is a form with tab controls. each part on top goes to the tab. I need to download and show the form to the user as quickly as possible. as soon as the form is shown, I need to run a series of background workers to get data for each page.

I tried to get confused with the background worker, but could not understand its use. I get the message that "another thread tried to access control on your main thread ... or something like that ..."

, , .

? .

Answer 1

BackgroundWorker . RunWorkerAsync() .

DoWork , , Result DoWorkEventArgs .

. DoWork , . Result.

RunWorkerCompleted , DoWork, Result RunWorkerCompletedEventArgs. , , .

Answer 2

, , . , , , , .

BackgroundWorker . . , , Visible = false, , ", , ...". , , . , - , , .

Answer 3

, .

.

, , , .

, , , , , .

Answer 4

, DoWork BackgroundWorker .

BackgroundWorker.ReportProgress( int progress, object state) GUI, .

, GUI, .

Answer 5

, ; . , , Invoke. .

Answer 6

, BackgroundWorker .

, , DoWork.

e.

RunWorkerCompleted e.Results .

Answer 7

TabControl .

UserControl.

Answer 8

, , , . , UI, Control.Invoke, .

Answer 9

. . . link-2-link, Reactive Extensions .NET(Rx). ? Rx .

Answer 10

, . Visual Studio 2010 Task.Factory.StartNew(() = > myMethod());

, :

private void LoadLocum() {
    var TaskInit = Task.Factory.StartNew(() => LoadLocumInit());
    TaskInit.Wait();

    var TaskDetails = Task.Factory.StartNew(() => LoadLocumDetails());
    TaskDetails.Wait();

    var TaskQualifications = Task.Factory.StartNew(() => LoadLocumQualifications());
    //Enable Qualification TabPage automatically whenever TaskQualifications is complete

    Parallel.Invoke(
        () => LoadLocumComputerSystems(), 
        () => LoadLocumOtherInfo(), 
        () => LoadLocumEmergencyContacts(), 
        () => LoadLocumDistanceRates(), 
        () => LoadLocumDocuments(), 
        () => LoadLocumNotes(), 
        () => LoadLocumBannedStatus()
    );

}

() . . . , .