Filtering on radgrid

[Bary]

Hello,

I took a screenshot of the page, so if you look at it, you will understand me better.

I have a radgrid that is bind to the database using SQL Datasource.

One of the columns (Price from) is not bound to the datasource, it displays data depending on the values of the details grid.

My question: I want to filter the grid on this column (price from), since it's value is not coming from the datasource, is it possible to do filtering on it.

Thanks in advance

[Radoslav]

Hello Bary,

The RadGrid filtering is performed over the data source to which the RadGrid is bound. If the column belongs to the data source you can use build in filtering in order to filter it. However if the column does not belong to the data source you cannot filter it. In this case I suggest you to create an in-memory DataTable which gets the data from the SqlDataSource and insert additional column (Price from) into it with calculated values. Then you can use Advanced Data-binding and bind the RadGrid to the DataTable.

I hope this helps.

Regards,
Radoslav
Telerik

 

 

[Bary]

Thanks for your suggestion, it helped.