I have a DataTable with a Time column. What format or type should I make this column?
I tried playing with using the DateTime type which does work, but the date is stored as well in the form of (1/1/1001 hh:mm:ss) which I don't want, just the time.
I saw that there was a an AxisFormat.Time and AxisFormat.DateTime. What is the difference between these two types and how do you use the AxisFormat.Time with a datasource? I tried to find the answer on the forums, but was unable to.
I also tried to create the column as a DateTime, and pass the time using ToOATime(). On the chart I set it up this way:
_chartCtrl.AxisX.LabelsFormat.Format = AxisFormat.Time;
_chartCtrl.AxisX.LabelsFormat.CustomFormat = "mm:ss";
But instead of showing mm:ss it doesn't seem to recognize the passed value and just prints out the double value of the OATime.
Thanks,
James