public void ExportTerritories() { SqlCompactConnection conn = new SqlCompactConnection(); SalesTerritory ter = new SalesTerritory(); try { SalesTerritoryCollection colTerr = ter.GetAllSalesTerritoryCollection(); conn.SynchForm = this; conn.DropSalesTerritoryTable(); conn.CreateTerritoryTable(); conn.AddSalesTerritory(colTerr); ter = null; colTerr = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.CloseDatabase(); conn = null; } }