This is a migrated thread and some comments may be shown as answers.

Different data source for each column

3 Answers 103 Views
ListView
This is a migrated thread and some comments may be shown as answers.
Silvio Silva Junior
Top achievements
Rank 2
Silvio Silva Junior asked on 26 May 2011, 03:21 PM
Hello guys.

Is there a way to use a different source for each column is a list view?

For example, I have a listview with 5 columns, I'll receive 5 tables from the database (dataset). I would like to set each column to get data from each database table.

Does anyone know how I do this?

Column 1     Column 2     Column 3     Column 4    Column 5
userA, idA    userB, idB    userC, idC   userD, idD  userE, idE
userF, idF    userG, idG   userH, idH    userI, idI
userJ, idJ                          userK, idK    userL, idL
userM, idM                        userN, idN
userO, idO                        userP, idP
userQ, idQ
userR, idR                        
userS, idS
userT, idT                        
                   
                                                            

3 Answers, 1 is accepted

Sort by
0
Gimmik
Top achievements
Rank 1
answered on 26 May 2011, 11:40 PM
Hi Silvio,

The only way I can think to do this would be to create a new dataset on the back end that is composed of columns from all your different data sources, then bind that to the RadGrid. You have full control that way.

Hope this helps,
-Gimmik
0
Silvio Silva Junior
Top achievements
Rank 2
answered on 27 May 2011, 01:33 PM
with radgrid? How can I do this?
0
Radoslav
Telerik team
answered on 30 May 2011, 11:14 AM
Hi Silvio,

The RadGrid does not support the desired functionality concerning bound its columns to a different tables. However you could try creating a SQL View which is a virtual table based on SQL SELECT query. Into this View you could join the 5 tables. Then you could bound the RadGrid to this View.

I hope this helps.    

Greetings,
Radoslav
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Tags
ListView
Asked by
Silvio Silva Junior
Top achievements
Rank 2
Answers by
Gimmik
Top achievements
Rank 1
Silvio Silva Junior
Top achievements
Rank 2
Radoslav
Telerik team
Share this question
or