如何将X轴和Y轴值从代码后面设置为Chart控件 [英] How to set X axis and Y axis value from code behind to Chart control

问题描述

我想在asp.net c＃

I want to set X-axis and Y-axis values from code behind to chart control in asp.net c#

推荐答案

中设置X轴和Y轴值从代码隐藏到图表控件后面这里设置你的X轴和Y轴值设置为数组并绑定图表控件

Here set your X-axis and Y-axis value set to array and bind chart control

int[] yValues = {10,25,100}; // Here y values is related to display three month values
 string[] xValues = {"one","two","three"};
 Chart1.Series["Series1"].Points.DataBindXY(xValues, yValues);

将此添加到前端

Add this to front end

<asp:Chart ID="Chart1" runat="server" Height="200px">
       <Series>
           <asp:Series Name="Series1" XValueMember="MonthName" YValueMembers="Mavailable">
           </asp:Series>
       </Series>
       <ChartAreas>
           <asp:ChartArea Name="ChartArea1">
           </asp:ChartArea>
       </ChartAreas>
   </asp:Chart>

参考以下链接： -



http://blogs.msdn.com/b/alexgor/archive/2009/02/21/data-binding-ms-chart-con trol.aspx [ ^ ]

http://www.aspsnippets.com/Articles/ASPNet-AJAX-Bar-Chart-Control-Populate-from-Database-example.aspx [ ^ ]

refer below links:-

http://blogs.msdn.com/b/alexgor/archive/2009/02/21/data-binding-ms-chart-control.aspx[^]
http://www.aspsnippets.com/Articles/ASPNet-AJAX-Bar-Chart-Control-Populate-from-Database-example.aspx[^]

试试这个代码....

Try this code....

connect.Close();

connect.Open();
DataSet ds = new DataSet();

string query = "SELECT SUM(Quantity) as Quan,Itemname   FROM Orderdetails where hotelid='" + hotelid + "'    and datetime between '" + inputField.Text + "' and '" + inputField1.Text + "'  GROUP BY  Itemname,Quantity";
SqlCommand cmd = new SqlCommand(query, connect);

cmd.ExecuteNonQuery();
connect.Close();
SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds, "Orderdetails");
if (ds.Tables["Orderdetails"].Rows.Count > 1)
{
    Chart1.DataSource = ds.Tables["Orderdetails"];
    Chart1.ChartAreas[0].AxisX.Title = "Itemname";
    Chart1.ChartAreas[0].AxisY.Title = "Quantity";
    Chart1.ChartAreas["ChartArea1"].AxisX.IsLabelAutoFit = true;

    Chart1.ChartAreas["ChartArea1"].AxisX.Interval = 1;
    Chart1.ChartAreas["ChartArea1"].AxisY.IsLabelAutoFit = true;

    Chart1.ChartAreas["ChartArea1"].AxisY.Interval = 1;
    Chart1.ChartAreas[0].AxisX.LabelStyle.Format = "Itemname";
    Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "Quan";
    Chart1.ChartAreas[0].AxisX.IntervalOffset = 1;
    Chart1.ChartAreas[0].AxisY.IntervalOffset = 1;
}

Chart1.Series["Count"].XValueMember = "Itemname";

Chart1.Series["Count"].YValueMembers = "Quan";

这篇关于如何将X轴和Y轴值从代码后面设置为Chart控件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！