2,095 questions
4
votes
4
answers
984
views
hierarchical .Net file format?
Our company has been for a while looking at a file format to hold a large amount of lab sensor data. Each time they run the instrumentation, it generates a file, which we consume and store in a ...
- 598
2
votes
4
answers
2k
views
Put linq to sql results into hierarchical structure for using in a un-ordered list ( for jquery tree )
I have 5 tables in a L2S Classes dbml : Global >> Categories >> Sub-Category >> Item >> Item Data. I want to be able to navigate from the Global table down a tree like structure to get to the items - ...
- 2,123
1
vote
2
answers
722
views
Proper Use of a Class Instance
I'm using Access 2003 VBA to process recursive data for manufacturing BOMs. I built a class module to let my main tables have static scope. This seems to simplify recursion -- it sets me free from ...
- 7,059
0
votes
2
answers
2k
views
Multiple tables in nested sets hierarchy
I have a number of distinct items stored in different MySQL tables, which I'd like to put in a tree hierarchy. Using the adjacency list model, I can add a parent_id field to each table and link the ...
jetboy
1
vote
2
answers
2k
views
Hierarchical Databinding with Linq to SQL
I am attempting what I think is a rather simple databinding scenario with Linq To SQL.
I have a table of FacultyMembers, whose schema looks something like this:
FacultyMemberID - int PK
Name - ...
- 13k
1
vote
2
answers
8k
views
How to bind a dataset with multiple tables to asp.net treeview control?
I have a tree view control which I have to bind a dataset with multiple data tables in it, and have relations between them.
can you suggest how can I do that, I have tried many ways but none of them ...
- 622
24
votes
3
answers
7k
views
Storing hierarchical data in Google App Engine Datastore?
Can someone illustrate how I can store and easily query hierarchical data in google app engine datastore?
- 1,331
4
votes
2
answers
2k
views
Sum of hierarchical data using LINQ?
Is it possible to sum hierarchical data using .NET's LINQ?
My data class looks like this:
class Node
{
public decimal Amount;
public IEnumerable<Node> Children { get; set; }
}
So I ...
- 11.2k
0
votes
4
answers
12k
views
MySQL parent -> child query
I'm working with mySQL, and I'm in a situation where I need to select data from one table that matches an ID at any level in parent -> child data hierarchy in the other table.
Further more, I would ...
user317071
2
votes
5
answers
25k
views
Oracle Hierarchical query: how to include top-level parent
I have a hierarchical query to track a reporting structure. This almost works, except that it's not reporting the very top level node, probably because the top-level people "report" to themselves.
...
- 37.6k
4
votes
4
answers
2k
views
Sort a 2d array based on parent-child relationships between rows (not simply ASC on column values)
I've got an array with data from a MySQL table in nested set model I'd like to get sorted, not only alphabetical but also with the child nodes directly after the parent node.
Example - array to be ...
- 4,402
0
votes
1
answer
2k
views
Bind a IHierarchicalEnumerable to a treeview, and specify custom Images and navigation Urls
I have an external datasource that implements IHierarchicalEnumerable. I'm trying to use that datasource for my TreeView, but I can't find a way to specify the images and individual navigation urls ...
- 5,541
0
votes
5
answers
4k
views
What the best way to handle categories, sub-categories - hierachical data?
Duplicate:
SQL - how to store and navigate hierarchies
If I have a database where the client requires categories, sub-categories, sub-sub-categories and so on, what's the best way to do that? If ...
- 19.9k
3
votes
4
answers
5k
views
How can I update a nested set tree structure?
I've looked at Managing Hierarchical Data in MySQL, but it really only deals with adding and deleting nodes in a Nested Set Model.
I need to be able to move nodes with and without child nodes.
How ...
Andre
3
votes
3
answers
3k
views
What is the best way to model user defined hierarchical relationships in a database?
Essentially, I want the user to be able to define a hierarchical model, but then I need to allow the user to store data within their defined model. Does this make sense? So the users will be able to ...
- 23.3k
8
votes
3
answers
13k
views
Fetching linked list in MySQL database
I have a MySQL database table with this structure:
table
id INT NOT NULL PRIMARY KEY
data ..
next_id INT NULL
I need to fetch the data in order of the linked list. For example, given ...
- 90.3k
2
votes
2
answers
2k
views
I'd like to use the "nested set model" but I'm obliged to have a GUID as primary key. How can I do without integers as pk?
I'm not aware how deep my tree will be. So I think the NSM is fit for me, reading some docs. In sql, this model suppose I'm using an integer value as primary key. I thought to create a twin table only ...
1
vote
3
answers
5k
views
Why is AdvancedDataGrid not updating when the HierarchicalData dataProvider is updated?
I have an AdvancedDataGrid (ADG) with a HierarchicalData dataProvider:
<mx:AdvancedDataGrid xmlns:mx="http://www.adobe.com/2006/mxml"
dataProvider="{__model.myHierarchicalData}"
...
- 10.7k
12
votes
6
answers
18k
views
Implementing a hierarchical data structure in a database
I know there are two approaches: adjacency list and nested tree. It's said that adjacency list can become slow to use on traversal because of numerous queries. But I don't know any realistic figures ...
Me_here
201
votes
21
answers
129k
views
How to build a tree from a flat structure?
I have a bunch of objects in a flat structure. These objects have an ID and a ParentID property so they can be arranged in trees. They are in no particular order.
Each ParentID property does not ...
- 5,970
2
votes
3
answers
25k
views
How to build a tree view with PHP / SQL?
What's the best way to:
Get the data from the db using a single query
Loop through the results building e.g. a nested unordered list
My table has id, name and parent_id columns.
Here's an update to my ...
- 33.5k
13
votes
4
answers
33k
views
SQL Query for Parent Child Relationship
I have db table with parent child relationship as:
NodeId NodeName ParentId
------------------------------
1 Node1 0
2 Node2 0
3 Node3 1
4 ...
- 503
59
votes
9
answers
41k
views
Is it possible to query a tree structure table in MySQL in a single query, to any depth?
I'm thinking the answer is no, but I'd love it it anybody had any insight into how to crawl a tree structure to any depth in SQL (MySQL), but with a single query
More specifically, given a tree ...
- 7,002