Tuesday, July 23, 2013

TelerikRadGrid vs External List vs Businee Data List Webpart

The below table shows a comparison of Telerik Rad Grid, external list listview webpart, and business data list webparts.

Feature
Telerik Webpart
External List
Business Data List Webpart
Comments
Inline editing
Yes
No
No

Pagination
Yes
Yes
Yes

Is Asynchronous
Yes
Yes
Yes

Default User experience
Yes
Yes
Yes

Customizable UI
Yes
Yes
Yes

Is binded To
External List
External Content Type
External List

Has Good Performance with Large lists
Yes
No
Yes
In Throttling settings for External Lists->
Scope and ThrottleType describe the rule you’re working with. Enforced represents whether it’s turned on, and Default(default value is set to 2000) is the limit that is applied to external list. Custom web parts can override the Default limit and work on more data than external lists; they are instead limited by the Max limit(default value is set to 1000000).
Advanced Filtering
Yes
Yes through other filter webparts
Yes through other filter webparts

Sorting
Yes
Yes
Yes

Datasheet View in the ribbon
No
No
No

Export to excel in the ribbon
No
No
No

Customizable Pagination
Yes
No
No
We have First page and Last page in Telerik webpart
We service binding
Yes
No
No

Webpart Scrolling
Yes
No
No
By default, external lists span the whole page and page scrollingis available.
Column reordering in the UI
Yes
No
No

Insert
Yes
Yes
Yes

Edit
Yes
Yes
Yes

Delete
Yes
Yes
Yes

Export Mode
Export all data or non-sensitive data
No
Export all data or non-sensitive data

SPRadGridDesigner
Yes
No
No
Allows quick enable/disable options for pagination, sorting etc
Shows ListItem count
Yes
No
No

DataView Caching
No
Yes
Yes

XSL Editor
No
Yes - Through SPDesigner
Yes

Customizable Ajax Options
No
Yes
Yes
  1)Enable Asynchronous Load
  2) Enable Asynchronous Update
  3)Show Manual Refresh Button
  4)Enable Asynchronous Automatic 
Allow editing in Personal View
Yes
Yes
Yes

Select All
No
Yes
Yes

Drag columns for Group By in browser
Yes
No
No


No comments:

Post a Comment