private void RefreshContacts() { if (dbcontext != null) { dbcontext.Dispose(); } dbcontext = new AddressExample.AddressBookEntities(); dbcontext.Addresses .OrderBy(entry => entry.LastName) .ThenBy(entry => entry.FirstName) .Load(); addressBindingSource.DataSource = dbcontext.Addresses.Local; addressBindingSource.MoveFirst(); findTextBox.Clear(); }
// fill our addressBindingSource with all rows, ordered by name private void RefreshContacts() { // Dispose old DbContext, if any if (dbcontext != null) { dbcontext.Dispose(); } // create new DbContext so we can reorder records based on edits dbcontext = new AddressExample.AddressBookEntities(); // use LINQ to order the Addresses table contents // by last name, then first name dbcontext.Addresses .OrderBy(entry => entry.LastName) .ThenBy(entry => entry.FirstName) .Load(); // specify DataSource for addressBindingSource addressBindingSource.DataSource = dbcontext.Addresses.Local; addressBindingSource.MoveFirst(); // go to first result findTextBox.Clear(); // clear the Find TextBox }