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
>