When I am showing the nested grid, if I press insert it trys to add a row to the parent grid. How can I add a row to the nested grid. I am guessing that the call to savechanges would flush this record to the correct entity table. Also how can you add icons to add/delete rows in the grid?
Thanks
p
13 Answers, 1 is accepted
Rank 2
When you press the toggle button in order to show the child nested table, the selected item is still the item from the parent grid. And unless you explicitly click on the child table, every try to insert new row will be considered as a part of the parent grid. Furthermore, as possible solution for inserting new row is to use the property of RadGridView - ShowInsertRow and set it to "true".
As for the second question, what exactly do you mean by add icons to add/delete rows in the grid? Where do you need to insert that icon? Do you want a special button?
Maya
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Rank 2
| <Grid x:Name="LayoutRoot" Background="#FFDADADA" HorizontalAlignment="Stretch" VerticalAlignment="Stretch"> |
| <Grid.Resources> |
| <DropShadowEffect x:Key="MainBorder_DropShadowEffect" ShadowDepth="0" BlurRadius="20" Opacity="0.7" /> |
| <Style x:Key="MainBorderStyle" TargetType="Border"> |
| <Setter Property="Effect" Value="{StaticResource MainBorder_DropShadowEffect}" /> |
| </Style> |
| <riacontrols:DomainDataSource x:Key="ddsRoles" Name="docRolesDomainDataSource" LoadSize="200" QueryName="GetDocRoles" AutoLoad="True" > |
| <riacontrols:DomainDataSource.DomainContext> |
| <ds:MDomainContext /> |
| </riacontrols:DomainDataSource.DomainContext> |
| </riacontrols:DomainDataSource> |
| </Grid.Resources> |
| <Grid.RowDefinitions> |
| <RowDefinition Height="30" /> |
| <RowDefinition Height="*" /> |
| <RowDefinition Height="Auto" /> |
| </Grid.RowDefinitions> |
| <riacontrols:DomainDataSource x:Name="MyData" LoadSize="200" QueryName="GetDocTypes" AutoLoad="True" Margin="4,20,-4,-20"> |
| <riacontrols:DomainDataSource.DomainContext> |
| <ds:MDomainContext /> |
| </riacontrols:DomainDataSource.DomainContext> |
| </riacontrols:DomainDataSource> |
| <Grid Grid.Row="1" HorizontalAlignment="Center" VerticalAlignment="Center" |
| Margin="50,0,50,0" > |
| <Grid VerticalAlignment="Top" Margin="8"> |
| <Grid.ColumnDefinitions> |
| <ColumnDefinition Width="*" /> |
| <ColumnDefinition Width="30" /> |
| <ColumnDefinition Width="Auto" /> |
| </Grid.ColumnDefinitions> |
| <StackPanel > |
| <!--<Border BorderBrush="White" BorderThickness="1" Background="#FFEDEDED" CornerRadius="8" Style="{StaticResource MainBorderStyle}" />--> |
| <controlsToolkit:BusyIndicator IsBusy="{Binding IsBusy, ElementName=MyData}"> |
| <telerik:RadGridView Name="radGridView1" Height="420" ItemsSource="{Binding Data, ElementName=MyData}" |
| AutoGenerateColumns="False" |
| Grid.Column="0" RowLoaded="radGridView1_RowLoaded"> |
| <telerik:RadGridView.ChildTableDefinitions> |
| <telerik:GridViewTableDefinition /> |
| </telerik:RadGridView.ChildTableDefinitions> |
| <telerik:RadGridView.Columns> |
| <telerik:GridViewDataColumn Header="Document Code" DataMemberBinding="{Binding shortcode }" Width="120" /> |
| <telerik:GridViewDataColumn Header="Document Description" DataMemberBinding="{Binding description }" Width="*" /> |
| </telerik:RadGridView.Columns> |
| <telerik:RadGridView.HierarchyChildTemplate> |
| <DataTemplate> |
| <telerik:RadGridView x:Name="radGridView1" CanUserFreezeColumns="False" AutoGenerateColumns="False" |
| ItemsSource="{Binding DOC_TYPES_ROLES}" ShowInsertRow="True" ShowGroupPanel="False" IsReadOnly="False"> |
| <telerik:RadGridView.Columns> |
| <telerik:GridViewDataColumn Header="*" DataMemberBinding="{Binding roleguid }" Width="100" /> |
| <telerik:GridViewComboBoxColumn Header="Permitted Role(s)" |
| ItemsSourceBinding="{Binding Data, Source={StaticResource ddsRoles}}" |
| DataMemberBinding="{Binding roleguid}" |
| DisplayMemberPath="roletext" |
| SelectedValueMemberPath="rowguid" Width="300" /> |
| </telerik:RadGridView.Columns> |
| </telerik:RadGridView> |
| </DataTemplate> |
| </telerik:RadGridView.HierarchyChildTemplate> |
| </telerik:RadGridView> |
| </controlsToolkit:BusyIndicator> |
| </StackPanel> |
| </Grid> |
| </Grid> |
| </Grid> |
The problem with inserting new rows in the child grid comes from the fact that the collection providing data for it is neither implementing IList, nor is EditableCollection. As a result elements cannot be inserted or deleted.
There are a couple of options. Firstly, you may implement IList interface in the definition of the data for your child grid. Another option is to use DetailTemplate that is far more flexible than the hierarchy and to insert the grid in it.
You can find more information and sample projects in this forum thread or this blog post.
I hope that helps.
Maya
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Rank 1
I have the following Model:
public class PackageItemModel // PJ_GRG_ArticPacchetto
{
[Key]
public int Id { get; set; }
public int ParentItemId { get; set; }
public string Layer { get; set; }
[Include]
[Editable(true)]
[Association("DetailsAssociation", "Id", "PackageItemId")]
public IQueryable<PackageDetailsModel> Details { get; set; }
[Include]
[Editable(true)]
public PackageCompositionModel Composition;
public string Code { get; set; }
public string Description { get; set; }
public bool MatchboardFlag { get; set; } //Matchboard = perlina. Matchboarding = perlinato
public bool PlankFlag { get; set; } // Tavola
public bool StripFlag { get; set; } // Morali
public bool KHWFlag { get; set; }
public bool FixingFlag { get; set; }
public bool InsulationFlag { get; set; }
public bool CoveringFlag { get; set; }
public bool FramesFlag { get; set; }
public bool OtherFlag { get; set; }
}
I have a Domain Service on the server that returns an IQueryable<PackageItemModel>.
The XAML code for the Master/Detail grids is the following:
..........
..........
..........
..........
..........
<riaControls:DomainDataSource x:Key="ddsPackagesKey" AutoLoad="True" QueryName="GetPackages">
<riaControls:DomainDataSource.DomainContext>
<my:PackageContext />
</riaControls:DomainDataSource.DomainContext>
<riaControls:DomainDataSource.QueryParameters>
<riaControls:Parameter ParameterName="ProjectItemId" Value="{Binding ProjectItemId}" />
</riaControls:DomainDataSource.QueryParameters>
</riaControls:DomainDataSource>
..........
..........
..........
..........
..........
<StackPanel>
<telerik:RadGridView Name="dgridPackageItems" VerticalAlignment="Top" ShowInsertRow="True" ShowGroupPanel="False"
ItemsSource="{Binding Path=Data, Source={StaticResource ddsPackagesKey}}"
AutoGenerateColumns="False" RowDetailsVisibilityMode="VisibleWhenSelected">
<telerik:RadGridView.Columns>
<telerik:GridViewDataColumn Header="Strato" DataMemberBinding="{Binding Path=Layer, Mode=OneWay}" IsReadOnly="True" />
<telerik:GridViewDataColumn Header="Codice" DataMemberBinding="{Binding Path=Code, Mode=TwoWay}"/>
<telerik:GridViewDataColumn Header="Descrizione" DataMemberBinding="{Binding Path=Description, Mode=TwoWay}"/>
</telerik:RadGridView.Columns>
<telerik:RadGridView.RowDetailsTemplate>
<DataTemplate>
<StackPanel>
<Grid HorizontalAlignment="Center" Margin="0, 0, 0, 5">
<Grid.ColumnDefinitions>
<ColumnDefinition Width="120" />
<ColumnDefinition Width="120" />
<ColumnDefinition Width="120" />
</Grid.ColumnDefinitions>
<Grid.RowDefinitions>
<RowDefinition />
<RowDefinition />
<RowDefinition />
<RowDefinition />
</Grid.RowDefinitions>
<CheckBox Grid.Row="0" Grid.Column="0" Name="checkMatchboard" Content="Perline" ></CheckBox>
<CheckBox Grid.Row="1" Name="checkPlank" Content="Tavole" ></CheckBox>
<CheckBox Grid.Row="2" Name="checkStrinp" Content="Morali" ></CheckBox>
<CheckBox Grid.Column="1" Grid.Row="0" Name="checkKHW" Content="KHW"></CheckBox>
<CheckBox Grid.Column="1" Grid.Row="1" Name="checkFixing" Content="Fissaggio"></CheckBox>
<CheckBox Grid.Column="1" Grid.Row="2" Name="checkInsulation" Content="Isolamento"></CheckBox>
<CheckBox Grid.Column="2" Name="checkCovering" Content="Copertura"></CheckBox>
<CheckBox Grid.Column="2" Grid.Row="1" Name="checkFrames" Content="Telai"></CheckBox>
<CheckBox Grid.Column="2" Grid.Row="2" Name="checkOther" Content="Altro"></CheckBox>
</Grid>
<telerik:RadGridView VerticalAlignment="Top" ShowInsertRow="True" ShowGroupPanel="False" AutoGenerateColumns="False"
ItemsSource="{Binding Path=Data.Details, Source={StaticResource ddsPackagesKey}}">
<telerik:RadGridView.Columns>
<telerik:GridViewDataColumn Header="Quantità " DataMemberBinding="{Binding Path=Quantity, Mode=TwoWay}"/>
<telerik:GridViewDataColumn Header="Costo totale" DataMemberBinding="{Binding Path=TotalPrice, Mode=TwoWay}"/>
<telerik:GridViewDataColumn Header="Specifiche tecniche" DataMemberBinding="{Binding Path=TechSpec, Mode=TwoWay}"/>
<telerik:GridViewDataColumn Header="Caratteristiche" DataMemberBinding="{Binding Path=Features, Mode=TwoWay}"/>
<telerik:GridViewDataColumn Header="Dettaglio dimensione" DataMemberBinding="{Binding Path=DimensionDetails, Mode=TwoWay}"/>
<telerik:GridViewDataColumn Header="Note" DataMemberBinding="{Binding Path=Notes, Mode=TwoWay}"/>
<telerik:GridViewDataColumn Header="Note lavorazione" DataMemberBinding="{Binding Path=WorkingNotes, Mode=TwoWay}"/>
<telerik:GridViewDataColumn Header="Responsabile" DataMemberBinding="{Binding Path=OperatorId, Mode=TwoWay}"/>
<telerik:GridViewDataColumn Header="S.D.O." DataMemberBinding="{Binding Path=MDSId, Mode=TwoWay}"/>
</telerik:RadGridView.Columns>
</telerik:RadGridView>
</StackPanel>
</DataTemplate>
</telerik:RadGridView.RowDetailsTemplate>
</telerik:RadGridView>
<!--<sdk:DataPager Source="{Binding Data, ElementName=ddsPackages}" PageSize="10" />-->
</StackPanel>
Both grids show data correctly, but the second grid (the child, in the row details area) does allow only updates; insert operations are not possibile because the Insert row would never show. If you click on the "new row" button simply nothing happens.
I can manage to delete and insert data by code behind so the problem is related to the GridView control.
I cannot find a way out.
Based on the sample project attached in the above-mentioned forum thread, I have prepared an updated application that demonstrates the implementation of insert/delete functionality in a hierarchical grid. Please, take a look at it for further reference.
On the other hand, I may recommend you to take advantage of the RadDomainDataSource control that is entirely compatible with the RadGridView.
Maya
the Telerik team
Rank 1
I couldn't test before so I tried today to build and run your test project, but it fails on my machine (Exception at Start up). I have no time for the moment to check why it doesn't work; it looks like it has problem in accessing the entity store (I have Visual Studio 2010 + SP1 and both SQL Express and SQL Server) but I haven't Northwind database installed on my machine and taking a rough look at the web.config I guess you are using that database, but maybe just looking at the source code I could manage to fix my issue. Let's hope that.
Bye
Indeed, the sample uses Northwind database. Generally, the idea in the sample application is to wrap your items in a collection enabling insertion and deletion - in this case - EntitySetCollectionView. This is relevant for both the parent and the child grids' sources. However, if you decide on using the RadDomainDataSource control, you may take advantage of it without the need of creating a different collection type.
Let me know how it goes.
Maya
the Telerik team
Rank 1
Hi Maya,
Unfortunately I'm losing lot of time to seeking documentation because unfortunately your help file on the RadDomainDataSource is rather poor (sorry for this bad appreciation). I have already found some major problems due to my superfiacil knowledge of your controls (I'm using them for a month or less).
The 2 big problems I'm facing right now are (also because I'm working on a demo project and I have not much time to test):
1) the crypting behaviour of the RadDomainFiltersDescriptors. I couldn't manage to use them as for the standard ones. At the moment I decided to use RadGridView filtering features and to abandon the idea to experiment them.
2) I have a RadGridView control bound to a RadDomainDataSource in a Silverlight 4.0 ChildWindow. After adding some new rows in the grid I hit the OK button on the window and the event handler tests HasChanges property of the RadDomainDataSource but it is always False in this particular situation, so it cannot submit any changes to the server...this is really strange because the standard DomaindataSource from Microsoft is behaving differently (HasChages is True in this case)
I couldn’t find any logical explanation to those 2 issues so far. Maybe you can help me to make things clear.
Thanks
There is a great sequence of blog posts related to the RadDomainDataSource that include sample projects as well:
1. Introducing RadDomainDataSource for Silverlight.
2. Loading data with RadDomainDataSource for Silverlight.
3. Creating CRUD application with RadDomainDataSource for Silverlight.
4. An MVVM approach to Telerik Domain Services for Silverlight.
As far as the first query is concerned, what is the exact result you want to get by using the FilterDescriptor-s of the RadDomainDataSource ? Is it no appropriate to use those of the grid ?
Considering the second question, this is probably due to the fact that you are binding the grid to the source, but still creating a new one in the code and adding the new items to the latest. However, in order to provide more accurate solution, it would be great if you could send us a sample project illustrating your settings and exact requirements.
Maya
the Telerik team
Rank 1
Hi Maya,
The situation is not so complicated. Unfortunately to send you a sample application I need time to prepare it, and right now I haven’t. I'll try to give you more details on my application.
1) I need to filter the grid (telerik RadGridView) based on the user input in a few TextBox controls on the header of my window. In this situation grid filters do not suit my purpose. To filter the DataView using the content of a TextBox with a standard DomainDataSource it is really straightforward. You just need 2 FilterDescriptor in the definition of the DomainDataSource...see the example below:
<riaControls:DomainDataSource Name="ddsMandatoryDataStates"
AutoLoad="True"
QueryName="GetMandDataStates"
PageSize="10"
Width="0" Height="0">
<riaControls:DomainDataSource.DomainContext>
<my:TablesContext />
</riaControls:DomainDataSource.DomainContext>
<riaControls:DomainDataSource.FilterDescriptors>
<riaControls:FilterDescriptor PropertyPath="Code" Operator="Contains" Value="{Binding ElementName=txtCode, Path=Text}" IgnoredValue=""/>
<riaControls:FilterDescriptor PropertyPath="Description" Operator="StartsWith" Value="{Binding ElementName=txtDescription, Path=Text}" IgnoredValue=""/>
</riaControls:DomainDataSource.FilterDescriptors>
</riaControls:DomainDataSource>
...........
...........
<TextBox Margin="4" Grid.Column="1" Grid.Row="1" Name="txtCode" HorizontalAlignment="Left" Width="100" VerticalAlignment="Center" />
<TextBox Margin="4" Grid.Column="1" Grid.Row="2" Name="txtDescription" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
This feature doesn't work with the Telerik RadDomainDataSource, or at least not in my case, or I dodn’t undestand how to make it work yet.
I can manage a work around by using Telerik RadGridView control bound to a standard DomaindataSource but unfortunately I do not understand why the Insert row of the grid is not working (it looks enabled by if I click on it, nothing happens, I cannot edit anything), all this inside an instance of a ChildWindow.
To answer your question on the type of insert I'm performing in the grid, I can assure you there is nothing wrong. If I use a DataForm instead of the Insert feature of Telerik Grid control to insert a new row with a standard DomainDataSource the property HasChanges is correcltly set to True. I do nothing in code behind, Everything is performed inside the XAML code and by the user. If I add 3 or 4 rows and then I hit the Save button on my window I would expect the HasChanges of Telerik RadDomainDataSource to be set to True, instead it is False....it looks really strange.....so at the moment I'm at an impasse: if I use Telerik RadDomainDataSource I am still not able to bind FilterDescriptors to TextBoxes Text property and the HasChanges property is set to False even if I have inserted some new rows in the grid, but I didn't save them in the EditEnded event handler but only when the window is closed by the user, if I use the standard DomainDataSource the Insert row of the RadGridView control doesn't work....now I can say that I don't know how to go on and I'm trying to collect documentation in order to fix one or both issues...maybe your help could cut short my research.
Just to have an idea I write you below the source code of the ChildWindow:
<controls:ChildWindow x:Class="GregorisGesProg.Views.LocationsWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:controls="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls"
xmlns:riaControls="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.DomainServices"
xmlns:my="clr-namespace:GregorisGesProg.Web.Services"
xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"
xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk"
xmlns:uc="clr-namespace:GregorisGesProg.Controls"
Width="400"
Title="Collocazioni">
<StackPanel x:Name="LayoutRoot" Margin="2">
<telerik:RadDomainDataSource Name="ddsLocations"
AutoLoad="True"
QueryName="GetLocations"
PageSize="10">
<telerik:RadDomainDataSource.DomainContext>
<my:LocationsContext />
</telerik:RadDomainDataSource.DomainContext>
<!--<telerik:RadDomainDataSource.FilterDescriptors>
<telerik:FilterDescriptor Member="Code" IsCaseSensitive="False" Operator="StartsWith" Value="{Binding Path=Text, ElementName=txtCode}"/>
<telerik:FilterDescriptor Member="Description" IsCaseSensitive="False" Operator="Contains" Value="{Binding Path=Text, ElementName=txtDescription}" />
</telerik:RadDomainDataSource.FilterDescriptors>-->
</telerik:RadDomainDataSource>
<StackPanel>
<Border BorderBrush="SteelBlue" BorderThickness="2" CornerRadius="4"></Border>
<telerik:RadGridView Margin="0, 4, 0, 0" HorizontalAlignment="Stretch" ShowInsertRow="True" ShowGroupPanel="True"
Name="dgridLocations" VerticalAlignment="Top"
ItemsSource="{Binding DataView, ElementName=ddsLocations}"
AutoGenerateColumns="False" IsReadOnly="False">
<telerik:RadGridView.Columns>
<telerik:GridViewDataColumn Header="Codice" DataMemberBinding="{Binding Code, Mode=TwoWay}"/>
<telerik:GridViewDataColumn Header="Descrizione" DataMemberBinding="{Binding Description, Mode=TwoWay}"/>
</telerik:RadGridView.Columns>
</telerik:RadGridView>
<sdk:DataPager Source="{Binding DataView, ElementName=ddsLocations}" PageSize="10" />
</StackPanel>
<StackPanel Margin="0, 8, 0, 0" Orientation="Horizontal" HorizontalAlignment="Right">
<Button x:Name="OKButton" Margin="4" Content="OK" Click="OKButton_Click" Width="75" Height="23" HorizontalAlignment="Right" />
<Button x:Name="CancelButton" Margin="4" Content="Cancel" Click="CancelButton_Click" Width="75" Height="23" HorizontalAlignment="Right" />
</StackPanel>
</StackPanel>
</controls:ChildWindow>
I add 3-4 rows then I hit OK and inside event handler OKButton_Click I check if ddsLocations.HasChanges is True and in that case I call SubmitChanges, but it is False ands even if I call SubmitChanges nothing happens, no changes ar esaved back on the server. My application use LINQ to NHibernate I do not use the Entity Framework and I have written the DomainService Query/Insert/Update/Delete methods (and tested).
I also took a look at the posts you gave me, but I couldn't find anything useful.
Please, I really need help here.
Rank 1
I have found the problem of the Insert row. It was a bug. The fact that with Talerik RadDomainaDataSource the insertion row worked misled me (my fault !).
Now it remains to fix the issue of the Filters using FilterDescriptors. If you can help me, please.
Thanks
May you take a look at our demos illustrating the integration of RadDataFilter with the RadDomainDataSource ?
Maya
the Telerik team