private void UpdateCategoryItems()
        {
            //if category is being deleted or deactivated, unassign and deactivate all items belonging to the category
            BPArticles bpArticles = new BPArticles();
            BEArticles dsArticles = bpArticles.SelectByArticleCategoryID(ArticleCategoryID);

            foreach (BEArticles.tbl_ArticlesRow row in dsArticles.tbl_Articles)
            {
                row.ArticleCategoryID = 0;
                row.ArticleActive = false;
            }
            bpArticles.Update(dsArticles);
        }