How To: Display Hierarchical Data with Row Details (RadGridView for Silverlight) July 30, 2009.NET 0 Comments The main goal of the Row Details feature is to let you present additional information about a row. Binding to Hierarchical Data Programmatically. RELATED VIDEOS. RadGridView1.MasterTemplate.Rows.Add(GetImageFromData(row.Photo), name, random.Next(45000).

  1. Display Hierarchical Data
  2. Hierarchical Data Excel
  3. Data Grid View Vb
  4. Hierarchical Grid Examples

I am trying to construct a datagridview that will show a number of rows with a particular set of fields, but also allow me to show some 'subrows' ie rows that can be expanded below the parent row in. DataGridView with hierarchical data binding. I need to add images at the starting of row The images are based on the data in table Please help. I just developed an application based on hierarchical data view, no tree view is shown, it just shows as a normal data grid view. Not sure where I am going wrong? Anyone can help?

Active6 years, 4 months ago

Am working on a .net 3.5/Winforms application.I need to show a datagridview with hierarchical data in the datagrid.

For example, master rows will have an expand/collapse icon..and when the user clicks on a master row, it should expand and show the child row details in the grid.

Using the Infragistics sample example at http://devcenter.infragistics.com/Support/KnowledgeBaseArticle.Aspx?ArticleID=1665, am now able to see Master/Child data in my ultragrid.

Now my next task is to :

Hierarchical

1.Show editable textboxes in the child grid having order details.[Note: I tried this but did not work for me: this.ultraGrid.DisplayLayout.Bands[1].Columns[3].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Edit;]

2.When the user hits submit button, read these textbox values and push it to the database.

Could you please let me know if this is possible and how to go about it?

Any sample example will be really helpful.

Data grid view vb

Thanks.

Jimmy
JimmyJimmy
92610 gold badges33 silver badges49 bronze badges

1 Answer

Take a look at this

EDIT::

For Infragistics UltraGrid, refer

Community
Sangram NandkhileSangram Nandkhile
8,64415 gold badges71 silver badges103 bronze badges
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Not the answer you're looking for? Browse other questions tagged winformsdatagridviewinfragisticsultragrid or ask your own question.

31 Jul 2008Ms-PL
The TreeGridView by Mark Rideout with data binding and sorting

Introduction

The TreeGridView by Mark Rideout (here's the link) is a great control. It allows us to display relateddata in a hierarchical form (a tree!), but I needed it to be sortableand support data binding.

The HierarchicalGrid does that, the quick and dirty way. It displays the table relations in a hierarchical form and sorts it through the levels too.

Also, this is my first contribution and any feedback would be greatly appreciated!

Background

I would really recommend you see the TreeGridView.

Using the code

There's a new class called DataGridSource, and the DataSource of the HierarchicalGrid must be of that type.
It takes three arguments: the dataset, a list of display columns and a list of group columns. Now, what are those? The display columns are names of the table columns to be displayed, and the group columns are columns that group total values, like sum, average, product, etc.

Let's suppose that we have two tables, one with a list of people and their fruit preference, and another with where and when each person bought their favorite fruit.

For instance, the display columns would be:

Now we have a list of columns to be displayed. What about the group columns? Let's set them:

Pay attention to the GroupColumn type. It groups the name of the column and the type of operation that it should do on its child results. We added a new sum of quantities.

Okay! We have our display columns list and our group columns list. Let's get our dataset.

Display Hierarchical Data

To set the dataset, we must use one of the datatables' dataset when creating a new DataGridSource, like this:

Hooray! That's it! It displays an hierarchical form of the dataset, with the relations.

Points of Interest

Two things here:

- When you set the dataset, it tries to find the best sequence of relations to fill the dataset. In other words, it works like matching a sequence of domino pieces. It has one solution and it tries to find it. It finds the top and the bottom relation, then it successively searches for the relation the matches the previous one.

- We can't let the DataGridView sort function work here, otherwise it would break the structure of the data. So, each time it is asked to sort, it clears the grid and adds the nodes again, in the proper order. That's clearly NOT efficient. This is where work must be done.

Hierarchical Data Excel

History

Data Grid View Vb

  • July 31, 2008 - Initial release

Hierarchical Grid Examples