/// <summary>
        /// gets the inventory data from the database.
        /// I am also creating a dictionary to refer back to. I use this in the Add/Update click event.
        /// This prevents additional reads to the database to retrieve the ItemCode.
        /// </summary>
        public void populateInvoices()
        {
            try
            {
                //get data from database and load into datagrid1
                //Method should be ran in initialize method

                //get query needed find invoice
                String sQuery = mydb.populateAllInvoices();

                //datatable used to get table data.
                dt = db.FillSqlDataTable(sQuery);

                //fill the datagrid
                invoiceGrid1.ItemsSource = dt.DefaultView;
            }
            catch { }
        }//end populateInventory()