TelerikSPRadListView Web Part features the Telerik RadListView control integrated into a dedicated SharePoint 2010 web part. It comes with the five predefined layouts already known from the RadListView's designer and allows for automatic insert/update/delete operations, item selection and paging.

  



 

 Telerik SPRadListView Web Part

 
  Add new record

17   
God's Revelation To The Human Heart   
Fr. Seraphim Rose   
   
English   
7   
1/6/1988 12:00:00 AM   
0938635034    
2   

18   
The Way of the Pilgrim   
Anonymous   
   
English   
10.19   
7/19/1992 12:00:00 AM   
0060630175   
1   

19   
The Philokalia, Volume 1   
St. Nikodimos of the Holy Mountain & St. Makarios of Corinth   
   
Greek   
23.95   
1/31/1983 12:00:00 AM   
B002VKK8DG   
2   

20   
David Copperfield   
Charles Dickens   
   
English   
8.94   
11/28/2000 12:00:00 AM   
0679783415    
3   

21   
The Brothers Karamazov   
Fyodor Dostoevsky   
   
Russian   
9.95   
7/25/2004 12:00:00 AM   
159308045X   
4   

22   
Old Mountain Legends   
Iordan Iovkov   
   
Bulgarian   
8.99   
7/8/1980 12:00:00 AM   
B0000D62K2   
5   

23   
Our Thoughts Determine Our Lives   
Elder Thaddeus of Vitovnica   
   
English   
15   
3/3/2009 12:00:00 AM   
9781887904193   
1   

24   
Genesis, Creation and Early Man   
Fr. Seraphim Rose   
   
English   
24   
6/5/2000 12:00:00 AM   
1887904026   
1   

25   
Notre Dame De Paris   
Victor Hugo   
   
French   
13.12   
3/15/2010 12:00:00 AM   
115405585X   
6   

26   
The Bells of Prespa   
Dimitur Talev   
   
Bulgarian   
0   
1/7/1954 12:00:00 AM   
9997548760   
5   
Items  1  to  10  of  15

TelerikSPRadListView supports binding both to SQL server database tables as well as SharePoint lists. Like its RadGrid counterpart TelerikSPRadListView comes outfit with a web part designer. To load the designer, go to the Web Part's menu and choose SPRadListView Designer:

web_part_menu.png 

 

 

 

The web part designer gives the opportunity to specify the most important properties for the list view controls, such as layout, skin, selection, automatic operations, insert item position and paging. In order to do so, select the TelerikSPRadListView1 or TemplateStructure node from the upper left tree view and click the General Settings node in the lower left one:

 

general_settings.png 
 
To indicate the data-source to which the list view control should be bound to, first select the TemplateStructure node from the upper left tree view and click on the DataBinding node in the bottom left designer pane. This will load the SQL and SP lists explorer into the top right pane: 

 

Desinger.png 
 
Since there is the possibility that due to network circumstances not all SQL Servers will be loaded into the SQL Server Instances tree, you can hard code the name of the database server manually in the panel in the top left and add it to the tree:

 

Manual_sql_server.png 
When an instance of an SQL server is chosen as the data source for the template structure of the list view, the user will be prompted to provide his/her credentials before being able to browse the server's databases and tables:

 

designer_login.png 

Upon having chosen an SQL table the designer will automatically load its columns into the bottom right pane for you to pick the ones to be displayed in the grid. 

By analogy, you can work with the SharePoint Lists explorer. No columns are selected for the SP lists but instead the user is prompted to pick the SP View which the list view control should be bound to:

SharePoint Lists.png

The SPRadListView Designer does not preclude the use of the Web Part's Tool Part and it has been built as an additional option if you need to bind the list view control to just a single SharePoint list without opening the designer. In addition, the most important properties for the control can be set from the tool part:

 

list_view_toolpart.png 
 
Particular attention should be paid to the Binding Mode property. The relevant Binding Mode options are respectively: SQL, SPList and Single SP List. You should choose SQL if you have previously bound the list view control to a SQL Server database table through the SPRadListView designer and now you need just to set some of its properties through the ToolPart. That means that the list view control will remain bound to the sql table but its properties will change in accordance with the settings in the tool part. The same goes for the SPList option the only difference being that in this case you should have the list view control previously bound to a SharePoint list. Single SP List should be chosen when you need not only to adjust the list view properties but also to bind the control to a single SharePoint list that you need to choose through the List settings combos.