public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); DashboardSqlDataSource dataSource = new DashboardSqlDataSource(); CustomSqlQuery sqlQuery = new CustomSqlQuery("Countries", "select * from Countries"); dataSource.ConnectionParameters = new Access97ConnectionParameters(@"..\..\Data\countriesDB.mdb", "", ""); dataSource.Queries.Add(sqlQuery); ChoroplethMapDashboardItem choroplethMap = new ChoroplethMapDashboardItem(); choroplethMap.DataSource = dataSource; choroplethMap.DataMember = "Countries"; choroplethMap.Area = ShapefileArea.WorldCountries; choroplethMap.AttributeName = "NAME"; choroplethMap.AttributeDimension = new Dimension("Country"); ValueMap populationMap = new ValueMap(new Measure("Population")); choroplethMap.Maps.Add(populationMap); dashboard.Items.Add(choroplethMap); dashboardViewer1.Dashboard = dashboard; }
public Form1() { InitializeComponent(); // Loads a dashboard that contains a choropleth map with the default palette. Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml"); // Gets the ValueMap object that provides data for coloring map shapes. ChoroplethMapDashboardItem map = (ChoroplethMapDashboardItem)dashboard.Items[0]; ValueMap populationMap = (ValueMap)map.Maps[0]; // Creates CustomPalette and CustomScale objects. CustomPalette customPalette = new CustomPalette(); CustomScale customScale = new CustomScale(); // Creates lists of custom colors and range stops. List <Color> customColors = new List <Color>(); List <double> rangeStops = new List <double>(); // Specifies that the absolute scale is used to define a set of colors. customScale.IsPercent = false; // Specifies custom colors and corresponding range stops. customColors.Add(Color.LightBlue); rangeStops.Add(100000); customColors.Add(Color.SkyBlue); rangeStops.Add(1000000); customColors.Add(Color.LightCoral); rangeStops.Add(10000000); customColors.Add(Color.Tomato); rangeStops.Add(100000000); customColors.Add(Color.Maroon); rangeStops.Add(1000000000); // Adds custom colors and range stops to a custom palette and corresponding custom scale. customPalette.Colors.AddRange(customColors); customScale.RangeStops.AddRange(rangeStops); // Specifies a custom palette and scale for the ValueMap object. populationMap.Palette = customPalette; populationMap.Scale = customScale; // Sets the customized dashboard as a currently opened dashboard. dashboardViewer1.Dashboard = dashboard; }
public Form1() { InitializeComponent(); Dashboard dashboard = new Dashboard(); //Create an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource(); excelDataSource.FileName = @"..\..\Data\Sales.xlsx"; ExcelWorksheetSettings worksheetSettings = new ExcelWorksheetSettings("Sheet1", "A1:I4166"); excelDataSource.SourceOptions = new ExcelSourceOptions(worksheetSettings); excelDataSource.Fill(); dashboard.DataSources.Add(excelDataSource); // Create a Choropleth Map dashboard item. ChoroplethMapDashboardItem map = new ChoroplethMapDashboardItem(); map.Name = "Choropleth Map"; map.DataSource = excelDataSource; map.Legend.Visible = true; map.ShapeTitleAttributeName = "NAME"; map.AttributeName = "NAME"; map.AttributeDimension = new Dimension("State"); ValueMap revenueYTDMap = new ValueMap(new Measure("RevenueYTD (Sum)")); map.Maps.Add(revenueYTDMap); // Loads a custom shape file to the map. map.Area = ShapefileArea.Custom; CustomShapefileData data = new CustomShapefileData(); data.ShapeData = File.ReadAllBytes(@"..\..\Map\USA.shp"); data.AttributeData = File.ReadAllBytes(@"..\..\Map\USA.dbf"); map.CustomShapefile.Data = data; dashboard.Items.Add(map); dashboardViewer.Dashboard = dashboard; }
public Form1() { InitializeComponent(); // Creates a new dashboard and a data source for this dashboard. Dashboard dashboard = new Dashboard(); DashboardSqlDataSource dataSource = new DashboardSqlDataSource(); CustomSqlQuery sqlQuery = new CustomSqlQuery("Countries", "select * from Countries"); dataSource.ConnectionParameters = new Access97ConnectionParameters(@"..\..\Data\countriesDB.mdb", "", ""); dataSource.Queries.Add(sqlQuery); // Creates a choropleth map dashboard item and specifies its data source. ChoroplethMapDashboardItem choroplethMap = new ChoroplethMapDashboardItem(); choroplethMap.DataSource = dataSource; choroplethMap.DataMember = "Countries"; // Loads the map of the world. choroplethMap.Area = ShapefileArea.WorldCountries; // Specifies a binding between the required map attribute and the data source field. choroplethMap.AttributeName = "NAME"; choroplethMap.AttributeDimension = new Dimension("Country"); // Creates a ValueMap object with a measure that provides data for color map shapes. // Then, adds this object to the Maps collection of the choropleth map dashboard item. ValueMap populationMap = new ValueMap(new Measure("Population")); choroplethMap.Maps.Add(populationMap); // Adds the choropleth map dashboard item to the dashboard and opens this // dashboard in the Dashboard Viewer. dashboard.Items.Add(choroplethMap); dashboardViewer1.Dashboard = dashboard; }