save a TreeView in database [modified]
-
i want to save a TreeView in database i designed a table with three fields (ID , NodeName,UpareNodeID) and create a relation ship with ID and UpareNodeID is it correct? if it is , how can i retrieve thees nodes with the best performance ? i want to know if there is a better solution to save and retrieve this kind of collection thanks!
modified on Monday, May 10, 2010 12:08 PM
-
i want to save a TreeView in database i designed a table with three fields (ID , NodeName,UpareNodeID) and create a relation ship with ID and UpareNodeID is it correct? if it is , how can i retrieve thees nodes with the best performance ? i want to know if there is a better solution to save and retrieve this kind of collection thanks!
modified on Monday, May 10, 2010 12:08 PM
-
i want to save a TreeView in database i designed a table with three fields (ID , NodeName,UpareNodeID) and create a relation ship with ID and UpareNodeID is it correct? if it is , how can i retrieve thees nodes with the best performance ? i want to know if there is a better solution to save and retrieve this kind of collection thanks!
modified on Monday, May 10, 2010 12:08 PM
Where you are retrieving the data to populate the treeview, you should look at lazy loading it. In other words, if you have a deep hierarchy with lots of records, you can improve the responsiveness of your application and the overall feel for your users just by loading data as it's needed.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith
As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
-
i want to save a TreeView in database i designed a table with three fields (ID , NodeName,UpareNodeID) and create a relation ship with ID and UpareNodeID is it correct? if it is , how can i retrieve thees nodes with the best performance ? i want to know if there is a better solution to save and retrieve this kind of collection thanks!
modified on Monday, May 10, 2010 12:08 PM
You may use XML for this with succes! :) Give it a try. Good luck!
Alex Manolescu