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]

Thank you for your help,
This worked very well
Richard