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

Evaluate the RadGridView to support the functional requirement

16 Answers 171 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Reshu
Top achievements
Rank 1
Reshu asked on 01 Jul 2008, 02:39 PM
Hi,

I have a requirement and need to evaluate if RadGridView can support this.

I need to display hierarchical data in the grid. The data can span unto 4 levels. To clarify it further, say I have Manufacturer, Retailer and consumer. Here the consumer can directly purchase from a manufacturer. Or he can consume from a retailer. Also retailer can purchase from the manufacturer. I am interested in showing up the data in a user friendly format. I have tried these 2 options

1. Group by feature and realized that even when the consumer purchases directly from Manufacturer, the data for the consumer is displayed at 3rd level. Since the data is grouped on Manufacturer and then the Retailer. So here the consumer is shown as Manufacturer1-> Retailer (EMPTY)-> Consumer.
2. The other option was showing the data establishing relationship between tables. This served the purpose but the view is unfriendly. The user has to scroll up and down too much to view the data.

Please let me know if there is a possibility with RadGridView to support this requirement. To summarize it, I need to display data hierarch ally where I have Manufacturer, Retailer and Consumer. The Consumer can purchase from both Retailer and Manufacturer. And Retailer can buy only from Manufacturer. So the hierarchy can be

-Manufacturer1
    -Retailer1
        -Consumer2
        -Consumer3
    -Consumer1
-Manufactuer2
    -Consumer4
    -Retailer2
        -Consumer5
    Retailer2

Regards,
Reshu
 

16 Answers, 1 is accepted

Sort by
0
Julian Benkov
Telerik team
answered on 03 Jul 2008, 11:59 AM
Hi Reshu,

Currently, the implementation of RadGridView does not support this scenario. You can setup RadGridView to show and manipulate hierarchy level using relations description (GridViewRelation) like ADO.NET DataSet object.

The result for your object may be:

-Manufacturer1
    -Retailer1
        -Consumer2
        -Consumer3
    -
Retailer2
       -Consumer4
    -Retailer3

Currently we are starting implementation of hierarchy support for custom object, on demand loading IList object for expanded parent level and all possible virtualization used in hierarchy mode. The new functionality and API will be available for our Q3 release.

I hope this was helpful. If you have additional questions, please don't hesitate to contact us.

Greetings,
Julian Benkov
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center
0
Renu
Top achievements
Rank 1
answered on 31 Dec 2008, 06:15 AM
Hi,

Please let me know if Q3 release supports the behavior asked by Reshu.
0
Julian Benkov
Telerik team
answered on 05 Jan 2009, 02:20 PM
Hi Renu,

Sorry for the inconvenience.

This feature is not supported in current Q3 release. The new functionality and API will be available after Q1 2009 release.

Regards,
Julian Benkov
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Jordan
Telerik team
answered on 05 Jan 2009, 02:43 PM
Hello Renu,

Regarding the scenario that Reshu mentions, we will need more information about this case so that we are able to evaluate it and consider the development of a feature for RadGridView that will support such a scenario.

Sincerely yours,
Jordan
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Renu
Top achievements
Rank 1
answered on 06 Jan 2009, 09:04 AM
Hi Jordan ,

Reshu has mentioned the complete requirement.
Please let me know what more information do you need and also could you please tell me when we can expect Q1 2009 release?

Thanks and regards,
Renu
0
Jordan
Telerik team
answered on 09 Jan 2009, 08:41 AM
Hi Renu,

What is not clear (and at the same time very important) is how your data schema looks.
Do you store all your data in a single table, or do you have a separate table for each type (manufacturer, retailer, consumer)?

In the first case, what is possible is to implement a self-reference feature for RadGridView, see the Self-referencing Hierarchy example for our ASP.NET grid control.

In the second case some custom logic could be used with the unbound mode of RadGridView.
You could take a look at the RadGridView Hierarchy example in the Quick Start application.
However, depending on your data schema that option could not work for you.

Kind regards,
Jordan
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Renu
Top achievements
Rank 1
answered on 13 Jan 2009, 06:16 AM
Hi Jordan,

We are fetching the data using a web service and we cannot modify the data schema.We have only the type of Manufacture, Retailer and Consumer. We are using Windows rad grid. Please let me know if you need anyhing else and also could you please tell me when we can expect Q1 2009 release?

Thanks and regards.
Renu


0
Jordan
Telerik team
answered on 16 Jan 2009, 08:35 AM
Hi Renu,

The Q1 2009 release is expected at the end of February.

The fact that you have three separate entities and you cannot modify the data schema is unfortunate.
It seems that a self-reference scenario will not be possible. And the more we think about your case the more it seems that it is not currently possible.

We will continue adding new features and improving RadGridView (including self-reference binding). Unfortunately I cannot promise you at the moment that we will add such features that will allow displaying such complex relations like the ones between your entities.

All the best,
Jordan
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Renu
Top achievements
Rank 1
answered on 02 Feb 2009, 11:30 AM
Hi Jordan,

Currently we are using Telerik version 8.2.0.0. Please let me know if it suppot the required bahavior asked by Reshu.
 

Regards,
Renu
0
Jordan
Telerik team
answered on 04 Feb 2009, 03:54 PM
Hello Renu,

Unfortunately the RadGridView control in the  8.2.0.0 version of RadControls for WinForms does not support binding to a data source with such complex relations.

However you could try creating a new data source with a schema that is supported by RadGridView and populating it with your data.

Greetings,
Jordan
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Tim
Top achievements
Rank 1
answered on 11 Feb 2009, 07:06 PM
Jordan,

I work with Renu and Reshu.  I think maybe I could simplify our intended use for you.  Essentially, we have a document management server that can store files with attributes at any level of the folder hierarchy, except the root.  Folders can also have attributes.  Think of it as a remote implementation of a file system.  For example, we might have a heirarchy that looks like this:

-Folder 1 (attribute xx,yy,zz)
    File 1 (attribute a, b, c, etc)
    - Sub folder 1
          File 2 (attribute a, b, c, d, etc)
    - Sub folder 2
          File 3 (attribute b, d, e)
+Folder 2
:
+Folder n

The data is currently retrieved from the server and displayed in a modified tree grid view that allows for a) the heircarchical tree display and b) the ability to show columns and display attributes of both files and folders.

I really like the visual representation that is used for the Telerik Rad Grid View, however because it is data bound (our data is recursively retrieved from the document management interface via a web services interface), we have been prevented from using it.  I though that the ability to "roll up"  a folder as a RadGridView grouping would be a clean visual style. 

Is it possible to force the RadGridView to accomodate an unbound data insertion that would also allow for files to show at any location in the hierarchy?  If not, is is it possible to use a different control (the Telerik tree control for instance) and have it configured to behave with a similar "grouping" effect and display columns that allow us to show attributes?

I hope that helps clear up what we are trying to do.

Much appreciated.

Tim Brown
0
Jordan
Telerik team
answered on 16 Feb 2009, 08:06 AM
Hello Tim,

Thank you for the explanation.

Unfortunately, RadGridView does not currently support a mode that will allow "files to show at any location in the hierarchy".

Regarding the other option that you mention - a TreeList control: we do not currently have such a control in our suite; we have plans to develop such a control but unfortunately I cannot give you an exact time-frame at the moment.

Regards,
Jordan
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.
0
Ganesh Jagdale
Top achievements
Rank 1
answered on 29 Dec 2009, 10:14 AM
FirstName  ||   LastName    || Email      

Manager1
  ---->M1
           ---->p
 ----->M11
Manager 
  ----> M2
        ---->p
 ----->M21

I want to show this self referancial Hirarchy in RadgridView...
Pls, tell me if possible
 
0
Nick
Telerik team
answered on 29 Dec 2009, 10:20 AM
Hi Ganesh Jagdale,

Thank you for contacting us. Self-referencing might be available for Q1 2010, but I cannot confirm that yet because there are numerous other tasks to be completed as well. Do not hesitate to write us back if you have further questions.

Best wishes,
Nick
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Ganesh Jagdale
Top achievements
Rank 1
answered on 04 Jan 2010, 09:16 AM

Hi telerik,

I want to hide header text of column in RadGridView of silverlight why because I shown Grid inside Grid for multiple self referancial  hirarchy. and for child grid I don't want to show column heade ...
 How to that?

 

<

 

telerik:RadGridView  Name="gamesGrid"  ShowGroupPanel="False" AutoGenerateColumns="False">

 

<

 

telerik:RadGridView.HierarchyChildTemplate>

 

 

 

 

 

 

<DataTemplate>

 

 

 

 

 

 

<telerik:RadGridView Name="level3" ShowGroupPanel="False" AutoGenerateColumns="False"

 

 

 

 

 

ColumnsWidthMode="Auto">

 

 

 

</telerik:RadGridView >
</telerik:RadGridView >

 

 

Pls help me out... 

0
Nick
Telerik team
answered on 04 Jan 2010, 09:22 AM
Hello Ganesh Jagdale,

Thank you for contacting us. You have posted your question in our WinForms forum section. Please post your question in our Silverlight section as the discussion in the current thread is about our WinForms grid.

All the best,
Nick
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Tags
GridView
Asked by
Reshu
Top achievements
Rank 1
Answers by
Julian Benkov
Telerik team
Renu
Top achievements
Rank 1
Jordan
Telerik team
Tim
Top achievements
Rank 1
Ganesh Jagdale
Top achievements
Rank 1
Nick
Telerik team
Share this question
or