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); }