ASP:Chart control - databind pie chart from datatable

Question

I've got a datatable with two columns "Status" (string) and "Total" (integer).

 Status       Total
 Success      34
 Missing      2
 Failed       10

I want to databind this into a pie chart with each Status per slice but I'm not sure what method of data binder is required?

Thanks, Jonesy

Chris Van Opstal · Accepted Answer · 2010-04-16T19:24:45.653

7

Give this a shot:

    DataTable dt = new DataTable();
    dt.Columns.Add("Status");
    dt.Columns.Add("Total");

    dt.Rows.Add("Success", 34);
    dt.Rows.Add("Missing", 2);
    dt.Rows.Add("Failed", 10);

    Chart1.DataSource = dt;
    Chart1.Series["Series1"].XValueMember = "Status";
    Chart1.Series["Series1"].YValueMembers = "Total";
    Chart1.DataBind();

Update: The easiest way to add a legend is probably on the client side:

<Legends>
    <asp:Legend ... />
</Legends>

You can also add it programmatically:

    Chart1.Legends.Add("myLegend");

edited Apr 16 '10 at 19:24

answered Apr 16 '10 at 18:27

Chris Van Opstal

36,423
9
73
90

that worked a treat mate! thanks! One more thing if you would :) how do I add a legend to the chart? – iamjonesy Apr 16 '10 at 19:14

score 3 · Answer 2 · answered Apr 03 '12 at 20:46

I've did some research today and found this article as the best one.

Here's C# code above (by Chris) translated to VB.NET

Enjoy!

Dim dt As New DataTable()
dt.Columns.Add("Status")
dt.Columns.Add("Total")

dt.Rows.Add("Success", 34)
dt.Rows.Add("Missing", 2)
dt.Rows.Add("Failed", 10)

Chart1.DataSource = dt
Chart1.Series("Series1").XValueMember = "Status"
Chart1.Series("Series1").YValueMembers = "Total"
Chart1.DataBind()

ASP:Chart control - databind pie chart from datatable

2 Answers2