<%@ Page Language="C#" Trace="false" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>

<script runat="server">
void Page_Load(Object sender, EventArgs e)
{
// Demonstrates manual drilldown with previews using microCharts and subValues.
//set global properties
Chart.Size = "650x400";
Chart.TempDirectory = "temp";
Chart.Debug = true;
Chart.ShadingEffectMode = ShadingEffectMode.Two;
Chart.Palette = new Color[] { Color.FromArgb(255, 99, 49), Color.FromArgb(0, 156, 255) };
Chart.TitleBox.Label.Text = "Sales";
Chart.TitleBox.Position = TitleBoxPosition.FullWithLegend;
Chart.TitleBox.Label.Font = new Font("Arial", 12, FontStyle.Bold);
Chart.TitleBox.Padding = 6;
Chart.TitleBox.Background.Color = Color.Chocolate;
Chart.TitleBox.Background.ShadingEffectMode = ShadingEffectMode.Background1;
Chart.TitleBox.Label.Color = Color.White;
Chart.LegendBox.DefaultEntry.LabelStyle.Color = Color.White;
Chart.LegendBox.DefaultEntry.LabelStyle.Font = new Font("Arial", 12, FontStyle.Bold);
Chart.LegendBox.Template = "%Value";
Chart.LegendBox.DefaultEntry.Value = "%YSum";
Chart.ChartArea.Line.Color = Color.FromArgb(236, 236, 236);
// Style/Format XAxis
Chart.XAxis.Label.Alignment = StringAlignment.Near;
Chart.YAxis.FormatString = "Currency";
Chart.XAxis.DefaultTick.Line.Length = 6;
Chart.XAxis.DefaultTick.Line.Width = 2;

// Element defaults.
Chart.DefaultElement.ShowValue = true;
Chart.DefaultElement.SmartLabel.Text = "<block fStyle='bold' fSize='12' >%YValue";
Chart.DefaultElement.SmartLabel.Alignment = LabelAlignment.OutsideTop;
Chart.DefaultElement.SmartLabel.AlignmentSecondary.Insert(0, LabelAlignment.Top);
Chart.DefaultElement.DefaultSubValue.Visible = false;

// Initial Drilldown position
dotnetCHARTING.TimeInterval curTimeInterval = TimeInterval.Quarters;

// Get QueryString values
string dateGrouping = HttpContext.Current.Request.QueryString["dategrouping"];
if (dateGrouping == null || dateGrouping == "")
dateGrouping = "Years";
else if (dateGrouping != null && dateGrouping != "")
curTimeInterval = (dotnetCHARTING.TimeInterval)Enum.Parse(typeof(dotnetCHARTING.TimeInterval), dateGrouping, true);

string startDateString = HttpContext.Current.Request.QueryString["startDate"];
DateTime startDate = new DateTime(2022, 1, 1, 0, 0, 0);
if (startDateString != null && startDateString != "")
startDate = DateTime.Parse(startDateString);

DateTime endDate = new DateTime(2022, 12, 31, 23, 59, 59);
Series ser;
Series groups;
SeriesCollection sc = null;
// Get Data and Create a chart based on the drilldown parameters.
switch (curTimeInterval)
{
case TimeInterval.Years:

// Setup a title
Chart.TitleBox.Label.Text = "<block fStyle='bold' fSize='11' hAlign='left'> Showing All<row><block fSize='7'> ";
Chart.XAxis.DefaultTick.Label.Text = "<block fStyle='bold' fSize='12'>%Name";

// Set up a tooltip preview of the drilldown data for each element.
Chart.DefaultSeries.DefaultElement.ToolTip = "<block fStyle='bold'>%Name<hr><Chart:Column values='%SubValueList' width='100' color='brown' height='60'><row><Chart:ScaleB values='Q1,Q4'>";

// Get live data based on date range.
ser = getLiveData(startDate, endDate);

// Break the elements down into years and populate sub values grouped by quarter.
groups = ser.SplitRegroupCalculate(TimeIntervalAdvanced.Year, TimeIntervalAdvanced.Year, Calculation.Sum, "yyyy", TimeIntervalAdvanced.Quarters);
sc = new SeriesCollection(groups);
if (sc != null && sc.Count > 0)
{
foreach (Element el in sc[0].Elements)
{
// Set drilldown URL for each element.
el.URL = "?dategrouping=quarters&startDate=" + startDate.ToString();
startDate = startDate.AddYears(1);
}
}
break;
case TimeInterval.Quarters:

// Setup a title and labels.
//Chart.Title = "<block fStyle='bold' fSize='11' hAlign='left' vAlign='bottom'> Year " + startDate.Year + "<row><block fSize='7'> ";
Chart.DefaultElement.SmartLabel.Text = "<block fStyle='bold' fSize='11' >%YValue";
Chart.XAxis.DefaultTick.Label.Text = "<block fStyle='bold' fSize='10'>%Name";

// Get live data based on date range.
ser = getLiveData(startDate, endDate);
// Break the elements down into quarters and populate sub values grouped by month.
groups = ser.SplitRegroupCalculate(TimeIntervalAdvanced.Year, TimeIntervalAdvanced.Quarters, Calculation.Sum, "", TimeIntervalAdvanced.Month);
sc = new SeriesCollection(groups);

if (sc != null && sc.Count > 0)
{
int i = 1;
foreach (Element el in sc[0].Elements)
{
// Set up a tooltip preview of the drilldown data for each element.
el.ToolTip = "<block fStyle='bold'>Q" + i.ToString() + " 2022<hr><Chart:Column values='%SubValueList' width='100' color='brown' height='60'><row><Chart:ScaleB values='" + startDate.ToString("MMM") + "," + startDate.AddMonths(2).ToString("MMM") + "'>";
// Set drilldown URL for each element.
el.URL = "?dategrouping=months&startDate=" + startDate.ToString();

el.Name = "(Q" + i.ToString() + ") " + startDate.ToString("MMM") + " - " + startDate.AddMonths(2).ToString("MMM");
startDate = startDate.AddMonths(3);
i++;
}
}
break;
case TimeInterval.Months:

// Setup a title and labels.
//Chart.Title = "<block fStyle='bold' fSize='11' hAlign='left' vAlign='center'> " + startDate.Year + "<row><block fSize='7'> ";
Chart.XAxis.DefaultTick.Label.Text = "<block fStyle='bold' fSize='10'>%Name";

// Get live data based on date range.
endDate = startDate.AddMonths(3).AddSeconds(-1);
ser = getLiveData(startDate, endDate);

// Break the elements down into Months and populate sub values grouped by days.
groups = ser.SplitRegroupCalculate(TimeIntervalAdvanced.Quarters, TimeIntervalAdvanced.Months, Calculation.Sum, "MMMM", TimeIntervalAdvanced.Days);
sc = new SeriesCollection(groups);

if (sc != null && sc.Count > 0)
{
foreach (Element el in sc[0].Elements)
{
// Set up a tooltip preview of the drilldown data for each element.
el.ToolTip = "<block fStyle='bold'>%Name<hr><Chart:SparkLine values='%SubValueList' height='30' colors='crimson,black,transparent' height='110'><row><Chart:ScaleB height='20' values='1," + DateTime.DaysInMonth(startDate.Year, startDate.Month) + "'>";
// Set drilldown URL for each element.
el.URL = "?dategrouping=days&startDate=" + startDate.ToString();
startDate = startDate.AddMonths(1);
}
}
break;
case TimeInterval.Days:

// Setup a title and labels.
Chart.XAxis.Label.Text = "<Chart:Spacer size='5,10'><row><block fStyle='bold' fSize='12'>" + startDate.ToString("MMMM") + " " + startDate.Year;
//Chart.Title = "<block fStyle='bold' fSize='11' hAlign='left'> " + startDate.ToString("MMMM") + " " + startDate.Year + "<row><block fSize='7'> ";

// Setup a time x axis scale.
Chart.XAxis.TimePadding = new TimeSpan(10, 0, 0);
Chart.XAxis.Scale = Scale.Time;
Chart.XAxis.DefaultTick.Line.Width = 1;
Chart.XAxis.DefaultTick.Line.Length = 3;
Chart.XAxis.FormatString = "d ";
Chart.XAxis.TimeInterval = TimeInterval.Day;

// Style the element appearance.
Chart.DefaultSeries.Type = SeriesType.AreaLine;
Chart.DefaultElement.Marker.Size = 10;
Chart.DefaultElement.Transparency = 20;
Chart.DefaultSeries.Line.Width = 9;
Chart.DefaultElement.ShowValue = false;

// Get live data based on date range.
endDate = startDate.AddMonths(1).AddSeconds(-1);
ser = getLiveData(startDate, endDate);

// Break the elements down into Days and populate sub values grouped by Hours.
groups = ser.SplitRegroupCalculate(TimeIntervalAdvanced.Months, TimeIntervalAdvanced.Days, Calculation.Sum, "d", TimeIntervalAdvanced.Hours);
sc = new SeriesCollection(groups);

if (sc != null && sc.Count > 0)
{
foreach (Element el in sc[0].Elements)
{
// Normalize the elements x date value.
el.XDateTime = new DateTime(el.XDateTime.Year, el.XDateTime.Month, el.XDateTime.Day);

// Set up a tooltip preview of the drilldown data for each element.
el.ToolTip = "<block fStyle='bold'>%Name<hr><Chart:Sparklines values='%SubValueList' width='100' colors='crimson,black,transparent' size='150x60'><row><Chart:ScaleB width='150' values=', 24 HRS,'>";
// Set drilldown URL for each element.
el.URL = "?dategrouping=hours&startDate=" + startDate.ToString();
startDate = startDate.AddDays(1);
}
}
break;
case TimeInterval.Hours:

// Setup a title and labels.
//Chart.Title = "<block fStyle='bold' fSize='11' hAlign='left'> " + startDate.ToString("D") + "<row><block fSize='7'> ";
Chart.XAxis.Label.Text = "<Chart:Spacer size='5,10'><row>Hours";

// Style the element appearance.
Chart.DefaultSeries.Type = SeriesType.AreaLine;
Chart.DefaultElement.Marker.Size = 10;
Chart.DefaultElement.Transparency = 20;
Chart.DefaultSeries.Line.Width = 9;
Chart.DefaultElement.SmartLabel.Line.Width = 3;
Chart.DefaultElement.SmartLabel.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
Chart.DefaultElement.SmartLabel.Line.AnchorCapScale = 2;
Chart.DefaultElement.SmartLabel.Line.Color = Color.FromArgb(150, 101, 39, 19);
Chart.DefaultSeries.EmptyElement.Mode = EmptyElementMode.TreatAsZero;
Chart.DefaultElement.SmartLabel.Padding = 4;

// Style the x axis.
Chart.XAxis.DefaultTick.Line.Width = 1;
Chart.XAxis.DefaultTick.Line.Length = 3;

// Get live data
DataEngine de = getDE(curTimeInterval, startDate);
endDate = startDate.AddDays(1);
endDate = endDate.AddSeconds(-1);
de.EndDate = endDate;
sc = de.GetSeries();

if (sc != null && sc.Count > 0)
{
foreach (Element el in sc[0].Elements)
{
// Dont label 0 value elements.
if (double.IsNaN(el.YValue))
el.SmartLabel.Text = "";
}
}
break;
}
Chart.SeriesCollection.Add(sc);
}

DataEngine getDE(TimeInterval dg, DateTime st)
{
DataEngine de = new DataEngine(ConfigurationManager.AppSettings["DNCConnectionString"], @"SELECT OrderDate,Sum(Quantity) FROM Orders WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE# GROUP BY Orders.OrderDate ORDER BY Orders.OrderDate");
de.ChartObject = Chart; // Necessary to view any errors the dataEngine may throw.
de.DateGrouping = dg;
de.StartDate = st;
return de;
}

Series getLiveData(DateTime start, DateTime end)
{
DataEngine de = new DataEngine(ConfigurationManager.AppSettings["DNCConnectionString"]);
de.ChartObject = Chart; // Necessary to view any errors the dataEngine may throw.
de.StartDate = start;
de.EndDate = end;
de.SqlStatement = "SELECT OrderDate,Total,Name,Quantity FROM Orders WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE# ";
de.DataFields = "xAxis=OrderDate,yAxis=Total,Quantity";
return de.GetSeries()[0];
}


</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Drill Down Manual Sample</title>
<style type="text/css">
</style>
</head>
<body>
<div align="center">
<dotnet:Chart ID="Chart" runat="server" />
</div>
</body>
</html>

<%@ Page Language="vb" Trace="false" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>

<script runat="server">
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
' Demonstrates manual drilldown with previews using microCharts and subValues.
'set global properties
Chart.Size = "650x400"
Chart.TempDirectory = "temp"
Chart.Debug = True
Chart.ShadingEffectMode = ShadingEffectMode.Two
Chart.Palette = New Color() { Color.FromArgb(255, 99, 49), Color.FromArgb(0, 156, 255) }
Chart.TitleBox.Label.Text = "Sales"
Chart.TitleBox.Position = TitleBoxPosition.FullWithLegend
Chart.TitleBox.Label.Font = New Font("Arial", 12, FontStyle.Bold)
Chart.TitleBox.Padding = 6
Chart.TitleBox.Background.Color = Color.Chocolate
Chart.TitleBox.Background.ShadingEffectMode = ShadingEffectMode.Background1
Chart.TitleBox.Label.Color = Color.White
Chart.LegendBox.DefaultEntry.LabelStyle.Color = Color.White
Chart.LegendBox.DefaultEntry.LabelStyle.Font = New Font("Arial", 12, FontStyle.Bold)
Chart.LegendBox.Template = "%Value"
Chart.LegendBox.DefaultEntry.Value = "%YSum"
Chart.ChartArea.Line.Color = Color.FromArgb(236, 236, 236)
' Style/Format XAxis
Chart.XAxis.Label.Alignment = StringAlignment.Near
Chart.YAxis.FormatString = "Currency"
Chart.XAxis.DefaultTick.Line.Length = 6
Chart.XAxis.DefaultTick.Line.Width = 2

' Element defaults.
Chart.DefaultElement.ShowValue = True
Chart.DefaultElement.SmartLabel.Text = "<block fStyle='bold' fSize='12' >%YValue"
Chart.DefaultElement.SmartLabel.Alignment = LabelAlignment.OutsideTop
Chart.DefaultElement.SmartLabel.AlignmentSecondary.Insert(0, LabelAlignment.Top)
Chart.DefaultElement.DefaultSubValue.Visible = False

' Initial Drilldown position
Dim curTimeInterval As dotnetCHARTING.TimeInterval = TimeInterval.Quarters

' Get QueryString values
Dim dateGrouping As String = HttpContext.Current.Request.QueryString("dategrouping")
If dateGrouping Is Nothing OrElse dateGrouping = "" Then
dateGrouping = "Years"
ElseIf Not dateGrouping Is Nothing AndAlso dateGrouping <> "" Then
curTimeInterval = CType(System.Enum.Parse(GetType(dotnetCHARTING.TimeInterval), dateGrouping, True), dotnetCHARTING.TimeInterval)
End If

Dim startDateString As String = HttpContext.Current.Request.QueryString("startDate")
Dim startDate As DateTime = New DateTime(2022, 1, 1, 0, 0, 0)
If Not startDateString Is Nothing AndAlso startDateString <> "" Then
startDate = DateTime.Parse(startDateString)
End If

Dim endDate As DateTime = New DateTime(2022, 12, 31, 23, 59, 59)
Dim ser As Series
Dim groups As Series
Dim sc As SeriesCollection = Nothing
' Get Data and Create a chart based on the drilldown parameters.
Select Case curTimeInterval
Case TimeInterval.Years

' Setup a title
Chart.TitleBox.Label.Text = "<block fStyle='bold' fSize='11' hAlign='left'> Showing All<row><block fSize='7'> "
Chart.XAxis.DefaultTick.Label.Text = "<block fStyle='bold' fSize='12'>%Name"

' Set up a tooltip preview of the drilldown data for each element.
Chart.DefaultSeries.DefaultElement.ToolTip = "<block fStyle='bold'>%Name<hr><Chart:Column values='%SubValueList' width='100' color='brown' height='60'><row><Chart:ScaleB values='Q1,Q4'>"

' Get live data based on date range.
ser = getLiveData(startDate, endDate)

' Break the elements down into years and populate sub values grouped by quarter.
groups = ser.SplitRegroupCalculate(TimeIntervalAdvanced.Year, TimeIntervalAdvanced.Year, Calculation.Sum, "yyyy", TimeIntervalAdvanced.Quarters)
sc = New SeriesCollection(groups)
If Not sc Is Nothing AndAlso sc.Count > 0 Then
For Each el As Element In sc(0).Elements
' Set drilldown URL for each element.
el.URL = "?dategrouping=quarters&startDate=" & startDate.ToString()
startDate = startDate.AddYears(1)
Next el
End If
Case TimeInterval.Quarters

' Setup a title and labels.
'Chart.Title = "<block fStyle='bold' fSize='11' hAlign='left' vAlign='bottom'> Year " + startDate.Year + "<row><block fSize='7'> ";
Chart.DefaultElement.SmartLabel.Text = "<block fStyle='bold' fSize='11' >%YValue"
Chart.XAxis.DefaultTick.Label.Text = "<block fStyle='bold' fSize='10'>%Name"

' Get live data based on date range.
ser = getLiveData(startDate, endDate)
' Break the elements down into quarters and populate sub values grouped by month.
groups = ser.SplitRegroupCalculate(TimeIntervalAdvanced.Year, TimeIntervalAdvanced.Quarters, Calculation.Sum, "", TimeIntervalAdvanced.Month)
sc = New SeriesCollection(groups)

If Not sc Is Nothing AndAlso sc.Count > 0 Then
Dim i As Integer = 1
For Each el As Element In sc(0).Elements
' Set up a tooltip preview of the drilldown data for each element.
el.ToolTip = "<block fStyle='bold'>Q" & i.ToString() & " 2022<hr><Chart:Column values='%SubValueList' width='100' color='brown' height='60'><row><Chart:ScaleB values='" & startDate.ToString("MMM") & "," & startDate.AddMonths(2).ToString("MMM") & "'>"
' Set drilldown URL for each element.
el.URL = "?dategrouping=months&startDate=" & startDate.ToString()

el.Name = "(Q" & i.ToString() & ") " & startDate.ToString("MMM") & " - " & startDate.AddMonths(2).ToString("MMM")
startDate = startDate.AddMonths(3)
i += 1
Next el
End If
Case TimeInterval.Months

' Setup a title and labels.
'Chart.Title = "<block fStyle='bold' fSize='11' hAlign='left' vAlign='center'> " + startDate.Year + "<row><block fSize='7'> ";
Chart.XAxis.DefaultTick.Label.Text = "<block fStyle='bold' fSize='10'>%Name"

' Get live data based on date range.
endDate = startDate.AddMonths(3).AddSeconds(-1)
ser = getLiveData(startDate, endDate)

' Break the elements down into Months and populate sub values grouped by days.
groups = ser.SplitRegroupCalculate(TimeIntervalAdvanced.Quarters, TimeIntervalAdvanced.Months, Calculation.Sum, "MMMM", TimeIntervalAdvanced.Days)
sc = New SeriesCollection(groups)

If Not sc Is Nothing AndAlso sc.Count > 0 Then
For Each el As Element In sc(0).Elements
' Set up a tooltip preview of the drilldown data for each element.
el.ToolTip = "<block fStyle='bold'>%Name<hr><Chart:SparkLine values='%SubValueList' height='30' colors='crimson,black,transparent' height='110'><row><Chart:ScaleB height='20' values='1," & DateTime.DaysInMonth(startDate.Year, startDate.Month) & "'>"
' Set drilldown URL for each element.
el.URL = "?dategrouping=days&startDate=" & startDate.ToString()
startDate = startDate.AddMonths(1)
Next el
End If
Case TimeInterval.Days

' Setup a title and labels.
Chart.XAxis.Label.Text = "<Chart:Spacer size='5,10'><row><block fStyle='bold' fSize='12'>" & startDate.ToString("MMMM") & " " & startDate.Year
'Chart.Title = "<block fStyle='bold' fSize='11' hAlign='left'> " + startDate.ToString("MMMM") + " " + startDate.Year + "<row><block fSize='7'> ";

' Setup a time x axis scale.
Chart.XAxis.TimePadding = New TimeSpan(10, 0, 0)
Chart.XAxis.Scale = Scale.Time
Chart.XAxis.DefaultTick.Line.Width = 1
Chart.XAxis.DefaultTick.Line.Length = 3
Chart.XAxis.FormatString = "d "
Chart.XAxis.TimeInterval = TimeInterval.Day

' Style the element appearance.
Chart.DefaultSeries.Type = SeriesType.AreaLine
Chart.DefaultElement.Marker.Size = 10
Chart.DefaultElement.Transparency = 20
Chart.DefaultSeries.Line.Width = 9
Chart.DefaultElement.ShowValue = False

' Get live data based on date range.
endDate = startDate.AddMonths(1).AddSeconds(-1)
ser = getLiveData(startDate, endDate)

' Break the elements down into Days and populate sub values grouped by Hours.
groups = ser.SplitRegroupCalculate(TimeIntervalAdvanced.Months, TimeIntervalAdvanced.Days, Calculation.Sum, "d", TimeIntervalAdvanced.Hours)
sc = New SeriesCollection(groups)

If Not sc Is Nothing AndAlso sc.Count > 0 Then
For Each el As Element In sc(0).Elements
' Normalize the elements x date value.
el.XDateTime = New DateTime(el.XDateTime.Year, el.XDateTime.Month, el.XDateTime.Day)

' Set up a tooltip preview of the drilldown data for each element.
el.ToolTip = "<block fStyle='bold'>%Name<hr><Chart:Sparklines values='%SubValueList' width='100' colors='crimson,black,transparent' size='150x60'><row><Chart:ScaleB width='150' values=', 24 HRS,'>"
' Set drilldown URL for each element.
el.URL = "?dategrouping=hours&startDate=" & startDate.ToString()
startDate = startDate.AddDays(1)
Next el
End If
Case TimeInterval.Hours

' Setup a title and labels.
'Chart.Title = "<block fStyle='bold' fSize='11' hAlign='left'> " + startDate.ToString("D") + "<row><block fSize='7'> ";
Chart.XAxis.Label.Text = "<Chart:Spacer size='5,10'><row>Hours"

' Style the element appearance.
Chart.DefaultSeries.Type = SeriesType.AreaLine
Chart.DefaultElement.Marker.Size = 10
Chart.DefaultElement.Transparency = 20
Chart.DefaultSeries.Line.Width = 9
Chart.DefaultElement.SmartLabel.Line.Width = 3
Chart.DefaultElement.SmartLabel.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor
Chart.DefaultElement.SmartLabel.Line.AnchorCapScale = 2
Chart.DefaultElement.SmartLabel.Line.Color = Color.FromArgb(150, 101, 39, 19)
Chart.DefaultSeries.EmptyElement.Mode = EmptyElementMode.TreatAsZero
Chart.DefaultElement.SmartLabel.Padding = 4

' Style the x axis.
Chart.XAxis.DefaultTick.Line.Width = 1
Chart.XAxis.DefaultTick.Line.Length = 3

' Get live data
Dim de As DataEngine = getDE(curTimeInterval, startDate)
endDate = startDate.AddDays(1)
endDate = endDate.AddSeconds(-1)
de.EndDate = endDate
sc = de.GetSeries()

If Not sc Is Nothing AndAlso sc.Count > 0 Then
For Each el As Element In sc(0).Elements
' Dont label 0 value elements.
If Double.IsNaN(el.YValue) Then
el.SmartLabel.Text = ""
End If
Next el
End If
End Select
Chart.SeriesCollection.Add(sc)
End Sub

Function getDE(ByVal dg As TimeInterval, ByVal st As DateTime) As DataEngine
Dim de As DataEngine = New DataEngine(ConfigurationManager.AppSettings("DNCConnectionString"), "SELECT OrderDate,Sum(Quantity) FROM Orders WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE# GROUP BY Orders.OrderDate ORDER BY Orders.OrderDate")
de.ChartObject = Chart ' Necessary to view any errors the dataEngine may throw.
de.DateGrouping = dg
de.StartDate = st
Return de
End Function

Function getLiveData(ByVal start As DateTime, ByVal [end] As DateTime) As Series
Dim de As DataEngine = New DataEngine(ConfigurationManager.AppSettings("DNCConnectionString"))
de.ChartObject = Chart ' Necessary to view any errors the dataEngine may throw.
de.StartDate = start
de.EndDate = [end]
de.SqlStatement = "SELECT OrderDate,Total,Name,Quantity FROM Orders WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE# "
de.DataFields = "xAxis=OrderDate,yAxis=Total,Quantity"
Return de.GetSeries()(0)
End Function


</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Drill Down Manual Sample</title>
<style type="text/css">
</style>
</head>
<body>
<div align="center">
<dotnet:Chart ID="Chart" runat="server" />
</div>
</body>
</html>