需要有关MS Chart控件和组的帮助 [英] Need help with MS Chart control and group
本文介绍了需要有关MS Chart控件和组的帮助的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我的脚本在X轴上显示时间，在Y轴上显示Day_of_week.我的脚本在day_of_week中显示多个列，即星期一有5个5x2(start_time和end_time)列，并且每个列都以Monday作为Y轴标签.我想将这些列分组以在Y轴标签中显示一个day_of_week名称.
有人可以帮忙吗.
这是我的代码.
My script displays Time in X axis and Day_of_week in the Y axis. My script displays multiple columns for each day_of_week i.e. there are five 5x2 (start_time and end_time) columns for Monday and each column has Monday as the Y axis label. I would like to group those columns to display one day_of_week name in the Y axis label.
Could someone please help.
Here is my code.
select cycle,day_of_week, start_time, end_time from df_qfs_time_logs order by day_of_week
cycle day_of_week start_time end_time
-------------------------------- ------------------------ ---------- ---------
EARLY MORNING FRIDAY 09:03:00 09:18:00
MORNING FRIDAY 10:58:00 11:14:00
NOON FRIDAY 12:38:00 12:52:00
AFTERNOON FRIDAY 14:48:00 15:03:00
LATE AFTERNOON FRIDAY 16:47:00 17:03:00
END OF DAY FRIDAY 20:45:00 21:10:00
END OF DAY MONDAY 23:35:00 23:59:00
LATE AFTERNOON MONDAY 16:48:00 17:04:00
AFTERNOON MONDAY 14:53:00 15:08:00
NOON MONDAY 12:43:00 12:58:00
MORNING MONDAY 10:38:00 10:53:00
EARLY MORNING MONDAY 07:58:00 08:12:00
EARLY MORNING THURSDAY 07:48:00 08:00:00
MORNING THURSDAY 10:33:00 10:46:00
NOON THURSDAY 12:32:00 12:46:00
AFTERNOON THURSDAY 14:37:00 14:51:00
LATE AFTERNOON THURSDAY 16:37:00 16:52:00
END OF DAY THURSDAY 21:00:00 21:23:00
END OF DAY TUESDAY 21:00:00 21:23:00
EARLY MORNING TUESDAY 07:53:00 08:07:00
MORNING TUESDAY 10:43:00 10:57:00
NOON TUESDAY 12:48:00 13:02:00
AFTERNOON TUESDAY 14:53:00 15:07:00
LATE AFTERNOON TUESDAY 16:47:00 17:03:00
EARLY MORNING WEDNESDAY 07:53:00 08:07:00
MORNING WEDNESDAY 10:43:00 10:57:00
AFTERNOON WEDNESDAY 14:53:00 15:07:00
NOON WEDNESDAY 12:39:00 12:53:00
LATE AFTERNOON WEDNESDAY 16:47:00 17:03:00
END OF DAY WEDNESDAY 21:00:00 21:25:00
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:Chart ID="Chart1" runat="server">
<legends>
<asp:Legend Name="legend" />
</legends>
<series>
<asp:Series Name="Series1" YValueType="Time" />
<asp:Series Name="Series2" YValueType="Time" />
</series>
<chartareas>
<asp:ChartArea Name="ChartArea1">
</chartareas>
<asp:Button ID="btnChart" runat="server" Text="Click" OnClick="btnChart_onclick" />
<asp:Label ID="LblResponse" runat="server" />
Protected Sub loadchartdata()
Dim strcmd As String = "select RTRIM(day_of_week) as DAYS,RTRIM(convert(time,start_delivery)) as START, RTRIM(convert(time,end_delivery))as ENDT from df_delivery_time order by day_of_week, start_delivery"
Dim da As New SqlDataAdapter(strcmd, dbconn)
Dim table As New DataTable()
da.Fill(table)
Dim dv As DataView = table.DefaultView
Chart1.Series("Series1").Points.DataBindXY(dv, "cycle", dv, "START")
Chart1.Series("Series2").Points.DataBindXY(dv, "cycle", dv, "ENDT")
Chart1.Series("Series1").ChartType = SeriesChartType.Column
Chart1.Series("Series2").ChartType = SeriesChartType.Column
Chart1.Series(0).XValueType = DataVisualization.Charting.ChartValueType.DateTime
End Sub
推荐答案
看看并尝试解决，希望对您有所帮助:
带有ASP.NET 3.5的Microsoft图表–第1部分
带有ASP.NET 3.5的Microsoft图表–第2部分
Take a look and try to resolve, hope it will help you out:
Microsoft Chart with ASP.NET 3.5 – Part 1
Microsoft Chart with ASP.NET 3.5 – Part 2
我能够解决我的问题.
Thx
I was able to resolve my issue.
Thx
这篇关于需要有关MS Chart控件和组的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
