[Solved] Sorting a column with value calculated in ItemDataBound

[Stuart]

Hi,

I've got a column which dispalys the number of days an item has been in stock. I've implemented this as as GridTemplateColumn with a label for the ItemTemplate. I couldn't use a GridCalculatedColumn as this does not work with dates. The code in the ItemDataBound event is as follows:

 

if (e.Item is GridDataItem)

 

{

 

GridDataItem dataItem = e.Item as GridDataItem;

 

 

Label label = (Label)dataItem.FindControl("DaysInStock");

 

label.Text =

DateTime.Now.Subtract(DateTime.Parse(dataItem["DateIntoStock"].Text)).Days.ToString();

 

}

I also want to be able to sort on this column. How can I implement this?

Thanks,

Stuart

[Yavor]

Hello Stuart,

Thank you for contacting us and for your question.
Basically, the grid control sorts and filters its data on the database level. That is, if you alter the values in some other event, for example ItemDataBound, or PreRender, the control cannot be aware of this change, until it is persisted in the database.

Another option in this case would be to use a calculated column. This is demonstrated in the code sample attached to this message. Please, take a look at it and let me know how it goes.

Regards,

Yavor
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.