This is a migrated thread and some comments may be shown as answers.

Filtering on radgrid

2 Answers 9 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Bary
Top achievements
Rank 1
Bary asked on 02 Sep 2014, 08:26 AM
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

2 Answers, 1 is accepted

Sort by
0
Accepted
Radoslav
Telerik team
answered on 03 Sep 2014, 07:04 AM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Bary
Top achievements
Rank 1
answered on 05 Sep 2014, 07:37 AM
Thanks for your suggestion, it helped.
Tags
Grid
Asked by
Bary
Top achievements
Rank 1
Answers by
Radoslav
Telerik team
Bary
Top achievements
Rank 1
Share this question
or