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
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
Sandip
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://es.infragistics.com/community/blogs/b/atanas_dyulgerov/posts/using-xampivotgrid-and-ria-services
Thanks in advance.
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.
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