Dear members, am looking for any samples of using the xampivotgrid control with a relational database. any help will greatly be appreciated.
Hi, Tonny,
Have you tried using RIA services to access the relational database? Take a look at this article and the one it refers to.
I hope this helps. Have a great day!
Atanas
Atanas, thanks a lot for the link. I am following that tutorial and am sure ill get there.
Thanks
Dear Atanas, how do I add the xampivotgrid to the list of associated controls in visual studio so when I drag the table from the datasources it displays in the xampivotgrid by default?
Regards,
Tonny
Hello Tonny,
Generaly this could be a part of design time features of given conrol but xamPivotGrid does not support that behavior at this time.
Regards.PPilev.
Hi,
I'm trying RIA Services as DataSource to xamPivtoGrid. It's works but I'm not getting ay data & nothing is available for selection. I need to do anything else to work with with my PivotGrid.
I'm refering https://www.infragistics.com/community/blogs/b/atanas_dyulgerov/posts/using-xampivotgrid-and-ria-services
Thanks in advance.
Sandip
With reference to above post. I'm not getting any results in PivotGrid.
I'm checking in codebehind & my pivotGrid DataSource is null. Here is my my code
<
UserControl x:Class
="CustomerOrdersRiaApp.CSFManagement"
xmlns
="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x
="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d
="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc
="http://schemas.openxmlformats.org/markup-compatibility/2006"
mc:Ignorable
="d"
d:DesignHeight="300" d:DesignWidth="400" xmlns:riaControls="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.DomainServices"
xmlns:my="clr-namespace:CustomerOrdersRiaApp.Web"
xmlns:ig
="http://schemas.infragistics.com/xaml">
<Grid x:Name="LayoutRoot" Background
="White">
<Grid.ColumnDefinitions
>
<ColumnDefinition
/>
<ColumnDefinition Width
="Auto" />
</Grid.ColumnDefinitions
<riaControls:DomainDataSource AutoLoad="True" d:DesignData="{d:DesignInstance my:vwTranDetail, CreateList=true}" Height="0"
LoadedData="vwTranDetailDomainDataSource_LoadedData" Name="vwTranDetailDomainDataSource" QueryName="GetVwTranDetailsQuery" Width
="0">
<riaControls:DomainDataSource.DomainContext
<my:CSFContext
</riaControls:DomainDataSource.DomainContext
</riaControls:DomainDataSource
<ig:XamPivotGrid
x:Name="pivotGrid"
Grid.Column="0"
DataSource="{Binding Source=vwTranDetailDomainDataSource, Path=Data}"
AllowCompactLayout
="True" />
<ig:XamPivotDataSelector
x:Name="xamPivotDataSelector"
Grid.Column="1"
DataSource="{Binding Source=pivotGrid, Path
=DataSource}" />
</Grid
> </
</
UserControl