telerik grid ajax,ASP.NET AJAX PivotGrid - RadControls for Web Forms | Telerik UI for ASP.NET AJAX

Data Binding

Use any declarative data source control (AccessDataSource, SqlDataSource, LinqDataSource, EntityDataSource, ObjectDataSource, XmlDataSource), or bind the Excel-like pivot table for ASP.NET to your custom objects on the fly. You can also bind RadPivotGrid programmatically by leveraging the NeedDataSource event fired only when the control needs to get fresh data instead of upon every postback. In addition to data grouping by a simple type, such as string or int, the advanced ASP.NET pivot table control allows you to group data by custom objects.

OLAP and KPIs Support

Bind Telerik ASP.NET Pivot Grid control to OLAP data sources through the XMLA and ADOMD.NET data providers to easily display, sort, page and filter data and KPIs from your Cube. The accompanying hierarchical Field List is fully optimized to load the entire structure of the bound OLAP data source on demand.

Easy End-User Configuration via Fields List and Field Zones