Chart with an axis of type Time

See more:

C#

ASP.NET

Hi,

I am trying to display a chart with the x axis as the Time and the y axis as the Temperature. The data is retrieved from the SQL Server. On the XValueMember I put Time and YValueMember as Temperature. However, I am getting this error:

'Series data points do not support values of type System.TimeSpan only values of these types can be used: Double, Decimal, Single, int, long, uint, ulong, String, DateTime, short, ushort.'

I tried to change the data type to String or Time with no luck.

<asp:Chart ID="Chart1" runat="server" DataSourceID="ChartData"
    ImageStorageMode="UseImageLocation">
    <series>
        <asp:Series Name="Series1" ChartType="Line" XValueMember="Time"
            YValueMembers="Temperature">

    </series>
    <chartareas>
        <asp:ChartArea Name="ChartArea1">

    </chartareas>

    <asp:SqlDataSource ID="ChartData" runat="server"
        ConnectionString="<%$ ConnectionStrings:myConnectionString %>"
        SelectCommand="SELECT [Time], [Temperature] FROM [Data]">