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.
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
http://postimg.org/image/9x1f616n7/Output 2
http://s16.postimg.org/4nylei9ph/op2.png
how to overcome this problem?