I am trying to create a chart using data from a SQL table and am not geting the result I want.
Data in the SQL table
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
----aspx page
<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" IsValueShownAsLabel="true" ChartType="StackedColumn" Palette="Chocolate" />
<asp:Series Name="Series2" IsValueShownAsLabel="true" ChartType="StackedColumn" Palette="Chocolate" />
</Series>
<ChartAreas>
<asp:ChartArea Name="ChartArea1">
</asp:ChartArea>
</ChartAreas>
</asp:Chart>
<asp:Button ID="btnChart" runat="server" Text="Click" OnClick="btnChart_onclick" />
<asp:Label ID="LblResponse" runat="server" />
</asp:Content>
--Vb Code Behind
Protected Sub btnChart_onclick(ByVal sender As Object, ByVal e As EventArgs)
Try
Dim strcmd As String = "select cycle,day_of_week, start_time, end_time from df_qfs_time_logs order by day_of_week"
Dim sqlcmd As New SqlCommand(strcmd, dbconn)
Dim da As New SqlDataAdapter
da.SelectCommand = sqlcmd
Dim ds As New DataSet()
da.Fill(ds)
For Each row As DataRow In ds.Tables(0).Rows
Dim seriesName As String = Trim(row("cycle").ToString())
Chart1.Series.Add(seriesName)
Chart1.Series(seriesName).ChartType = SeriesChartType.StackedColumn
Chart1.Series(seriesName).BorderWidth = 2
For colIndex As Integer = 1 To ds.Tables(0).Columns.Count - 1
Dim columnName As String = ds.Tables(0).Columns(colIndex).ColumnName
Dim YVal As String = CStr(row(columnName))
Chart1.Series(seriesName).Points.AddXY(columnName, YVal)
Next
Next
Chart1.DataSource = ds.Tables(0)
Chart1.DataBind()
Catch ex As Exception
LblResponse.Text = "does not work"
End Try
End Sub
This is the output.
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
----------------------------------------
Day of week Start_Time End_time
Could some one please help.
[edit]Code block added to VB code - preserve the formatting - OriginalGriff[/edit]