Database Binding with DateTimeScale


Author
Message
Bhumi Patel
Bhumi Patel
Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)
Group: Forum Members
Posts: 33, Visits: 1
Hi All,

I am experiencing some difficulties while binding data from database with DateTimeScale. I am retrieving 2 different lists from database: list of DateTime(with 5 min interval) and list of values. I am not sure how can I relate the datetime with the value. Please review my code below:

DateTime StartDate = DateTimeList[0];
DateTime EndDate = DateTimeList[DateTimeList.Count - 1];

TimeSpan span = EndDate - StartDate;
span = new TimeSpan(span.Ticks / 30);

if (span.Ticks > 0)
{
while (StartDate < EndDate)
{
StartDate += span;
lineSeries.XValues.Add(StartDate);
lineSeries.Values.Add(?);
count++;
}
}
Reply
Bhumi Patel
Bhumi Patel
Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)Forum Member (34 reputation)
Group: Forum Members
Posts: 33, Visits: 1
Thank you Nevron Team for your quick reply.

But my concern is with YValue. How can I map the X-axis DateTime with Y-axis value?? (lineSeries.Values.Add(?)) Because DateTimeScale handles the XValues using TimeSpan.

Please review attached chart image. It displays 500 value for 12:00 AM. But in my database, the actual value at 12:00 AM is not 500. The X-values and Y-values are not mapped properly.

Thanks in advance!!
Attachments
TrendingChart.png (66 views, 47.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search