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