How to specify the grid to display both date and time instead of just date? | Infragistics Forums

State See Verified Answer
Replies 4 replies
Subscribers 6 subscribers
Views 1698471 views
Users 0 members are here

UltraGrid

444

How to specify the grid to display both date and time instead of just date?

Sindhura posted over 16 years ago

I add columns and rows in the grid RUNTIME. Even if my column is of type DateTime and the value has both date and time, the grid displays only date, not time. I understand that there is a property to set that. I tried doing something like

grid1.DisplayLayout.Bands(0).Columns("Col1").Format = "mm/dd/yy hh:mm:ss"

But the steps I follow to add data to grid are are like

- Add data(rows and Columns) to a data table (m_pDataTable) at runtime from the database

- grid1.DataSource = m_pDataTable

- Set the format for required column

It works fine. But looks like its messing up the date that is to be displayed. From database to a dataRow the value when added is

" #11/27/2007 11:05:34 AM# "

And then I the steps I did was

m_pDataTable.Rows.Add(m_pDataRow)

grid1.DataSource = m_pDataTable
grid1.DisplayLayout.Bands(0).Columns("Col1").Format = "mm/dd/yy hh:mm:ss"

grid1.DisplayLayout.Override.AllowUpdate = DefaultableBoolean.False

End Sub

And now I see the value displayed at output as ' 05/27/07 11:05:34 '.

In simple terms, before the piece of code I wrote the m_pDatRow("Col1") = #11/27/2007 11:05:34 AM#

and after the code the value is 05/27/07 11:05:34

I couldn't understand why this is happening

Thanks in advance, Sindhu

Parents

No Data

Reply

37774

Matt Snyder posted over 16 years ago

Sindhu,
So the grid is changing the value from November to May? Do you have a MaxValue on the column that would be preventing this? I can't say that I've seen this behavior before.
-Matt
Cancel
Reply

Cancel

Children

444

Sindhura posted over 16 years ago in reply to Matt Snyder

I wrote a sample program.. which has only this code.
Imports Infragistics.Win

Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim m_pDataTable As DataTable
        Dim Col1 As DataColumn
        Dim Col2 As DataColumn
        Dim Row1 As DataRow

        m_pDataTable = New DataTable()

        Col1 = New DataColumn("Name", GetType(System.String))
        m_pDataTable.Columns.Add(Col1)
        Col2 = New DataColumn("Date", GetType(System.DateTime))
        m_pDataTable.Columns.Add(Col2)

        Row1 = m_pDataTable.NewRow()
        Row1("Name") = "Test"
        Row1("Date") = System.DateTime.Now
        m_pDataTable.Rows.Add(Row1)

        Me.UltraGrid1.DataSource = m_pDataTable
        UltraGrid1.DisplayLayout.Bands(0).Columns("Date").Format = "mm/dd/yy hh:mm:ss" ' .
      UltraGrid1.DisplayLayout.Override.AllowUpdate = Infragistics.Win.DefaultableBoolean.False
    End Sub
End Class

I didnt write anything apart of it. This code behaves differently every time I run it.
When the date is 07/01/02008
the outputs in Date column was 31/01/08 02:32:32 once
36/01/08 02:36:35
and next time it gave 38/01/08 02:38:55. It gave different outputs everytime. I personally did not set any property. I am not sure if there is any default property or some that is set and is messing up like this??
Thanks,
Sindhu
Cancel
Reply

Cancel