foreach (RadTreeViewItem item in treeColumns.Items)
{
DataAccess.ctx.ExecuteCommand("Update WorkFlow Set SortOrder=" + lOrder.ToString() + " Where ItemID='" + new Guid(item.Tag.ToString()) + "'");
RecursiveItems(item);
lOrder++;
}
private
void RecursiveItems(RadTreeViewItem treeitem)
{
int lOrder = 1;
foreach (RadTreeViewItem item in treeitem.Items)
{
DataAccess.ctx.ExecuteCommand("Update WorkFlow Set SortOrder=" + lOrder.ToString() + " Where ItemID='" + new Guid(item.Tag.ToString()) + "'");
if (item.Items.Count > 0)
{
RecursiveItems(item);
}
lOrder++;
}
DataAccess.ctx.SubmitChanges();
}
var CVDOverviewData = from cvdo in pieData.CVDOverviews |
select new |
{ |
OverTwentyfive = cvdo.OverTwentyfive, |
OverTwenty = cvdo.OverTwenty, |
OverFifteen = cvdo.OverFifteen, |
OverTen = cvdo.OverTen, |
LessTen = cvdo.LessTen |
}; |
the result is a sinlge row with a column for each range (over25, over20, over15 ...)
How so I get these values into a pie chart?
Sorry if this is a real newbie question.
Cheers in advance.
PieSeriesDefinition definition = new PieSeriesDefinition(); |
definition.LegendDisplayMode = LegendDisplayMode.DataPointLabel; |
radChart1.DefaultSeriesDefinition = definition; |
DataSeries DS = new DataSeries(); |
DataPoint DP = new DataPoint(); |
DS.LegendLabel = "Over25"; |
DP.YValue = 66; |
DS.Add(DP); |
radChart1.DefaultView.ChartArea.DataSeries.Add(DS); |
DataSeries DS2 = new DataSeries(); |
DataPoint DP2 = new DataPoint(); |
DS2.LegendLabel = "Over20"; |
DP2.YValue = 100; |
DS2.Add(DP2); |
radChart1.DefaultView.ChartArea.DataSeries.Add(DS2); |
DataSeries DS3 = new DataSeries(); |
DataPoint DP3 = new DataPoint(); |
DS3.LegendLabel = "Over15"; |
DP3.YValue = 120; |
DS3.Add(DP3); |
radChart1.DefaultView.ChartArea.DataSeries.Add(DS3); |
DataSeries DS4 = new DataSeries(); |
DataPoint DP4 = new DataPoint(); |
DS4.LegendLabel = "Over10"; |
DP4.YValue = 113; |
DS4.Add(DP4); |
radChart1.DefaultView.ChartArea.DataSeries.Add(DS4); |
DataSeries DS5 = new DataSeries(); |
DataPoint DP5 = new DataPoint(); |
DS5.LegendLabel = "Under10"; |
DP5.YValue = 178; |
DS5.Add(DP5); |
radChart1.DefaultView.ChartArea.DataSeries.Add(DS5); |