public static DataView GetDataTable(int count)
{
DataTable dt = new DataTable("BusinessObjectsDataTable");
PropertyDescriptorCollection pdc = TypeDescriptor.GetProperties(typeof(BusinessObject));
foreach (PropertyDescriptor pd in pdc)
{
dt.Columns.Add(new DataColumn(pd.Name, pd.PropertyType));
}
BusinessObjectCollection list = BusinessObjectCollection.GetList(count);
foreach (BusinessObject bo in list)
{
DataRow dr = dt.NewRow();
foreach (PropertyDescriptor pd in pdc)
{
dr[pd.Name] = pd.GetValue(bo);
}
dt.Rows.Add(dr);
}
return(dt.DefaultView);
}
/// <summary>
/// Loads the List as DataSource for PivotGridControl
/// </summary>
private void LoadList()
{
this.pivotGrid1.ItemSource = null;
this.pivotGrid1.ResetPivotData();
this.pivotGrid1.ItemSource = BusinessObjectCollection.GetList(200);
this.pivotGrid1.PivotRows.Add(new PivotItem()
{
FieldMappingName = "Fruit", FieldHeader = "Fruit", TotalHeader = "Total"
});
this.pivotGrid1.PivotRows.Add(new PivotItem()
{
FieldMappingName = "Color", FieldHeader = "Color", TotalHeader = "Total"
});
this.pivotGrid1.PivotColumns.Add(new PivotItem()
{
FieldMappingName = "Shape", FieldHeader = "Shape", TotalHeader = "Total"
});
this.pivotGrid1.PivotColumns.Add(new PivotItem()
{
FieldMappingName = "Even", FieldHeader = "Even", TotalHeader = "Total"
});
this.pivotGrid1.PivotCalculations.Add(new PivotComputationInfo()
{
FieldName = "Count", FieldHeader = "Count", SummaryType = SummaryType.DoubleTotalSum
});
this.pivotGrid1.PivotCalculations.Add(new PivotComputationInfo()
{
FieldName = "Section", FieldHeader = "Section", SummaryType = SummaryType.DoubleTotalSum
});
this.pivotGrid1.PivotCalculations.Add(new PivotComputationInfo()
{
FieldName = "Weight", FieldHeader = "Weight", SummaryType = SummaryType.DoubleTotalSum
});
}
