Creating C# Treeview from Database values

Question

I'm pulling a column of information from a database thru odbc. The column will have numbers in it ranging from 1 to 9999999. I want to be able to organize the values into a treeview with up to 3 levels (parent, child, and grandchild) in the following way:

ideal structure would be: AAABBCC
parent: AAA0000
child: AAABB00
grandchild: AAABBCC

however if the level above doesn't exist then the value moves up in a level. For example, assuming that the data contains the following {1, 101, 200, 204, 1200, 1205, 1304, 290000, 291500, 291502,410204}

-- 1
-- 101
-- 200
------- 204
--1200
-------1205
--1304
--290000
--------291500
----------------291502
--410204

Any help would be greatly appreciated.
Mark

winforms, wpf, silverlight, wp7, asp.net web forms, or mvc, or other? — Daniel A. White
– Daniel A. White, Commented Apr 20, 2012 at 19:08

JamieSee · Accepted Answer · 2012-04-20 23:14:18Z

1

This is really a very simple problem.

Convert your list of numbers to strings by calling .ToString("D7") on each number.
Sort the converted list.
Take the SubString(0,3) to get your parent value.
Take the SubString(3,2) to get your child value.
Take the Substring(5,2) to get your grandchild value.
If your child value is 00, create a new TreeNode parentNode and add it to the TreeNodeCollection.
If your child value is not 00 and your grandchild value is 00, create a new TreeNode childNode and add it to parentNode.
If your grandchild value is not 00, create a new TreeNode grandchildNode and add it to your childNode.

If you need to fill gaps in sequence, a little extra logic is required but it's fairly trivial.

answered Apr 20, 2012 at 23:14

JamieSee

13.1k2 gold badges34 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating C# Treeview from Database values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related