如何使用数据源显示饼图控件 [英] How to display pie chart control using datasource

问题描述

 <   asp：Chart     ID   =  Chart1     runat   =  server    DataSourceID   =  SqlDataSource1  
   
                   ImageLoc ation   = 〜/ TempImages / ChartPic_＃SEQ（300,3）  
   
                   ImageStorageMode   =  UseImageLocation   >  
 <％  - <标题> 
< asp：Title Name =   Title1 Text =  生产力 
 Alignment =   TopCenter字体=   Verdana，12pt，style = Bold >  
 < /   asp：标题 >  
 <   /标题 >   - ％> 
 <  系列 >  
 <   asp：Series    名称  =  Series1 < span class =code-attribute>   ChartType   =  Pie    XValueMember   =   User_Id    YValueMembers   = 利润       颜色  = 绿色  
   
   
   
                          >  
 <   / asp：Series  >  
 
 <％  - < asp：Series Name =   Series2 ChartType =   Pie XValueMember =   User_Id YValueMembers =  利润颜色=  红色 
 >  
 < /  < span class =code-leadattribute> asp：Series  >   - ％> 
 <％  - < asp：Series Name =   Series3 ChartType =   Pie XValueMember =   User_Id YValueMembers =   Total_Balance 
 >  
 < /   asp：Series  >   - ％> 
 <％  - < asp：Series Name =   Series2 ChartType =   Pie颜色=  红色 
 >  
 < /   asp：Series  >  
 <   asp：Series    名称  =  Series3 < span class =code-attribute>   ChartType   =  Pie     颜色  = 蓝色 < span class =code-attribute> 
   
    < span class =code-attribute>                      >  
 <   / asp：系列 >   - ％> 
 <   / Series  >  
 <   ChartAreas  >  
 <   asp：ChartArea    名称  =  ChartArea1   >  
 <％  - < AxisY Title =  百分比  >  
 < /   AxisY  >  
 <  < span class =code-leadattribute> AxisX    标题  = 生产力 >  
 <   / AxisX  >  
 <   AxisX2    标题  = 已实现目标  >  
 <   / AxisX2  >  
 <   AxisY2     Titl e   = 余额目标 >  
 <   / AxisY2   >   - ％GT; 
 
 <   Area3DStyle     Enable3D   =  True   轮播  =  90   倾斜  =  0  /  >  
 <   / asp：ChartArea  >  
 <   / ChartAreas  >  
 <   / asp：图表 >  
 <   asp：SqlDataSource     ID   =  SqlDataSource1    runat   =  server  
   
                   ConnectionString  < span class =code-keyword> =  <％ $ ConnectionStrings：NewProductivityConnectionString ％>   
   
           SelectCommand   =  SELECT [User_Id]，[Profit]，[Total_TargetAchieved]，[Total_Balance] FROM [Customer_Productivity] ORDER BY [User_Id] < span class =code-attribute> 
   
    < span class =code-attribute>                      < span class =code-attribute>                          >  
 <   / asp：SqlDataSource  >  

aspx.cs

   #region ChartProperties 
  Chart1.DataSourceID =   SqlDataSource1; 
 
 Chart1.Series [  Series1]。ChartType = SeriesChartType.Pie ; 
 Chart1.Series [  Series1] [  PieLabelStyle] =   outside ; 
 Chart1.Series [  Series1] [  PointWidth] =   0.1 ; 
 
 Chart1.DataBind（）; 
 Chart1.Visible =  true ; 
 
   #endregion  

解决方案

< blockquote> ConnectionStrings：NewProductivityConnectionString ％>

SelectCommand = SELECT [User_Id]，[Profit]，[Total_TargetAchieved]，[Total_Balance] FROM [Customer_Productivity] ORDER BY [User_Id]

>
< / asp：SqlDataSource >

aspx.cs

   #region ChartProperties 
  Chart1.DataSourceID =   SqlDataSource1; 
 
 Chart1.Series [  Series1]。ChartType = SeriesChartType.Pie ; 
 Chart1.Series [  Series1] [  PieLabelStyle] =   outside ; 
 Chart1.Series [  Series1] [  PointWidth] =   0.1 ; 
 
 Chart1.DataBind（）; 
 Chart1.Visible =  true ; 
 
   #endregion  

<asp:Chart ID="Chart1" runat="server" DataSourceID="SqlDataSource1"

        ImageLocation="~/TempImages/ChartPic_#SEQ(300,3)"

        ImageStorageMode="UseImageLocation" >
      <%--  <Titles>
      <asp:Title Name="Title1" Text="Productivity"
         Alignment="TopCenter" Font="Verdana, 12pt, style=Bold">
      </asp:Title>
   </Titles>--%>
    <Series>
        <asp:Series Name="Series1" ChartType="Pie" XValueMember="User_Id" YValueMembers="Profit"   Color="Green"



            >
        </asp:Series>

              <%--  <asp:Series Name="Series2" ChartType="Pie"  XValueMember="User_Id" YValueMembers="Profit"  Color="Red"
            >
        </asp:Series>--%>
         <%-- <asp:Series Name="Series3" ChartType="Pie"  XValueMember="User_Id" YValueMembers="Total_Balance"
            >
        </asp:Series>--%>
       <%--   <asp:Series Name="Series2" ChartType="Pie"  Color="Red"
            >
        </asp:Series>
         <asp:Series Name="Series3" ChartType="Pie"  Color="Blue"

            >
        </asp:Series>--%>
    </Series>
    <ChartAreas>
        <asp:ChartArea Name="ChartArea1" >
           <%-- <AxisY Title="Percentage">
            </AxisY>
            <AxisX Title="Productivity">
            </AxisX>
            <AxisX2 Title="Achieved Target">
            </AxisX2>
            <AxisY2 Title="Balance Target">
            </AxisY2>--%>

            <Area3DStyle Enable3D="True" Rotation="90" Inclination="0"/>
        </asp:ChartArea>
    </ChartAreas>
</asp:Chart>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"

        ConnectionString="<%$ ConnectionStrings:NewProductivityConnectionString %>"

    SelectCommand="SELECT [User_Id],  [Profit], [Total_TargetAchieved], [Total_Balance] FROM [Customer_Productivity] ORDER BY [User_Id]"

                         >
    </asp:SqlDataSource>

aspx.cs

#region ChartProperties
   Chart1.DataSourceID = "SqlDataSource1";

   Chart1.Series["Series1"].ChartType = SeriesChartType.Pie;
   Chart1.Series["Series1"]["PieLabelStyle"] = "outside";
   Chart1.Series["Series1"]["PointWidth"] = "0.1";

   Chart1.DataBind();
   Chart1.Visible = true;

#endregion

解决方案

ConnectionStrings:NewProductivityConnectionString %>" SelectCommand="SELECT [User_Id], [Profit], [Total_TargetAchieved], [Total_Balance] FROM [Customer_Productivity] ORDER BY [User_Id]" > </asp:SqlDataSource>

aspx.cs

#region ChartProperties
   Chart1.DataSourceID = "SqlDataSource1";

   Chart1.Series["Series1"].ChartType = SeriesChartType.Pie;
   Chart1.Series["Series1"]["PieLabelStyle"] = "outside";
   Chart1.Series["Series1"]["PointWidth"] = "0.1";

   Chart1.DataBind();
   Chart1.Visible = true;

#endregion

这篇关于如何使用数据源显示饼图控件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！