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屋！