public void InitializeDashboard()
{
Dashboard dashboard = new Dashboard();
DashboardXpoDataSource xpoDataSource = CreateXpoDataSource();
dashboard.DataSources.Add(xpoDataSource);
PivotDashboardItem pivot = new PivotDashboardItem();
pivot.DataSource = xpoDataSource;
pivot.Rows.Add(new Dimension("ContactTitle"));
pivot.Columns.Add(new Dimension("Country"));
pivot.Values.Add(new Measure("CustomerID", SummaryType.Count));
ChartDashboardItem chart = new ChartDashboardItem();
chart.DataSource = xpoDataSource;
chart.Arguments.Add(new Dimension("Country"));
chart.Panes.Add(new ChartPane());
SimpleSeries theSeries = new SimpleSeries(SimpleSeriesType.Bar);
theSeries.Value = new Measure("CustomerID", SummaryType.Count);
chart.Panes[0].Series.Add(theSeries);
dashboard.Items.AddRange(pivot, chart);
dashboard.RebuildLayout();
dashboard.LayoutRoot.Orientation = DashboardLayoutGroupOrientation.Vertical;
dashboardDesigner1.Dashboard = dashboard;
}
public static void ConfigureDataSource(DataSourceInMemoryStorage storage)
{
// Registers an XPO data source.
DashboardXpoDataSource xpoDataSource = new DashboardXpoDataSource("XPO Data Source");
xpoDataSource.ConnectionStringName = "NWindConnectionString";
xpoDataSource.SetEntityType(typeof(Category));
storage.RegisterDataSource("xpoDataSource", xpoDataSource.SaveToXml());
}
public static DashboardXpoDataSource CreateXpoDataSource()
{
DashboardXpoDataSource dataSource = new DashboardXpoDataSource()
{
ConnectionStringName = "northwind"
};
dataSource.SetEntityType(typeof(nwind.Customers));
return(dataSource);
}
protected void Page_Load(object sender, EventArgs e)
{
DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards");
ASPxDashboardXpo.SetDashboardStorage(dashboardFileStorage);
// Uncomment the next line to allow users to create new data sources based on predefined connection strings.
//ASPxDashboardXpo.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider());
// Create a data source storage.
DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage();
// Register an XPO data source.
DashboardXpoDataSource xpoDataSource = new DashboardXpoDataSource("XPO Data Source");
xpoDataSource.ConnectionStringName = "NWindConnectionStringSQLite";
xpoDataSource.SetEntityType(typeof(Category));
dataSourceStorage.RegisterDataSource("xpoDataSource", xpoDataSource.SaveToXml());
// Set the configured data source storage.
ASPxDashboardXpo.SetDataSourceStorage(dataSourceStorage);
ASPxDashboardXpo.InitialDashboardId = "dashboardXpo";
}
