C#

//In this example, I create the connection and close for each interval of the loop
            while (!stopEvent.WaitOne(0, false))
            {
                using (SqlConnection dbConnection = new SqlConnection(connectionString))
                {
                    dbConnection.Open();

                    using (SqlCommand dbCommand = new SqlCommand("SELECT * FROM [TableName]", dbConnection))
                    {
                        using (SqlDataReader dbReader = dbCommand.ExecuteReader())
                        {
                            if (dbReader.Read())
                            {
                                //There is a record, process it and delete it.
                            }
                        }
                    }
                }

                System.Threading.Thread.Sleep(100);
            }

            //In this example, I create one connection until the loop completes then I close it.
            using (SqlConnection dbConnection = new SqlConnection(connectionString))
            {
                dbConnection.Open();

                while (!stopEvent.WaitOne(0, false))
                {
                    using (SqlCommand dbCommand = new SqlCommand("SELECT * FROM [TableName]", dbConnection))
                    {
                        using (SqlDataReader dbReader = dbCommand.ExecuteReader())
                        {
                            if (dbReader.Read())
                            {
                                //There is a record, process it and delete it.
                            }
                        }
                    }
                }

                System.Threading.Thread.Sleep(100);
            }

<pre>private List<Bitmap> BMPList = new List<Bitmap>();
        private Bitmap stitchImage = null;
        private Graphics stitchGraphics = null;
        private void InitializeStitch()
        {
            //This is where i get an paramater not valid errror, especially if I have already created this bitmap once or twice.
            stitchImage = new Bitmap(100000, BMPList[0].Height, System.Drawing.Imaging.PixelFormat.Format24bppRgb);
            stitchGraphics = Graphics.FromImage(stitchImage);
        }

        private void UninitializeStitch()
        {
            if (stitchGraphics != null)
                stitchGraphics.Dispose();

            if (stitchImage != null)
                stitchImage.Dispose();
        }

        private void CreateStitch()
        {
            if (BMPList.Count > 0)
            {
                //Create the blank bitmap and the coresponding graphics object.
                InitializeStitch();

                //Add the slices, the list is used to simulate a camera's new frame event.  Where I don't know the end point, which is why i need such a large blank bitmap.
                for (int i = 0; i < BMPList.Count; i++)
                    stitchGraphics.DrawImage(BMPList[i], i * BMPList[i].Width, 0);

                //Crop and save
                using (Bitmap tempBMP = (Bitmap)StitchImage.stitchBMP.Clone(new Rectangle(0, 0, BMPList[0].Width, BMPList[0].Width.Height), StitchImage.stitchBMP.PixelFormat))
                {
                    tempBMP.Save(@"C:\MyTestImage.jpg", System.Drawing.Imaging.ImageFormat.Jpeg);
                }

                //Free everything up.
                Uninitialize();
            }
        }

private void EnsureDefaultFileExists()
{
    var outputFile = Path.Combine(FileSystemLocations.GetTempFilesDirectory(), "fc6sound.wav");

    if (!File.Exists(outputFile))
    {
        var targetAssembly = Assembly.GetExecutingAssembly();
        var resourceName = "fc6sound.wav";

        using (Stream stream = targetAssembly.GetManifestResourceStream(targetAssembly.GetName().Name + "." + resourceName))
        {
            if (stream == null)
            {
                throw new Exception("Cannot find embedded resource '" + resourceName + "'");
            }

            byte[] buffer = new byte[stream.Length];

            stream.Read(buffer, 0, buffer.Length);

            using (BinaryWriter sw = new BinaryWriter(File.Open(outputFile, FileMode.Create)))
            {
                sw.Write(buffer);

            }
        }
    }
}