ExpertPDF Components: .NET Chart Control

WebChart data sources

Learn how you can display chart data from a DataTable.

DataTable

ExpertChart control can display data from a DataTable. This way, using the .NET class DataTable, the chart can load data from any database format.

100 200 300 100 300 200 200 220 270 300 260 320 100 100 100 110 140 60 160 120 160 80 200 230 100 190 110 110 200 170 290 100 120 190 220 120 100 190 200 270 290 290 For more information visit www.chartingcontrol.net

Source code

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            WebChart1.DataSource = ExpertChart.Demo.DataSources.GetTestData();
 
        }
    }
 
    /// <summary>
    /// This method returns a sample DataTable with test data
    /// The tables has the following structure:
    /// - Labels (string)
    /// - Date (DateTime)
    /// - Seller1 (number)
    /// - Seller2 (number)
    /// - Seller3 (number)
    /// </summary>
    public static DataTable GetTestData()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("Labels", typeof(string));
        dt.Columns.Add("Date", typeof(DateTime));
        dt.Columns.Add("Seller1", typeof(int));
        dt.Columns.Add("Seller2", typeof(int));
        dt.Columns.Add("Seller3", typeof(int));
 
        DataRow row = dt.NewRow();
        row["Date"] = new DateTime(2006, 1, 1);
        row["Labels"] = "January";
        row["Seller1"] = 100;
        row["Seller2"] = 100;
        row["Seller3"] = 200;
        dt.Rows.Add(row);
 
        row = dt.NewRow();
        row["Date"] = new DateTime(2006, 2, 1);
        row["Labels"] = "February";
        row["Seller1"] = 200;
        row["Seller2"] = 110;
        row["Seller3"] = 170;
        dt.Rows.Add(row);
 
        row = dt.NewRow();
        row["Date"] = new DateTime(2006, 3, 1);
        row["Labels"] = "March";
        row["Seller1"] = 300;
        row["Seller2"] = 140;
        row["Seller3"] = 290;
        dt.Rows.Add(row);
 
        row = dt.NewRow();
        row["Date"] = new DateTime(2006, 4, 1);
        row["Labels"] = "April";
        row["Seller1"] = 100;
        row["Seller2"] = 60;
        row["Seller3"] = 100;
        dt.Rows.Add(row);
 
        row = dt.NewRow();
        row["Date"] = new DateTime(2006, 5, 1);
        row["Labels"] = "May";
        row["Seller1"] = 300;
        row["Seller2"] = 160;
        row["Seller3"] = 120;
        dt.Rows.Add(row);
 
        row = dt.NewRow();
        row["Date"] = new DateTime(2006, 6, 1);
        row["Labels"] = "June";
        row["Seller1"] = 200;
        row["Seller2"] = 120;
        row["Seller3"] = 190;
        dt.Rows.Add(row);
 
        row = dt.NewRow();
        row["Date"] = new DateTime(2006, 7, 1);
        row["Labels"] = "June";
        row["Seller1"] = 200;
        row["Seller2"] = 160;
        row["Seller3"] = 220;
        dt.Rows.Add(row);
 
        row = dt.NewRow();
        row["Date"] = new DateTime(2006, 8, 1);
        row["Labels"] = "August";
        row["Seller1"] = 220;
        row["Seller2"] = 80;
        row["Seller3"] = 120;
        dt.Rows.Add(row);
 
        row = dt.NewRow();
        row["Date"] = new DateTime(2006, 9, 1);
        row["Labels"] = "September";
        row["Seller1"] = 270;
        row["Seller2"] = 200;
        row["Seller3"] = 100;
        dt.Rows.Add(row);
 
        row = dt.NewRow();
        row["Date"] = new DateTime(2006, 10, 1);
        row["Labels"] = "October";
        row["Seller1"] = 300;
        row["Seller2"] = 230;
        row["Seller3"] = 190;
        dt.Rows.Add(row);
 
        row = dt.NewRow();
        row["Date"] = new DateTime(2006, 11, 1);
        row["Labels"] = "November";
        row["Seller1"] = 260;
        row["Seller2"] = 100;
        row["Seller3"] = 200;
        dt.Rows.Add(row);
 
        row = dt.NewRow();
        row["Date"] = new DateTime(2006, 12, 1);
        row["Labels"] = "December";
        row["Seller1"] = 320;
        row["Seller2"] = 190;
        row["Seller3"] = 270;
        dt.Rows.Add(row);
 
        return dt;
 
    }

Copyright 2008. ExpertComponents.com ChartingControl.NET.