void PopulateArray(clsDataConnection DB)
        {
            Int32 Index       = 0;
            Int32 RecordCount = 0;

            RecordCount   = DB.Count;
            mSupplierList = new List <clsSupplier>();
            while (Index < RecordCount)
            {
                clsSupplier ASupplier = new clsSupplier();
                ASupplier.SupplierID   = Convert.ToInt32(DB.DataTable.Rows[Index]["SupplierID"]);
                ASupplier.CompanyName  = Convert.ToString(DB.DataTable.Rows[Index]["CompanyName"]);
                ASupplier.Product      = Convert.ToString(DB.DataTable.Rows[Index]["Product"]);
                ASupplier.PhoneNumber  = Convert.ToString(DB.DataTable.Rows[Index]["PhoneNumber"]);
                ASupplier.EmailAddress = Convert.ToString(DB.DataTable.Rows[Index]["EmailAddress"]);
                ASupplier.Address      = Convert.ToString(DB.DataTable.Rows[Index]["Address"]);
                ASupplier.PostCode     = Convert.ToString(DB.DataTable.Rows[Index]["PostCode"]);
                mSupplierList.Add(ASupplier);
                Index++;
            }
        }