StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16318530
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-05-01T12:58:11.237
FavoriteCount
0
LastActivityDate
2013-05-01T14:27:59.437
LastEditDate
2013-05-01T14:27:59.437
LastEditorUserId
682762
OwnerUserId
682762
ParentId
16318436
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>So I have a working version of code that takes care of your requirement. The trick is to check whether the node already exists and add to that instead of creating a new node everytime. We do the tree view generation in steps <li>1. Get a List of Mappings from XML</li> <li>2. Generate TreeView by iterating through the mapping List</li></p> <p>Notes : <li>1. This code can be optimized further, but I would leave that to you </li> <li>2. <code>treeView1</code> refers to an object of type <code>System.Windows.Forms.TreeView</code></p> <pre><code> /// <summary> /// Initalizes Tree View /// </summary> private void InitializeTreeView() { var mappingList = ReadXmlData(); BuildTree(mappingList); } /// <summary> /// Reads Mappings from xml file to a List /// </summary> /// <returns></returns> private List<Mapping> ReadXmlData() { var mappingList = new List<Mapping>(); var reader = new XmlTextReader(@"D:\data.xml"); while (reader.Read()) { reader.ReadToFollowing("system"); string system = reader.ReadString(); reader.ReadToFollowing("subsystem"); string subSystem = reader.ReadString(); reader.ReadToFollowing("subsubsystem"); string subSubSystem = reader.ReadString(); mappingList.Add(new Mapping() { _system = system, _subSystem = subSystem, _subSubSystem = subSubSystem }); } return mappingList; } /// <summary> /// Builds Tree /// </summary> /// <param name="mappingList"></param> private void BuildTree(List<Mapping> mappingList) { foreach (var mapping in mappingList) { var systemNode = FindNode(mapping._system, NodeType.System); if (string.IsNullOrEmpty(systemNode.Text)) { string nodeText = NodeType.System.ToString() + " - " + mapping._system; ; systemNode.Text = nodeText; systemNode.Name = nodeText; treeView1.Nodes.Add(systemNode); } var subSystemNode = FindNode(mapping._subSystem, NodeType.SubSystem); if (string.IsNullOrEmpty(subSystemNode.Text)) { string nodeText = NodeType.SubSystem.ToString() + " - " + mapping._subSystem; subSystemNode.Text = nodeText; subSystemNode.Name = nodeText; systemNode.Nodes.Add(subSystemNode); } var subSubSystemNode = FindNode(mapping._subSubSystem, NodeType.SubSubSystem); if (string.IsNullOrEmpty(subSubSystemNode.Text)) { string nodeText = NodeType.SubSubSystem.ToString() + " - " + mapping._subSubSystem; subSubSystemNode.Text = nodeText; subSubSystemNode.Name = nodeText; subSystemNode.Nodes.Add(subSubSystemNode); } } } /// <summary> /// Returns an existing node from the treeview other-wise returns a new node /// </summary> /// <param name="data"></param> /// <param name="type"></param> /// <returns></returns> private TreeNode FindNode(string data, NodeType type) { string text = type.ToString() + " - " + data; if (treeView1.Nodes.Find(text, true).FirstOrDefault() != null) { return treeView1.Nodes.Find(text, true).FirstOrDefault(); } else { return new TreeNode(); } } /// <summary> /// Class for Mapping /// </summary> public class Mapping { public string _system; public string _subSystem; public string _subSubSystem; } /// <summary> /// Type of Node /// </summary> public enum NodeType { System = 0, SubSystem = 1, SubSubSystem = 2 } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POC# Populating treeview from my XML file, whilst filtering it for no repeats
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. UScvraman
UserOwnerUserId
1. UScvraman
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.