This is a migrated thread and some comments may be shown as answers.

Multiple child tables in hierachical radgridview

18 Answers 851 Views

GridView

This is a migrated thread and some comments may be shown as answers.

18 Answers, 1 is accepted

answered on 17 Apr 2009, 11:53 AM

multiplechilddataintabcontrol.zip

Hi branko,

You can customize a little the style of the ChildDataControlsPresenter control as shown in the attached example.

Sincerely yours,
Nedyalko Nikolov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

Accepted

answered on 23 Apr 2009, 07:24 AM

multiplechilddataintabcontrol.zip

Hi branko,

I'm attaching a modified version of the example that you already have. I replaced the GridViewDataControl in the ChildDataControlPresenter template with the RadGridView object, because there were some problems with the GridViewDataControl within the TabContol. We are doing our best to fix them. Until then I think this workaround will be helpful.

Greetings,
Nedyalko Nikolov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 23 Apr 2009, 11:23 AM

Thanks.

Your sample solves the problem.

I actually need something a little bit different, which I managed to chew through by studying that sample: details in one tab, and related tables in other two, which can also be done by specifying custom style for ChildDataControlsPresenter and manual binding. Not the most elegant solution, but it works:

                                <Style TargetType="telerik:ChildDataControlsPresenter">         
                            <Setter Property="Template">         
                                <Setter.Value>         
                                    <ControlTemplate TargetType="telerik:ChildDataControlsPresenter">         
                                        <TabControl>         
                                            <TabItem Header="Details">         
                                                <StackPanel DataContext="{Binding MasterRecord.Data}">         
                                                    <Label Content="{Binding Name}" />         
                                                    <Label Content="{Binding Age}" />         
                                                    <Label Content="..." />         
                                                </StackPanel>         
                                            </TabItem>         
                                            <TabItem Header="Orders">         
                                                <telerik:RadGridView ItemsSource="{Binding MasterRecord.Data.Orders}" />         
                                            </TabItem>         
                                            <TabItem Header="Cancelled Orders">         
                                                <telerik:RadGridView ItemsSource="{Binding MasterRecord.Data.CancelledOrders}" />         
                                            </TabItem>         
                                        </TabControl>         
                                    </ControlTemplate>         
                                </Setter.Value>         
                            </Setter>         
                        </Style>         
                     
                     
                     

answered on 23 Apr 2009, 11:32 PM

And now to next problem... :)

Using approach described in previous post I can't manually define grid's columns. If I use AutoGenerateColumns="False", i always get autogenerated columns + additional manually defined ones. I guess it's a bug?

Example (only part of above style):

                                                    <TabItem Header="Orders">         
                                                <telerik:RadGridView          
                                                    ItemsSource="{Binding MasterRecord.Data.Orders}"          
                                                    AutoGenerateColumns="False">         
                                                    <telerik:RadGridView.Columns>         
                                                        <telerik:GridViewDataColumn HeaderText="id" DataMemberPath="ID" />         
                                                    </telerik:RadGridView.Columns>         
                                                </telerik:RadGridView>         
                                            </TabItem>         
                     
                     

The grid gets ID, description and one more id.

answered on 28 Apr 2009, 08:36 AM

multiplechilddataintabcontrol.zip

Hi branko,

You can add GridViewDataColumns in xaml file, in the attached example you can see how to do that. Code in xaml is actually commented but works fine. There is a single restriction about this method, the "issue" is that all child grids will have the same columns (if that not troubles you this is the preferred way).

If you want child grids to have different columns you can use Loaded and DataContextChange events. At Loaded you can initialize columns and DataContextChange is fired when Tab item is changed.

Hope this will help. Let me know about the result.

Greetings,
Nedyalko Nikolov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 04 May 2009, 07:43 PM

I had no problem defining grid columns in XAML.

Now, thanks to your example, I also know how to modify child grids programmatically on opening. It is perhaps one way to solve my problem, but I'd like to avoid it, if it's possible.

What bothers me, is... well, first excerpt from my form source. Data source is LINQ to SQL...

                    <Grid>         
                <Grid.Resources>         
                    <Style TargetType="telerik:ChildDataControlsPresenter">         
                        <Setter Property="Template">         
                            <Setter.Value>         
                                <ControlTemplate TargetType="telerik:ChildDataControlsPresenter">         
                                    <TabControl>         
                                        <TabItem Header="Details">         
                                            <my:UserControlPatientDetails DataContext="{Binding MasterRecord.Data}" />         
                                        </TabItem>         
                                        <TabItem Header="Contacts">         
                                            <telerik:RadGridView ItemsSource="{Binding MasterRecord.Data.Addresses}"          
                                                                 IsFilteringAllowed="False"          
                                                                 ColumnsWidthMode="Fill"          
                                                                 ShowGroupPanel="False"         
                                                                 AutoGenerateColumns="False">         
                                                <telerik:RadGridView.Columns>         
                                                    <telerik:GridViewDataColumn HeaderText="street (only column)" DataMemberPath="StreetLine_1" />         
                                                </telerik:RadGridView.Columns>         
                                            </telerik:RadGridView>         
                                        </TabItem>         
                                    </TabControl>         
                                </ControlTemplate>         
                            </Setter.Value>         
                        </Setter>         
                    </Style>         
                </Grid.Resources>         
                     
                <telerik:RadGridView Name="gridPatients" AutoGenerateColumns="False" AutoGenerateHierarchyFromDataSet="False">         
                    <telerik:RadGridView.Columns>         
                        <telerik:GridViewDataColumn HeaderText="pat.no." DataMemberPath="PAT_ID" IsReadOnly="True" />         
                        <telerik:GridViewDataColumn HeaderText="sirname" DataMemberPath="Sirname" />         
                        <telerik:GridViewDataColumn HeaderText="SSN" DataMemberPath="SocialSecNo" />         
                    </telerik:RadGridView.Columns>         
                </telerik:RadGridView>         
            </Grid>         
                     
                     

ChildDataControlsPresenter is restyled to show up as tabcontrol, one tab showing master record details, other showing related table (patients' address). Patient's address child grid should only show one column (street) - since AutoGenerateColumns for that RadGridView is set to false.

But what actually happens is that grid shows all columns first (all public properties of Addresses class) and after that street (once more). I would like it to show only street.

Is there a way to acomplish this? Is there perhaps a better way (compared to above "hack") to make grid show a "plus sign" and then make it show custom subform?

Thanks again.

answered on 07 May 2009, 10:42 AM

multiplechilddataintabcontrol.zip

Hi branko,

The problem with the AutoGenerateColumns property on the child grid is a known issue for us.
Problem actually is connected with the DataContext which is set to the child RadGridView. I'm attaching a working example (modified version of the one you already have) how to work around this issue and you can choose between two hacks.

Unfortunately some other GridView logic stops us from fixing this issue immediately. We are doing our best in order to improve this code as soon as possible.

About the "plus" sign and details preview this is in our TODO list for the 2009_Q2 release.

Sorry for the inconvenience caused.

All the best,
Nedyalko Nikolov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 28 Jul 2009, 10:37 AM

Hi Nedyalko,

I have about 10 gridview in my project and each one maybe has one or more child table definition. I want to use your approach to show each child in a tab control, but because of binding gridview(in ContentTemlate of the TabItem) every properties in the sub collection appears as a column that i don't want this!
you attached a example code for doing this, but I think i can't do that in that way because I should know that the current child is from which parent gridview and is which of it's child table definitions. Also I don't want that the column's header and property name be same.
without tabItem I do that with defining columns for each child:

    
            GridViewDataColumn columnCI_NAME = new GridViewDataColumn();     
        
            columnCI_NAME.DataMemberBinding = new Binding("CI_NAME");     
        
            columnCI_NAME.HeaderText = "CI NAME";     
        
            detailDefinition.FieldDescriptors.Add(columnCI_NAME);

but in your approach I can't use that!
I will be thankful if I know your solution!

Regards ;)

answered on 30 Jul 2009, 08:18 AM

hierarchywithrowdetails.zip

Hi Meisam,

I think that "Row Details" feature of the RadGridView is what you need. This feature gives you possibility to set custom template for details view (which if you put in this template RadGridView it becomes a hierarchy example), and do not need to use Generic template for ChildDataControlsPresenter.

I'm attaching a sample project for Silverlight which you can use for reference how to meet your goals, because situation is identical for WPF.

Hope this helps.

Best wishes,
Nedyalko Nikolov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 03 Aug 2009, 03:53 PM

hierarchychildtemplatecustomization.zip

hierarchywithrowdetails.zip

Hello Meisam,

You can use LoadingRowDetails event to customize columns of the child grid.
I'm attaching a modified version of the example you already have.

Indeed "Row Details" feature was introduced with 2009.Q2 release, so I'm attaching an example with regular property hierarchy.

Hope this helps.

Kind regards,
Nedyalko Nikolov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 14 Dec 2009, 04:16 PM

Hello Telerik Team,

I managed to make RadGridView show multiple related tables (LINQ to SQL) by approach used in FirstLook sample (create GridViewTableDefinition and TableRelation). If I add two table definitions it works OK (besides showing empty table if no related record exists).

I'd like to know if there exists a way, to show each of related tables in separate tab of RadTabControl.

I have used your attached solution , but one problem that I have is that I can not see the tab header name.
I am uploading my project so may you can tell me what is the problem.

http://www.zshare.net/download/698869532cfb7498/

Thank you
Wael

answered on 21 Dec 2009, 02:09 PM

Hello Shanthi Gangatharan,

Can you provide me with more information about when are you call GridViewColumn.IsVisible = false? Generally this should work, so if it does not work it should be investigated, but I need some more info (a sample project which I can debug on my side will be great).

Hello Wael,

You are trying to bind to the "TableDefinition.Relation.Name" property which is not available for the TabItem.DataContext (in your example this data context is the selected Order). TableDefinition object is used internally to set the required data context. Please take a look at this code snippet based on your example:

<Grid Loaded="Grid_Loaded">

<Grid.Resources>

<Style TargetType="{x:Type TabItem}">

<Setter Property="Header" Value="{Binding}"/>

<Setter Property="BorderThickness" Value="1,1,0,1"/>

<Setter Property="ContentTemplate">

<Setter.Value>

<DataTemplate>

<telerik:RadGridView ItemsSource="{Binding Details}" />

</DataTemplate>

</Setter.Value>

</Setter>

</Style>

<Style TargetType="telerik:ChildDataControlsPresenter">

<Setter Property="Template">

<Setter.Value>

<ControlTemplate TargetType="telerik:ChildDataControlsPresenter">

<TabControl Name="PART_ChildDataItemsControl"

ItemsSource="{Binding}"/>

</ControlTemplate>

</Setter.Value>

</Setter>

</Style>

</Grid.Resources>

<telerik:RadGridView Name="radGridView1"

ScrollMode="Deferred"

ClipToBounds="True"

FlowDirection="LeftToRight"

MultipleSelect="True"

telerik:StyleManager.Theme="Office_Black"

Margin="0,0,0,12" />

</Grid>

Best wishes,
Nedyalko Nikolov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Multiple child tables in hierachical radgridview

18 Answers, 1 is accepted