[Solved] Change Auto-Generated Column ColumnType

[Neil]

I have a grid being bound to a datasource (which comes from a stored procedure) - when a column contains a datetime, such as 01/01/2000 00:00:00, the column type correctly becomes a GridDateTimeColumn (and my filter changes to a DatePicker).  However, when my data is in the format of 01/01/2000, it acts as a normal GridBoundColumn and I get the textbox for a filter.  How can I (programmatically) change the column type?  ColumnType is read-only, and since all of my grids are auto-generated, I am having trouble with this.  

I need to have a DatePicker in the filter is all.  I have seen column.FilterTemplate, but am not sure if this is a solution.

Thanks.

[Jayesh Goyani]

Hello,

RadGrid will automatically set columnType based on DataType.

http://www.telerik.com/help/aspnet-ajax/grid-customizing-autogenerated-columns.html


Please set datatype in your StoredProcuder.

You can achieve this thing by using Cast and Convert in Sql.

Thanks,
Jayesh Goyani

[Shinu]

Hi,

With reference to this forum thread, The auto-generated columns feature of RadGrid does not support changing the type of the columns.

Thanks,
Shinu