public void ExportCategories() { SqlCompactConnection conn = new SqlCompactConnection(); try { StripStatus.Text = "Products Sub Categories.."; ProductSubcategory sub = new ProductSubcategory(); ProductCategory cat = new ProductCategory(); conn.DropProdctSubCategoryTable(); conn.CreateProdctSubCategoryTable(); ProductSubcategoryCollection subCol = sub.GetAllProductSubcategoryCollection(); conn.SynchForm = this; conn.AddProductSubCategory(subCol); StripStatus.Text = "Products Categories.."; conn.DropProdctCategoryTable(); conn.CreateProdctCategoryTable(); ProductCategoryCollection catCol = cat.GetAllProductCategoryCollection(); conn.AddProductCategory(catCol); sub = null; cat = null; subCol = null; catCol = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.CloseDatabase(); conn = null; } }