asp.net3.5中的动态饼图 [英] dynamic Pie chart in asp.net3.5
问题描述
朋友我需要在asp.net中使用数据库创建饼图,请帮助我
friends i need to create pie chart in asp.net using Database ,please help me
推荐答案
<div>
<asp:Chart ID="Chart1" runat="server" Width="500px">
<Series>
<asp:Series Name="Education" XValueMember="name" YValueMembers="currency"
IsVisibleInLegend="true" ChartType="Pie">
</asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="ChartArea1" Area3DStyle-Enable3D="true">
<AxisX LineColor="DarkGray">
<MajorGrid LineColor="LightGray" />
</AxisX>
<AxisY LineColor="DarkGray">
<MajorGrid LineColor="LightGray" />
</AxisY>
<Area3DStyle Enable3D="True"></Area3DStyle>
</asp:ChartArea>
</ChartAreas>
<Legends>
<asp:Legend>
</asp:Legend>
</Legends>
</asp:Chart>
</div>
private void CreateChart()
{
SqlConnection sqlconn = new SqlConnection(连接);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue(@ Queryno,3 );
cmd.CommandText =Satish_Pro;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection = sqlconn;
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds) ;
if(ds.Tables [0] .Rows.Count> 0)
{
Chart1.DataSource = ds;
Chart1.DataBind();
}
}
private void CreateChart()
{
SqlConnection sqlconn = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@Queryno", "3");
cmd.CommandText = "Satish_Pro";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection = sqlconn;
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
Chart1.DataSource = ds;
Chart1.DataBind();
}
}
这篇关于asp.net3.5中的动态饼图的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!