or
Hi,
I want to use the data from the database to a pie chart.
is it possible in WPF chart??
I found an example in reporting however I want it in WPF
http://www.telerik.com/help/reporting/buildingdatabinddatabase.html
thanks in advance
<Controls1:RadGridView Grid.Row="1" x:Name="radGridDebits" AutoGenerateColumns="False" ShowColumnHeaders="False" IsReadOnly="True" ItemsSource="{Binding Data}" ShowGroupPanel="False" RowIndicatorVisibility="Collapsed" AutoExpandGroups="False"> <Controls1:RadGridView.SortDescriptors> <Data:SortDescriptor Member="HlpAccountGroup.CategoryID" /> <Data:SortDescriptor Member="Description" /> </Controls1:RadGridView.SortDescriptors> <Controls1:RadGridView.GroupDescriptors> <Data:GroupDescriptor Member="HlpGroupCompany.Description" DisplayContent="Group company" SortDirection="Ascending" /> </Controls1:RadGridView.GroupDescriptors> <Controls1:RadGridView.FilterDescriptors> <Data:CompositeFilterDescriptorCollection> <Data:CompositeFilterDescriptor LogicalOperator="Or"> <Data:FilterDescriptor Member="HlpAccountGroup.AccountType" Value="Debit" /> <Data:FilterDescriptor Member="HlpAccountGroup.AccountType" Value="Common" /> </Data:CompositeFilterDescriptor> </Data:CompositeFilterDescriptorCollection> </Controls1:RadGridView.FilterDescriptors> <Controls1:RadGridView.GroupHeaderTemplate> <DataTemplate> <Border Background="{Binding Group.Items[0].HlpGroupCompany.Brush}" Padding="3" Width="250" CornerRadius="3" BorderThickness="1"> <StackPanel Orientation="Horizontal"> <TextBlock Text="Group company:" Margin="0,0,3,0" /> <TextBlock Text="{Binding Group.Key}" Foreground="{StaticResource DarkBackground}" FontWeight="Bold" /> </StackPanel> </Border> </DataTemplate> </Controls1:RadGridView.GroupHeaderTemplate> <Controls1:RadGridView.Columns> <Controls1:GridViewDataColumn Header="Account" DataMemberBinding="{Binding Description}" /> <Controls1:GridViewDataColumn Header="" DataMemberBinding="{Binding HlpCurrency.CurrencyId}" /> </Controls1:RadGridView.Columns> </Controls1:RadGridView><Controls1:RadGridView Grid.Row="1" x:Name="radGridCredits" AutoGenerateColumns="False" ShowColumnHeaders="False" IsReadOnly="True" ItemsSource="{Binding Data}" ShowGroupPanel="False" RowIndicatorVisibility="Collapsed" AutoExpandGroups="False"> <Controls1:RadGridView.SortDescriptors> <Data:SortDescriptor Member="HlpAccountGroup.CategoryID" /> <Data:SortDescriptor Member="Description" /> </Controls1:RadGridView.SortDescriptors> <Controls1:RadGridView.GroupDescriptors> <Data:GroupDescriptor Member="HlpGroupCompany.Description" DisplayContent="Group company" SortDirection="Ascending" /> </Controls1:RadGridView.GroupDescriptors> <Controls1:RadGridView.FilterDescriptors> <Data:CompositeFilterDescriptorCollection> <Data:CompositeFilterDescriptor LogicalOperator="Or"> <Data:FilterDescriptor Member="HlpAccountGroup.AccountType" Value="Credit" /> <Data:FilterDescriptor Member="HlpAccountGroup.AccountType" Value="Common" /> </Data:CompositeFilterDescriptor> </Data:CompositeFilterDescriptorCollection> </Controls1:RadGridView.FilterDescriptors> <Controls1:RadGridView.GroupHeaderTemplate> <DataTemplate> <Border Background="{Binding Group.Items[0].HlpGroupCompany.Brush}" Padding="3" Width="250" CornerRadius="3" BorderThickness="1"> <StackPanel Orientation="Horizontal"> <TextBlock Text="Group company:" Margin="0,0,3,0" /> <TextBlock Text="{Binding Group.Key}" Foreground="{StaticResource DarkBackground}" FontWeight="Bold" /> </StackPanel> </Border> </DataTemplate> </Controls1:RadGridView.GroupHeaderTemplate> <Controls1:RadGridView.Columns> <Controls1:GridViewDataColumn Header="Account" DataMemberBinding="{Binding Description}" /> <Controls1:GridViewDataColumn Header="" DataMemberBinding="{Binding HlpCurrency.CurrencyId}" /> </Controls1:RadGridView.Columns> </Controls1:RadGridView><telerik:RadPanelBar Orientation="Vertical" Background="Gray" ExpandMode="Multiple" > <telerik:RadPanelBarItem IsExpanded="True" Header="Locations" Style="{DynamicResource sidePanelRadPanelBarItemStyle}">
<telerik:RadTreeView> <telerik:RadTreeViewItem Header="Person A" > <telerik:RadTreeViewItem Header="Child 01"/> <telerik:RadTreeViewItem Header="Child 02"/> <telerik:RadTreeViewItem Header="Child 03"/> <telerik:RadTreeViewItem Header="Child 04"/> </telerik:RadTreeViewItem> <telerik:RadTreeViewItem Header="Person Two" > <telerik:RadTreeViewItem Header="Child 01"/> <telerik:RadTreeViewItem Header="Child 02"/> <telerik:RadTreeViewItem Header="Child 03"/> <telerik:RadTreeViewItem Header="Child 04"/> <telerik:RadTreeViewItem Header="Child 05"/> <telerik:RadTreeViewItem Header="Child 06"/> </telerik:RadTreeViewItem> </telerik:RadTreeView> </telerik:RadPanelBarItem></telerik:RadPanelBar><Style x:Key="sidePanelRadPanelBarItemStyle" TargetType="{x:Type telerik:RadPanelBarItem}"> <Setter Property="Background"> <Setter.Value> <LinearGradientBrush EndPoint="0.5,1" StartPoint="0.5,0"> <GradientStop Color="Gainsboro" Offset="-0.5"/> <GradientStop Color="Black" Offset="0.2"/> <GradientStop Color="Black" Offset="1"/> </LinearGradientBrush> </Setter.Value> </Setter> <Setter Property="BorderBrush" Value="#FF848484"/> <Setter Property="BorderThickness" Value="0"/> <Setter Property="Foreground" Value="White"/> <Setter Property="Padding" Value="5"/> <Setter Property="HorizontalContentAlignment" Value="Stretch"/> <Setter Property="VerticalContentAlignment" Value="Stretch"/> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="{x:Type telerik:RadPanelBarItem}"> <Grid x:Name="RootElement"> <Grid.RowDefinitions> <RowDefinition Height="Auto"/> <RowDefinition Height="Auto"/> </Grid.RowDefinitions> <Grid x:Name="HeaderRow" Background="Transparent"> <ContentControl x:Name="Header" ContentTemplate="{TemplateBinding HeaderTemplate}" Foreground="{TemplateBinding Foreground}" HorizontalAlignment="{TemplateBinding HorizontalContentAlignment}" Margin="{TemplateBinding Padding}" VerticalAlignment="{TemplateBinding VerticalContentAlignment}"/> <Rectangle x:Name="FocusVisual" IsHitTestVisible="False" RadiusY="2" RadiusX="2" Stroke="Black" StrokeThickness="1" StrokeDashArray="1 2" Visibility="Collapsed"/> </Grid> <Grid x:Name="ItemsContainer" Grid.Row="1" Visibility="Collapsed" VerticalAlignment="Top" > <ItemsPresenter/> </Grid> </Grid> <ControlTemplate.Triggers> <Trigger Property="IsFocused" Value="True"> <Setter Property="Visibility" TargetName="FocusVisual" Value="Visible"/> </Trigger> <Trigger Property="IsExpanded" Value="True"> <Setter Property="Visibility" TargetName="ItemsContainer" Value="Visible"/> </Trigger> </ControlTemplate.Triggers> </ControlTemplate> </Setter.Value> </Setter> <Setter Property="ItemsPanel"> <Setter.Value> <ItemsPanelTemplate> <telerik:PanelBarPanel IsItemsHost="True"/> </ItemsPanelTemplate> </Setter.Value> </Setter> <Style.Triggers> <Trigger Property="Level" Value="1"> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="{x:Type telerik:RadPanelBarItem}"> <Grid x:Name="RootElement" SnapsToDevicePixels="True"> <Grid.RowDefinitions> <RowDefinition Height="Auto"/> <RowDefinition Height="Auto"/> </Grid.RowDefinitions> <Grid x:Name="HeaderRow"> <Grid.ColumnDefinitions> <ColumnDefinition Width="Auto"/> <ColumnDefinition Width="Auto"/> <ColumnDefinition Width="Auto"/> <ColumnDefinition Width="*"/> <ColumnDefinition Width="Auto"/> </Grid.ColumnDefinitions> <Border BorderBrush="{TemplateBinding BorderBrush}" BorderThickness="{TemplateBinding BorderThickness}" Grid.ColumnSpan="5"> <Border BorderBrush="White" BorderThickness="0.2" Background="{TemplateBinding Background}"/> </Border> <ContentControl x:Name="Header" Grid.ColumnSpan="4" ContentTemplate="{TemplateBinding HeaderTemplate}" Foreground="{TemplateBinding Foreground}" FontSize="{TemplateBinding FontSize}" HorizontalAlignment="{TemplateBinding HorizontalContentAlignment}" Margin="{TemplateBinding Padding}" VerticalAlignment="{TemplateBinding VerticalContentAlignment}"/> <Rectangle x:Name="FocusVisual" Grid.ColumnSpan="5" Grid.Column="0" IsHitTestVisible="False" Stroke="Black" StrokeThickness="1" StrokeDashArray="1 2" Visibility="Collapsed"/> <Rectangle x:Name="rect1" Grid.Column="3" HorizontalAlignment="Right" Margin="0,0,7.75,4.5" Stroke="{x:Null}" StrokeThickness="2" Width="13.5" Fill="#FF7C7C7C" Height="3.25" VerticalAlignment="Bottom" RenderTransformOrigin="0.5,0.5"/> <Rectangle x:Name="rect2" Grid.Column="3" HorizontalAlignment="Right" Margin="0,5.277,7.75,0" Stroke="{x:Null}" StrokeThickness="2" Width="13.5" Fill="#FF7C7C7C" Height="3.25" VerticalAlignment="Top" RenderTransformOrigin="0.5,0.5"/> <Rectangle x:Name="rect3" Grid.Column="3" HorizontalAlignment="Right" Margin="0,10.527,7.75,9.5" Stroke="{x:Null}" StrokeThickness="2" Width="13.5" Fill="#FF7C7C7C" Height="Auto" VerticalAlignment="Stretch" RenderTransformOrigin="0.5,0.5"/> </Grid> <Grid x:Name="ItemsContainer" Grid.Row="1" Visibility="Collapsed" Background="Gray" > <telerik:LayoutTransformControl x:Name="transformationRoot" IsTabStop="False"> <ItemsPresenter/> </telerik:LayoutTransformControl> </Grid> </Grid> <ControlTemplate.Triggers> <Trigger Property="IsSelected" Value="True"> <Setter Property="Fill" TargetName="rect1" Value="White"/> <Setter Property="Fill" TargetName="rect2" Value="White"/> <Setter Property="Fill" TargetName="rect3" Value="White"/> </Trigger> <Trigger Property="IsFocused" Value="True"> <Setter Property="Visibility" TargetName="FocusVisual" Value="Visible"/> </Trigger> <Trigger Property="IsExpanded" Value="True"> </Trigger.ExitActions>--> <Setter Property="Fill" TargetName="rect1" Value="White"/> <Setter Property="Fill" TargetName="rect2" Value="White"/> <Setter Property="Fill" TargetName="rect3" Value="White"/> <Setter Property="Visibility" TargetName="ItemsContainer" Value="Visible"/> </Trigger> <Trigger Property="IsEnabled" Value="False"> <Setter Property="Foreground" TargetName="Header" Value="Gray"/> </Trigger> <Trigger Property="IsMouseOver" Value="True"> <Setter Property="Fill" TargetName="rect1" Value="SteelBlue"/> <Setter Property="Fill" TargetName="rect2" Value="SteelBlue"/> <Setter Property="Fill" TargetName="rect3" Value="SteelBlue"/> <Setter Property="Foreground" TargetName="Header" Value="SteelBlue"/> </Trigger> </ControlTemplate.Triggers> </ControlTemplate> </Setter.Value> </Setter> </Trigger> </Style.Triggers></Style>