Thursday, January 24, 2013

How to Bind DataTable to ASP.NET Pie Chart


To Bind DataTable to ASP.NET Pie Chart, refer the below code.
  1. DataTable dt=new DataTable();
  2. dt.Columns.Add("Name");
  3. dt.Columns.Add("Percentage");
  4. DataRow dr=dt.NewRow();
  5. dr["Name"]="Name1";
  6. dr["Percentage"]="80";
  7. dt.Rows.Add(dr);
  8. DataRow dr1=dt.NewRow();
  9. dr1["Name"]="Name2";
  10. dr1["Percentage"]="75";
  11. dt.Rows.Add(dr1);
  12. DataRow dr2=dt.NewRow();
  13. dr2["Name"]="Name3";
  14. dr2["Percentage"]="90";
  15. dt.Rows.Add(dr2);
  16. DataRow dr3=dt.NewRow();
  17. dr3["Name"]="Name4";
  18. dr3["Percentage"]="100";
  19. dt.Rows.Add(dr3);
  20. Dictionary<string, int> chartData = new Dictionary<string, int>();
  21. foreach (DataRow r in dt.Rows)
  22. {
  23. string key = r["Name"].ToString();
  24. int value = Convert.ToInt32(r["Percentage"]);
  25. chartData.Add(key, value);
  26. }
  27. Chart1.Series["Series1"].Points.DataBind(chartData , "Key", "Value", string.Empty);

No comments:

Post a Comment