How to bind RadGrid properly on server-side

AUTHOR: Eyup Yusein

DATE POSTED: April 03, 2018

DESCRIPTION

Occasionally, some features provided by RadGrid like filtering, sorting or exporting can malfunction without any obvious reason. There is a high chance for this issue to be fixed by implementing a proper way of binding.

SOLUTION

Performing complex grid operations such as Inserting, Deleting, Updating, Hierarchy relations, Grouping, Exporting, Paging, Sorting, Filtering, etc. require accommodating appropriate database operations. Therefore, we suggest you avoid Simple Databinding and strongly recommend the use of more advanced data binding methods, which automatically handle the aforementioned functions:

• Declarative DataSource (DataSourceID property)
  
• Programmatic Data Binding (NeedDataSource event, + DetailTableDataBind for hierarchy). You should set the DataSource property only within these event handlers

Here is another sample of the NeedDataSource event.

In some scenarios it may be necessary the grid to be refreshed explicitly upon some external action - in such cases please choose to use just the Rebind() method, which will refresh the grid content.