DataSet

[Eduardo]

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?

[Todd Anglin]

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

[Jie]

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?

[Vlad]

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.