//for load data in "new SabDiv" mode private void PreviosDataLoad() { DivRecords.Clear(); using (DBConteiner db = new DBConteiner()) { try { var list = db.SubDivisions.ToList <SubDivision>(); foreach (var item in list) { DivRecords.Add( new SubDivision { SubDivisionId = item.SubDivisionId, SubDivName = item.SubDivName, ParentIdent = item.ParentIdent, CollapsDate = item.CollapsDate, CreateDate = item.CreateDate }); } } catch (ArgumentNullException ex) { MessageBox.Show(ex.Message); } catch (OverflowException ex) { MessageBox.Show(ex.Message); } catch (System.Data.SqlClient.SqlException ex) { MessageBox.Show(ex.Message); } catch (System.Data.Entity.Core.EntityCommandExecutionException ex) { MessageBox.Show(ex.Message); } catch (System.Data.Entity.Core.EntityException ex) { MessageBox.Show(ex.Message); } } }