How to accomplish multi-column, hierarchical data entry-VBForums
Results 1 to 6 of 6

Thread: How to accomplish multi-column, hierarchical data entry

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2009
    Posts
    258

    Question How to accomplish multi-column, hierarchical data entry

    I am using Visual Studio 2012, developing C# WPF on Windows 7.

    I have a situation where I need to support viewing and modification of data in a DataGrid-style interface, only supporting child rows... editable in-place. Think of a data set where the root nodes are courses being taught at a university, and the child nodes are the students taking each class. Not exactly realistic, but it gets the point across... only two levels of data, so its not nested deep. Both the parent and the child data have multiple columns that need to be editable.

    I want the user to be able to move up and down through the data, editing both parent and child data, expanding and collapsing the parent nodes at will. It needs to support textbox editing, as well as combo and check boxes. I should be able to find the selected row, and the parent or children of that selected row. It will be bound to an observablecollection formatted the same way, i.e. each node in the collection will contain an observablecollection pointing to any children it might have. It needs to support both single-row and multi-row selection.

    DataGrid doesn't work, because it doesn't seem to support a hierarchical structure. Treeview does, but it isn't multi-columnar. I don't want to spend money on a third-party control, but there has to be an option to do something like this... it's far too common a scenario. Just looking for suggestions... and I'm okay doing extra coding to make the thing behave properly.

    Any suggestions are appreciated.

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    31,182

    Re: How to accomplish multi-column, hierarchical data entry

    Third party is really the only way you're going to get this unfortunately.
    Company I used to work for used the Infragistics Ultra Grid for this very kind of stuff.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  3. #3

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2009
    Posts
    258

    Re: How to accomplish multi-column, hierarchical data entry

    We did for a while, as well, but moved away from them a few years ago. I'm actually developing to replace an app we developed using Infragistics controls... this is really the only functionality that I need to get. Using a datagrid for each level of data just isn't cutting it.

  4. #4
    Fanatic Member Spooman's Avatar
    Join Date
    Mar 2017
    Posts
    827

    Re: How to accomplish multi-column, hierarchical data entry

    HK

    What about 2 Flexgrids?

    Seems like it might work using VB6
    I imagine that there is a comparable control in VB.Net

    Spoo

  5. #5
    Frenzied Member KGComputers's Avatar
    Join Date
    Dec 2005
    Location
    Cebu, PH
    Posts
    1,879

    Re: How to accomplish multi-column, hierarchical data entry

    Last edited by KGComputers; Nov 11th, 2017 at 01:52 AM.
    CodeBank: VB.NET & C#.NET | ASP.NET
    Programming: C# | VB.NET
    Blogs: My Blog | GitHub Repo | ASP Snippets | CodeASP.net
    ___________________________________________________________________________________

    Rating someone's post is a way of saying Thanks...

  6. #6

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2009
    Posts
    258

    Re: How to accomplish multi-column, hierarchical data entry

    What I'm trying now is a DataGrid with an expander containing a second DataGrid. I'm in the early stages of building it now, but the POC application seemed to work fine.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.