Master / Detail with a strongly typed dataset

Paul — Fri, 16 Jan 2009 15:18:54 GMT

I'm trying to create a master / detail grid with a strongy typed dataset. The dataset contains two tables and the relationship between them. The xaml for the grid is.......

<xcdg:DataGridControl Grid.Row="1" AutoCreateColumns="False" Name="dgAdverts" ReadOnly="True" SelectionMode="Single" EditTriggers="None" NavigationBehavior="RowOnly" Margin="0,0,0,5" AutoCreateDetailConfigurations="False" AllowDetailToggle="True">

<xcdg:DataGridControl.Resources>

</Style>

</xcdg:DataGridControl.Resources>

<xcdg:DataGridControl.View>

<xcdg:TableView UseDefaultHeadersFooters="False" ShowFixedColumnSplitter="False" ColumnStretchMode="All">

<xcdg:TableView.FixedHeaders>

<xcdg:ColumnManagerRow AllowAutoFilter="False" AllowSort="True" />

</DataTemplate>

</xcdg:TableView.FixedHeaders>

<xcdg:TableView.Theme>

<xcdg:Office2007BlackTheme />

</xcdg:TableView.Theme>

</xcdg:TableView>

</xcdg:DataGridControl.View>

<xcdg:DataGridControl.Columns>

<xcdg:Column FieldName="[BoardName]" Title="Job Board" IsMainColumn="True" />

<xcdg:Column FieldName="[NumAdverts]" Title="Adverts" />

</xcdg:DataGridControl.Columns>

<xcdg:DataGridControl.DetailConfigurations>

<xcdg:DetailConfiguration RelationName="JobBoards_Adverts">

<xcdg:DetailConfiguration.Columns>

<xcdg:Column FieldName="AdvertStatus" Title="Advert Status" />

<xcdg:Column FieldName="VacancyReference" Title="Vacancy Reference" />

<xcdg:Column FieldName="StartDate" Title="Post Date" />

<xcdg:Column FieldName="EndDate" Title="Expiry Date" />

</xcdg:DetailConfiguration.Columns>

</xcdg:DetailConfiguration>

</xcdg:DataGridControl.DetailConfigurations>

</xcdg:DataGridControl>

I populate the grid with the following code

public void LoadAdvertsGrid()

{

using (AdvertServices aServ = new AdvertServices())

{

_Ads = aServ.LoadAdvertsForVacancy(_CurrentVacancyID);

DataGridCollectionView ColView = new DataGridCollectionView(_Ads.Tables);

dgAdverts.ItemsSource = ColView;

}

For a dataset with two tables with one row in each with a relationship between the two my grid display one master row correctly plus one master row that is completely blank even though there is only one master record in the data. When I expand the master rows they both show the correct column headers but no data at all. I'd be grateful for any ideas that could help me out with this problem.

Thanks

Paul

Re: Master/Detail Grid

Jenny [Xceed] — Tue, 29 Apr 2008 15:12:02 GMT

Master/detail is supported through the DataGridCollectionView[Source]. In the example you provide, you initially bind the grid to the DataGridCollectionViewSource that has the Assignments as a source; however, in the Loaded event, you then reassign Assignment's DefaultView to the grid's ItemsSource property, removing the master/detail capabilities.

If you want to use code-behind to set the ItemsSource, then you should wrap your source in a DataGridCollectionView before assigning it to the ItemsSource property:

DataGridCollectionView view = new DataGridCollectionView( dal.timeSheetDataSet.Assignments.DefaultView );
this.AssignmentsGrid.ItemsSource = view;

Search results matching tags 'DataGridCollectionView' and 'Master Detail'

Master / Detail with a strongly typed dataset

Re: Master/Detail Grid