I have Master-Detail datagrid in my application created using Linq to Entities. I would like to display the selected row's deatils of the Master datagrid on the details datagrid.
datagrid
Linq to Entities
what I have tried
private void Page_Loaded(object sender, RoutedEventArgs e) { this.db = new DB_ProdEntities(); var serverQuery = from a in this.hmdb.Servers orderby a.ServerID select a; dgServer.ItemsSource = null; dgServer.ItemsSource = serverQuery; }
private void dgServer_SelectionChanged(object sender, SelectionChangedEventArgs e) { string serverID = (dgServer.SelectedItem as Server).Name; var componentQuery = from a in db.Components where a.ServerID == serverID orderby a.Name select a; dgComponent.ItemsSource = null; dgComponent.ItemsSource = componentQuery; }
OUTPUT:
when I select the first row everything is normal, but when I select the second row it displays the details along with the selection of the first row's details like this
Output 1