I get my data in a dataset which looks something like the following:
CustomerID ReturnDate AvgTime
123 11/2/09 1
123 11/4/09 3
144 11/2/09 2
144 11/3/09 1
I want the ultra chart to show two series one for customer 123 and one for customer 144 and my X-Axis will be ReturnDate
and my Y-Axis will be AvgTime.
Any ideas?
** I am using a line chart
Thank you in advance:)
So I passed the previous problem but now I have a problem with null datapoints, I have the following code:
Me.UltraChart1.LineChart.NullHandling = Infragistics.UltraChart.Shared.Styles.NullHandling.DontPlot
If IsDBNull(dt1.Rows(i)("DT")) Then
series.Points.Add(New NumericDataPoint(dt1.Rows(i)("DT"), "A", True))
Else
series.Points.Add(New NumericDataPoint(dt1.Rows(i)("DT"), "B", False))
End If
Sometimes the value for dt1.Rows(i)("DT") is null and I was trying to not plot nulls, however the previous code throws the error “Conversion from ‘DBNull’ to ‘Double’ is not valid” . What I can do to resolve the problem?
Thanks!
Hi,
Are you still having an issue with this? I don't believe you can use NumericDataPoints to convey the null values in that manner. You may need bind against a DataTable and use null instead of DBNull which the chart rejects.
-Graham