The Telerik SPRadGrid WebPart also features binding to external lists. The following example demonstrates RadGrid's being data-bound to the Products table of the Northwind database through a SharePoint external list.
 

 Products

 
Drag a column header and drop it here to group by that column
ProductIDProductNameSupplierIDCategoryIDQuantityPerUnitUnitPriceUnitsInStockUnitsOnOrder
Data pager
Data pager
123
Page size:
PageSizeComboBox
select
 79 items in 3 pages
1Chai51110 boxes x 20 bags390
2test1124 - 12 oz bottles1740
3Aniseed Syrup1212 - 550 ml bottles1311
4your mom2248 - 6 oz jars530
5Chef Anton's Gumbo Mix2236 boxes00
6Grandma's Boysenberry Spread3212 - 8 oz jars1000
7Uncle Bob's Organic Dried Pears3712 - 1 lb pkgs.150
8Northwoods Cranberry Sauce3212 - 12 oz jars60
9Mishi Kobe Niku4618 - 500 g pkgs.290
10Ikura4812 - 200 ml jars310
11Queso Cabrales541 kg pkg.2230
12Queso Manchego La Pastora5410 - 500 g pkgs.860
13Konbu682 kg box240
14Tofu6740 - 100 g pkgs.350
15Genen Shouyu6224 - 250 ml bottles390
16Pavlova7332 - 500 g boxes290
17Alice Mouton7620 - 1 kg tins00
18Carnarvon Tigers7816 kg pkg.420
19Teatime Chocolate Biscuits8310 boxes x 12 pieces250
20Sir Rodney's Marmalade8330 gift boxes400
21Sir Rodney's Scones8324 pkgs. x 4 pieces340
22Gustaf's Knäckebröd9524 - 500 g pkgs.1040
23Tunnbröd9512 - 250 g pkgs.610
24Guaraná Fantástica10112 - 355 ml cans200
25NuNuCa Nuß-Nougat-Creme11320 - 450 g glasses760
26Gumbär Gummibärchen113100 - 250 g bags150
27Schoggi Schokolade113100 - 100 g pieces490
28Rössle Sauerkraut12725 - 825 g cans260
29Thüringer Rostbratwurst12650 bags x 30 sausgs.00
30Nord-Ost Matjeshering13810 - 200 g glasses100
  • Sort Ascending
  • Sort Descending
  • Clear Sorting
  • Group By
  • Ungroup
  • Columns
  • Filter
    • select
      select
External Lists are treated by SharePoint as regular SharePoint lists and as such are part of a given SharePoint site/subsite. Therefore, TelerikSPRadGrid will list them in the ToolPart list combo or the SPRadGrid Designer SPLists explorer tree along with the regular SharePonit lists and you can pick one from there to bind SPRadGrid to the external data store. Any change to the data in the SPRadGrid control will be automatically reflected into the external data provider.