Different data source for each column

4 posts, 0 answers
  1. Silvio Silva Junior
    Silvio Silva Junior avatar
    100 posts
    Member since:
    Mar 2010

    Posted 26 May 2011 Link to this post

    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                        
                       
                                                                
  2. Gimmik
    Gimmik avatar
    170 posts
    Member since:
    May 2011

    Posted 26 May 2011 Link to this post

    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
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Silvio Silva Junior
    Silvio Silva Junior avatar
    100 posts
    Member since:
    Mar 2010

    Posted 27 May 2011 Link to this post

    with radgrid? How can I do this?
  5. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 30 May 2011 Link to this post

    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.

Back to Top