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"; }