I've made small example how to perform paging, sorting and filtering directly on the data-base sever using LINQ to SQL and RadGridView for WPF.
The data-base is not included however you can use the same code with any data-base with following modifications:
- change the connection string in the app.config file
- change the table name in BindGrid() method:
IQueryable queryable = new DataClasses1DataContext().[Your Table].AsQueryable();
- define desired total number of items per page and total page count
- change the filter expression in the filter button click event handler to desired (currently Contains for Name column)
Vladimir Enchev is Director of Engineering, Native Mobile UI & Frameworks
Copyright © 2017, Progress Software Corporation and/or its subsidiaries or affiliates. All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.