Change Autogenerated column from DateTime to short date

[Jeff]

I am using a stored procedure to get a DateTable of ID (int) start date and end date (both Date Time).  The columns are autogenerated.  I want both date time fields to have just the date.  I saw in the ItemDataBound to select the columns that have DateTime, but I do not see how to change the values to just date.  I am using C#

(if (col,DateType == typeof(DateTime))

{

    item(col.?

}

Thanks

[Viktor Tachev]

Hi Jeff,

You can customize the format of the date in the ColumnCreated event for the grid. The event is raised for every column. You can check if the currently created column is a GridDateTimeColumn and set the DataFormatString property for it.

protected void RadGrid1_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
{
    if (e.Column is GridDateTimeColumn)
    {
        (e.Column as GridDateTimeColumn).DataFormatString = "{0:dd/MM/yyyy}";
    }
}

For additional information on using AutoGenerated columns in the grid you would find the following article interesting.

• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/columns/working-with-autogenerated-columns#customizing-auto-generated-columns

Regards,
Viktor Tachev
Telerik