C#

Admin_Table
 --> ID 
 --> Admins (Ex. John Doe, Jane Doe, John Smith)
 --> Available (Ex. True, False)
 --> Area --> (Ex. System Administrator, Telecommunications)

User_Submit
 --> ID
 --> Users_Name (Ex. John Doe, Jane Doe, John Smith)
 --> Email
 --> Started (Date Time)
 --> Problem (varchar(MAX))
 --> Assigned (Ex. John Doe, Jane Doe, John Smith)
 --> Type (Ex. System Administrator, Telecommunications)
 --> Viewed (Ex. True, False)

SELECT [Admin_Table].ID, HowMany=COUNT(User_Submit.ID) FROM [Admin_Table] LEFT OUTER JOIN
[User_Submit] ON [Admin_Table.ID] = [User_Submit.Assigned] GROUP BY [Admin_Table.ID] ORDER
BY COUNT(User_Submit.ID)

PIEBALDconsult wrote:

WHERE [Admin_Table.Available]=1

Luc Pattyn [Forum Guidelines] [My Articles]

---

Voting for dummies? No thanks.

---

John Simmons / outlaw programmer wrote:

encryptWorker.WorkerReportsProgress = true;
encryptWorker = new BackgroundWorker();

Mark Salsbery
Microsoft MVP - Visual C++

Mark Salsbery wrote:

Does your encryptWorker_RunWorkerCompleted ever get executed?

Mark Salsbery wrote:

Did you mean to do that in that order?

John Simmons / outlaw programmer wrote:

Yes. It gets called and the code inside it executes.

John Simmons / outlaw programmer wrote:

The progressChanged method never gets called though.

Mark Salsbery
Microsoft MVP - Visual C++

Mark Salsbery wrote:

and AsyncCompletedEventArgs.Error == null there?

Mark Salsbery wrote:

Is it a debugger issue? I can't reproduce it here.

John Simmons / outlaw programmer wrote:

If I try to run it under the debugger, all hell breaks loose.

		// in some class

		private System.ComponentModel.BackgroundWorker backgroundWorker1;

		private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
		{
			for (int i = 0; i < 5; i++)
			{
				Thread.Sleep(1000);
				this.backgroundWorker1.ReportProgress(i * 20);
			}
			e.Result = string.Format("****       Result String!");
			this.backgroundWorker1.ReportProgress(100);
			System.Diagnostics.Trace.WriteLine("****   End of DoWork");
		}

		private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
		{
			System.Diagnostics.Trace.WriteLine("****   RunWorkerCompleted");

			if (e.Error != null)
			{
				System.Diagnostics.Trace.WriteLine(e.Error.Message);
			}
			else if (e.Cancelled)
			{
				System.Diagnostics.Trace.WriteLine("Canceled");
			}
			else
			{
				System.Diagnostics.Trace.WriteLine(e.Result.ToString());
			}
		}

		private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
		{
			System.Diagnostics.Trace.WriteLine(string.Format("****       ProgressChanged {0}%", e.ProgressPercentage));
		}

...

this.backgroundWorker1 = new System.ComponentModel.BackgroundWorker();
this.backgroundWorker1.WorkerReportsProgress = true;
this.backgroundWorker1.WorkerSupportsCancellation = false;
this.backgroundWorker1.DoWork += new DoWorkEventHandler(backgroundWorker1_DoWork);
this.backgroundWorker1.RunWorkerCompleted += new RunWorkerCompletedEventHandler(backgroundWorker1_RunWorkerCompleted);
this.backgroundWorker1.ProgressChanged += new ProgressChangedEventHandler(backgroundWorker1_ProgressChanged);
this.backgroundWorker1.RunWorkerAsync();

Mark Salsbery
Microsoft MVP - Visual C++