public bool updateProduct(int ProductId, string BrandName, string ProductName, double SRP, double GrossWeight, double NetWeight, double ShelfWidth, double ShelfHeight, double ShelfDepth)
        {
            try
            {
                int rowCount;
                SmartMartProductsDataSetTableAdapters.UpdateProductTableAdapter UpdateAdapter = new SmartMartProductsDataSetTableAdapters.UpdateProductTableAdapter();
                rowCount = UpdateAdapter.Fill(ProductId, BrandName, ProductName, SRP, GrossWeight, NetWeight, ShelfWidth, ShelfHeight, ShelfDepth, LastUpdated);
                if (rowCount == 0) return false;
                else return true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }