none
Datatable column has only date where as Dataset XMl has both Date and time. RRS feed

  • Question

  • Hi,
     I am sorry if am unable to explain my problem clearly. But this is an over view of the issue am facing.
    - Data is retreived from the Db using MDX query.
    - Column I am concened about is the date time column.
    - when I check for the Dataset xml I see both Dateand time in it. 
    <NewDataSet>
      <CELLSET>
        <DateMinute>2007-12-01T17:15:00.0000000-08:00</DateMinute>

    - But when i see the the column value in the tabel (dataSet.tables[0]), the column has only Date in it. The time part is getting truncated.
    dataSet.tables[0].Rows[0]["DateMinute"].Tostring() is only 12/01/2007. No time part available.
    - I am further using this data table data to render in Report server.

    My problem is, how to avoid Time part getting truncated from the column.


    Please help me if any of you have any solution for this.

    Is this any setting that is done on serialisation of data table. If so how can this be avaoided.
    Rashmi
    Thursday, October 23, 2008 2:47 PM

Answers