C#

// Initialize the reset events to keep track of completed threads
               ManualResetEvent[] resetEvents = new ManualResetEvent[arrFileName.Count];

               // Launch each method in it's own thread
               for (int i = 0; i < arrFileName.Count; i++)
               {
                   resetEvents[i] = new ManualResetEvent(false);
                   ThreadPool.QueueUserWorkItem(new WaitCallback((object index) =>
                   {
                       int actionIndex = (int)index;

                       // Execute the method
                       ThreadExcecute(arrFileName[actionIndex]);

                       // Tell the calling thread that we're done
                       resetEvents[actionIndex].Set();
                   }), i);
               }

               // Wait for all threads to execute
               WaitHandle.WaitAll(resetEvents);

Users report to a manager
1. The process by clicking a button is finding who reports to me (manager)
2. So there is a stored procedure written to find the users reporting to the manager

My question is:
1. Is this the right way of doing this
2. Is there a need to develop a separate SQL view just for this report
3. What would be the best approach on doing this.

if (IsSingleInstance())
           {
               Application.EnableVisualStyles();
               Application.SetCompatibleTextRenderingDefault(false);
               Application.Run(new Form1(Args));
           }
           else
           {
               Process current = Process.GetCurrentProcess();
               foreach (Process process in Process.GetProcessesByName(current.ProcessName))
               {
                   if (process.Id != current.Id)
                   {
                       SetForegroundWindow(process.MainWindowHandle);
                       break;
                   }
               }
           }

[STAThread]
        static void Main(string[] Args)
        {

static bool IsSingleInstance()
    {
        try
        {
            // Try to open existing mutex.
            Mutex.OpenExisting(@"Global\Notepad");
        }
        catch
        {
            // If exception occurred, there is no such mutex.
            Program._m = new Mutex(true, "Notepad");

            // Only one instance.
            return true;
        }
        // More than one instance.
        return false;
    }
}