DataEngine de = new DataEngine(); de.ConnectionString = ConfigurationManager.AppSettings["DNCConnectionString"]; de.StartDate=new DateTime (2022,1,1,0,0,0); de.EndDate = new DateTime (2022,12,30,23,59,59); de.DateGrouping = TimeInterval.Year; de.SplitByLimit = "2";
// Chart 1 de.SqlStatement= @"SELECT OrderDate,Total,Name FROM Orders WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE# ORDER BY Orders.OrderDate";
Dim de As DataEngine = New DataEngine() de.ConnectionString = ConfigurationManager.AppSettings("DNCConnectionString") de.StartDate = New DateTime (2022,1,1,0,0,0) de.EndDate = New DateTime (2022,12,30,23,59,59) de.DateGrouping = TimeInterval.Year de.SplitByLimit = "2"
' Chart 1 de.SqlStatement= "SELECT OrderDate,Total,Name FROM Orders WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE# ORDER BY Orders.OrderDate"
Dim sc As SeriesCollection = de.GetSeries() Chart.SeriesCollection.Add(sc(0))
' Chart 2 Dim ca2 As ChartArea = New ChartArea()
Dim newX As Axis = New Axis() newX.Label.Text = sc(0).Name & "'s Sales" sc(1).XAxis = newX
Previous