Filtering on Hyperlink Column

[Siddharth]

Hi,

I am trying to Filter on hyperlink column using AllowFilteringByColumn="true" property, but it is showing me filter options as shown for Integer. I want filter options for String. What can i do?

[Siddharth]

Hi,

You need to explicitly set the property DataType="System.String"

[Daniel]

Hello Siddharth,

You can also cast your data in the Select command as shown for CategoryID below:

SelectCommand="SELECT CAST([CategoryID] AS nvarchar(10)), [CategoryName], [Description] FROM [Categories]">

Regards,
Daniel
the Telerik team

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