DevExpress ASP.NET Grid View supports custom data binding that allows you to perform all data operations, such as paging, sorting, filtering, grouping and summary calculation, completely by yourself.
In this mode, you handle data operations in corresponding Action methods; the correspondence is defined by populating the grid's CustomBindingRouteValuesCollection.
In each specified Action, the processed operation related state information, such as a column state (i.e., which column is sorted and in which direction) or a pager state (which page is selected), is passed automatically. The grid's current state (view model) can be obtained via the static GridViewExtension.GetViewModel method and can be updated with the processed operation state. Then, the required data should be provided for the grid view model via a call to its ProcessCustomBinding method.
The ProcessCustomBinding method has several overloads. You can select a particular one depending on which data operations you need to handle.
Generally, this method provides the following parameters representing typed method delegates:
getDataRowCountMethod of the GridViewCustomBindingGetDataRowCountHandler type
Provide implementation for this method to return the total number of data rows.
getDataMethod of the GridViewCustomBindingGetDataHandler type
Provide implementation for this method to return the required data rows to the grid.
getSummaryValuesMethod of the GridViewCustomBindingGetSummaryValuesHandler type
Provide implementation for this method to calculate and return values of summaries required within the grid.
getGroupingInfoMethod of the GridViewCustomBindingGetGroupingInfoHandler type
Provide implementation for this method to return data rows for visible and expanded groups in the required order that depends on the applied grouping and sorting.
getUniqueHeaderFilterValuesMethod of the GridViewCustomBindingGetUniqueHeaderFilterValuesHandler type
Provide implementation for this method to return unique values to be displayed in the header filter popup list invoked for a column.
The resulting grid state (view model) is returned as a model to a view that contains GridView. To bind GridView to this view model, use the BindToCustomData method.
This demo shows an advanced implementation of custom data binding - all data operations are processed (in particular: sorting, paging, grouping, summary calculations and filtering including column header filter invocation).
Note that when implementing the grid's custom data binding, the DevExpressEditorsBinder must be used instead of the default model binder to correctly transfer values from DevExpress editors back to the corresponding data model fields. In this demo, the DevExpressEditorsBinder is assigned to the ModelBinders.Binders.DefaultBinder property within the Global.asax file, thus overriding the default model binder.
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
The source code files for this demo are installed (by default) in the following directory:
Open CS Solution
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxGridViewDemos