Databases
StackOverflow2013
Postsdbo
POBackgroundworker is always busy
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POBackgroundworker is always busy
    primarykey
    data
    text
    <p>I'm new to using event handlers and backgroundworkers, so I may be missing something completely obvious here. Still, I've been trying to fix this for two days, so I thought I might as well see what anyone had to say.</p> <p>I have a backgroundworker called SqlExpressDownloader. It starts running at the beginning of my program, the rest of the work runs, and then it should wait for the operations in the <code>SqlExpressDownloader_DoWork()</code> method to complete before continuing. The only problem is that for some reason whenever I do <code>while(SqlExpressDownloader.IsBusy)</code>, it always responds as busy and therefore will wait forever. </p> <p>The code for the event handler is here:</p> <pre><code> private void SqlExpressDownloader_DoWork(object sender, DoWorkEventArgs e) { string sSource = string.Format("{0}\\{1}", Paths.Settings_Common, "sqlexpr_x64_enu.exe"); Debug.WriteLine(sSource); Debug.WriteLine("http://www.elexioamp.com/Install/redistributables/sql2008r2express/sqlexpr_x64_enu.exe"); if (!System.IO.File.Exists(sSource)) { WebClient oWebClient = new WebClient(); oWebClient.DownloadProgressChanged += DownloadProgressChanged; oWebClient.DownloadDataCompleted += DownloadComplete; oWebClient.DownloadFileAsync(new System.Uri("http://www.elexioamp.com/Install/redistributables/sql2008r2express/sqlexpr_x64_enu.exe"), sSource); while (oWebClient.IsBusy) { Thread.Sleep(100); } e.Result = ""; DownloadFinished = true; } } </code></pre> <p>I have watched the code and have watched it complete this method. I even added a <code>return</code> after the <code>DownloadFinished = true</code>, but it still responds as busy. What I want to know is how to make the backgroundworker respond as not busy. </p> <p>EDIT The events are all added in the constructor as shown here:</p> <pre><code> SqlExpressDownloader = new BackgroundWorker(); SqlExpressDownloader.DoWork += new DoWorkEventHandler(this.SqlExpressDownloader_DoWork); SqlExpressDownloader.RunWorkerCompleted += new RunWorkerCompletedEventHandler(this.SqlExpressDownloader_RunWorkerCompleted); </code></pre> <p>The <code>RunWorkerCompleteEventHandler</code> looks like this:</p> <pre><code> private void SqlExpressDownloader_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { if (e.Error != null) { Debug.WriteLine("The actions are complete."); } else { Debug.WriteLine("Error in completed work."); } } </code></pre> <p>But, when I debugged it last, it didn't actually trigger.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USijb109
    1. USijb109
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POBackgroundworker is always busy
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POBackgroundworker is always busy
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHow are you starting the worker?
      singulars
      1. POBackgroundworker is always busy
      1. USPatrick
    2. COIn the main method, I'm starting it with `SqlExpressDownloader.RunWorkerAsync()`.
      singulars
      1. POBackgroundworker is always busy
      1. USijb109
    3. COAre you using a while loop similar to the one in the body of the method when checking the IsBusy of the worker? Does the RunWorkerCompleted event trigger when the method is complete?
      singulars
      1. POBackgroundworker is always busy
      1. USPatrick
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload