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
}
