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