Formatting date in DataGrid

[Richard Keller]

How can I format a date or number in a data grid.
If I want to show a date as "dd/MM/yy" and the column is
set up as a DateTime datatype, how can I have the date
show up in the format I want?

[Ken Tucker [MVP]]

Hi,

Dim cm As CurrencyManager = CType(Me.BindingContext(dvClient),
CurrencyManager)

Dim pd As PropertyDescriptor = cm.GetItemProperties()("AppointDate")

Dim colDate As New DataGridTextBoxColumn(pd, "dd/MM/yy")

With colDate

..MappingName = "ApointDate"

..HeaderText = "Date"

..Width = 100

End With

Ken

------------------

"Richard Keller" <an*******@discussions.microsoft.com> wrote in message
news:90****************************@phx.gbl...

How can I format a date or number in a data grid.
If I want to show a date as "dd/MM/yy" and the column is
set up as a DateTime datatype, how can I have the date
show up in the format I want?

[Richard Keller]

Thank you for your help,
This worked very well
Richard

-----Original Message-----
Hi,

Dim cm As CurrencyManager = CType(Me.BindingContext (dvClient),CurrencyManager)

Dim pd As PropertyDescriptor = cm.GetItemProperties() ("AppointDate")
Dim colDate As New DataGridTextBoxColumn(pd, "dd/MM/yy")

With colDate

..MappingName = "ApointDate"

..HeaderText = "Date"

..Width = 100

End With

Ken

------------------

"Richard Keller" <an*******@discussions.microsoft.com> wrote in messagenews:90****************************@phx.gbl...

How can I format a date or number in a data grid.
If I want to show a date as "dd/MM/yy" and the column is set up as a DateTime datatype, how can I have the date
show up in the format I want?

.