DataSet

4 posts, 0 answers
  1. Eduardo
    Eduardo avatar
    15 posts
    Member since:
    Mar 2009

    Posted 26 Mar 2009 Link to this post

    This post: http://www.telerik.com/community/forums/silverlight/gridview/selecting-row.aspx ; I show as I bind a gridview with a DataSet reimplemented for componentOne. This DataSet is any sql query with "joins".

    I want to know if telerik has anything as this DataSet... Do you have?
  2. Todd Anglin
    Todd Anglin avatar
    2040 posts
    Member since:
    Aug 2005

    Posted 27 Mar 2009 Link to this post

    Hello Eduardo-

    As you know, in the Silverlight platform, there is no support for ADO.NET (or ADO.NET objects like DataTable and DataSet). This is a concious choice by the Silverlight Team at MSFT and they have inidcated they are unlikely to reverse it anytime soon because they feel the Silverlight enviornment is best served by not working in the "old" DataSet mentality (instead perferring Lists of objects). As such, there is no DataSet available for RadGridView- as far as I'm aware.

    Do you think that it is important to extend the idea of the DataSet to Silverlight? Do you think there are problems with the proposed course of using strongly typed collections and lists? I'd be curious to hear your opinion.

    -Todd
  3. DevCraft banner
  4. Jie
    Jie avatar
    5 posts
    Member since:
    May 2009

    Posted 15 May 2009 Link to this post

    I believe there is a problem.  Using strongly typed object collections as data sources removes the ability to create dynamic columns.  If each column in the GridView corresponds to an object's property, this does not allow us to generate these columns at runtime. 

    The specific issue I have is this:  I return a dataset with the following values

    Object

    Value

    Person

    A

    1

    John

    B

    2

    John

    C

    3

    John

    A

    4

    Bob

    B

    5

    Bob

     

    But I need to format it so it finally looks like this in your RadGridView:

    Object

    John

    Bob

    A

    1

    4

    B

    2

    5

    C

    3

     


    If I could use a DataTable/DataSet as the data source, I could just pivot the data within my SQL query and then bind to the GridView with the dynamic columns for "John" and "Bob" already created.

    Is there a good way to solve this issue with the current functionality?
  5. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 16 May 2009 Link to this post

    Hello Jie,

    Please check these posts for more info:
    http://blogs.telerik.com/vladimirenchev/posts/09-04-23/lightweight_datatable_for_your_silverlight_applications.aspx

    http://blogs.telerik.com/stefandobrev/posts/09-02-16/transpose_or_just_rows_as_columns.aspx

    Kind regards,
    Vlad
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
Back to Top