DateColumn Doesn't sort

[Santhosh Kumar]

I have a date column which is in MM/dd/yyyy format. This doesnt sort ascending or descending for all the grids in my application. I am sure what I have done is right. Still it doesnt sort right when I click on header. Please help. One way of doing it is after binding the data source by adding

 

radgvSixMonthPurchases.Columns[

"transactionDate"].FormatString = "{0:MM/dd/yyyy}";

 

 

and othe way is through cell formatting like:

 

 

private void radgvSixMonthPurchases_CellFormatting(object sender, Telerik.WinControls.UI.CellFormattingEventArgs e){
if (e.CellElement is GridDataCellElement)
{
Font font = new Font("Tahoma", 6.75F);
e.CellElement.Font = font;
if (((GridViewDataColumn)e.CellElement.ColumnInfo).FieldName == "transactionDate")
{
if (!e.CellElement.Text.StartsWith("0:"))
{
DateTime temp = DateTime.Parse(e.CellElement.Text);
e.CellElement.Text = temp.ToString("MM/dd/yyyy");
}
Font newfont = new Font("Tahoma", 7, FontStyle.Underline);
e.CellElement.Font = newfont;
e.CellElement.ForeColor = Color.Blue;
}
}

 

[Nick]

Hello Santhosh Kumar,

Thank you for contacting us.

I cannot see the reason why sorting is not working correctly. The type of the date columns should be DateTime in order for sorting to work correctly on them which I guess is correct in your application. Can you send me a sample application demonstrating the issue? You can do so in a support ticket.

The sample code you sent to me is about formatting which is independent of sorting. Sorting dates does not depends on formatting, but on which date is earlier/later than other dates.

I am looking forward to help you on that.

 
All the best,
Nick
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.