Sorting Date field in GDBG

[Atith Pagdi]

I have a field in the GDBG that comes in as a date (dd mmm yyyy) without hyphens. When I click the header column tab to sort, the date is treated as a string and sorted. How can I actually sort by date.

Thanks,
Atith

[Administrator]

The GridDataBoundGrid really does not do any sorting. It delegates the sorting to the IBindingList datasource. So, if you are using a DataTable as the grid''s datasource, it is the dataTable.DefaultView that is doing the sorting. So, if you are seeing the dates being sorted like strings, it suggests that the type of this DataColumn in the DataTable is a string object and not a DateTime object. If this is the case, the simplest way to handle the problem would be to store the value as a DataTime and set GridBoundColumn.StyleInfo.Format to tell the grid to display the DateTime value with a particular format.

If this is not possible, then you would have to do some work to work around the string type being set in the datasource. Here is a forum thread that discusses a couple of ways to do this and has sample information. But changing the DataColumn type will be the simplest solution.

[Administrator]

Could you please give the link to the discussion thread you mentioned above.

Thanks,
Bits.

[Administrator]

Sorry.

http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=21940

[Atith Pagdi]

Clay,

I''m getting this date field from the DB, but the GDBG shows it in the format mm/dd/yyyy while I want the format dd-mmm-yyyy. How can I achieve this?

Thanks.

[Administrator]

You set the GridBoundColumn.StyleInfo.Format to specify the format you want to see, and you make sure GridBoundColumn.StyleInfo.CellValueType is being set to typeof(DateTime). It should be if the column in your datatable is DateTime.

[Atith Pagdi]

Any code sample for this? I do not have grid bound columns.

[Administrator]

grid.Binder.InternalColumns["someColumnName"].StyleInfo.Format = "yyyy-MM-dd";

See this KB. http://www.syncfusion.com/support/kb/grid/Default.aspx?ToDo=view&questId=85