Dateformat - autogenerated columns

[wnl]

Hi,
I'm using RadGrid with autogenerated columns. In some column I have DateTime value ( e.g. sql - select id, startDate, price from table) . How can I set the dateformat of this columns in grid which have these values?

[Shinu]

Hi Jaromin,

I tried setting the DateFormatString from code in ColumnCreated event and it is working fine for me. Give a try with this approach.

CS:

    protected void RadGrid1_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
    {
        if (e.Column is GridBoundColumn && e.Column.UniqueName == "StartDate")
        {
            GridBoundColumn column = (GridBoundColumn)e.Column;
            column.DataFormatString = "{0:d}";
        }
    }

Regards,
Shinu.

[wnl]

Ok, but is that any way to make this without specifying"Column.UniqueName"?

[Amit]

Try This.... You will get what you need
If e.Column.DataTypeName = "System.DateTime" Then

            Dim column As GridBoundColumn = DirectCast(e.Column, GridBoundColumn)

            column.DataFormatString = "{0:m}"

End If

[Amit]

Try This.... You will get what you need

If e.Column.DataTypeName = "System.DateTime" Then

            Dim column As GridBoundColumn = DirectCast(e.Column, GridBoundColumn)

            column.DataFormatString = "{0:m}"

End If