#Winfo asking ideas update#
#Winfo asking ideas driver#
#Winfo asking ideas code#

Since our hierarchy should expand to a third level past albums to display songs, we need to add a child GridViewTemplate here as well. This GridViewTemplate (gridViewTemplate1) also has a property for adding child Templates. In the SmartTag menu of RadGridView under the Templates collection, I've added a new template with the albumsBindingSource set as its DataSource. Using the SmartTag on the RadGridView, I've set its DataSource to be the top level BindingSource, artistsBindingSource. They are, albumsBindingSource, artistsBindingSource, and songsBindingSource. In the Visual Studio designer, I have created several binding sources specific to each table contained within the MusicCollectionDataSet. Due to this, you actually don't have to use a DataSet to manually create a hierarchy, you simply need a set of classes that has a known relationship based on a particular ID/Key field. I am going to instead use specific ID fields from the tables to define the relationships manually. The major difference here is that I am not going to use the relationships contained within the DataSet to generate the hierarchy. I've once again created a DataSet based on this database (exactly like Figure 1 above). You can also more easily modify the layouts of the various child templates using the Visual Studio designer.įor this example, I've actually used the same exact database as in the first example, the MusicCollection database. Using this technique takes a little more work than using auto generation, but the advantage here is that you are not restricted to using DataSets.

#Winfo asking ideas code#

The Auto Generated Hierarchy ApplicationĬlick here to download the source code for this example. Running the application yields a hierarchy, three levels deep, that has been automatically generated.įigure 2. In this case, the top level table is the 'Artists' table. After this, all you need to do is set the AutoGenerateHierarchy property of the RadGridView to true, specify the DataSource as the MusicCollectionDataSet, and specify the DataMember as the top level table to display in the hierarchy. You need an instance of the MusicCollectionDataSet and instances of its various table adapters that have been filled with data from the database.

Setting up the hierarchy to automatically generate is quite simple.

The relationships defined in this DataSet are what the RadGridView is going to use to automatically generate the hierarchy.Īs you can see in Figure 1, the relationships that the hierarchy grid will be based on are the AlbumsSongs and ArtistsAlbums relationships. In my project, I've created a DataSet based on this database and its three tables called MusicCollectionDataSet. To show you how this works, I've created a small demo application that uses a music collection access database. The only downside to automatically generating the hierarchy is that you must use DataSets. Setting up an auto generating hierarchy is probably the easiest route you can take when working with hierarchies and the RadGridView.

#Winfo asking ideas driver#

The reason for this is that all of these projects use an MS Access database, and there is currently no 圆4 driver available for accessing MS Access databases from the.

Note: If you download any of the hierarchy demo projects and are using an 圆4 version of Windows, you will need to be sure to set the compiler options for the project to x86. Today I thought I would take some time out to explain those techniques in more detail here on my blog.

#Winfo asking ideas update#

Due to this, and other changes, I've decided to update this blog entry to contain the latest available information.Ī while back, I posted a video on Telerik TV explaining the different techniques you can use to create a hierarchical RadGridView ( Please note that the video was recorded prior to Q2, so there may be a few minor differences between the RadGridView in the video and the one that is currently available). Most notably, the MasterGridViewTemplate property has been deprecated and replaced with the MasterTemplate property. Update (): With the Q2 2010 release, a few things changed in RadGridView's API.