To Bind DataTable to ASP.NET Pie Chart, refer the below code.
- DataTable dt=new DataTable();
- dt.Columns.Add("Name");
- dt.Columns.Add("Percentage");
- DataRow dr=dt.NewRow();
- dr["Name"]="Name1";
- dr["Percentage"]="80";
- dt.Rows.Add(dr);
- DataRow dr1=dt.NewRow();
- dr1["Name"]="Name2";
- dr1["Percentage"]="75";
- dt.Rows.Add(dr1);
- DataRow dr2=dt.NewRow();
- dr2["Name"]="Name3";
- dr2["Percentage"]="90";
- dt.Rows.Add(dr2);
- DataRow dr3=dt.NewRow();
- dr3["Name"]="Name4";
- dr3["Percentage"]="100";
- dt.Rows.Add(dr3);
- Dictionary<string, int> chartData = new Dictionary<string, int>();
- foreach (DataRow r in dt.Rows)
- {
- string key = r["Name"].ToString();
- int value = Convert.ToInt32(r["Percentage"]);
- chartData.Add(key, value);
- }
- Chart1.Series["Series1"].Points.DataBind(chartData , "Key", "Value", string.Empty);
No comments:
Post a Comment