dougcoulter
Programmer
Hello all. I am working on a project for displaying and managing a modest inventory. The inventory data is located in an MSDE database and I would like to work with the TreeView as the primary control. The data is stored in five (5) hierarchical tables. I start with a root table, which is then related to a child table which is then related to another child table, etc. It is essentially the same as a Windows Explorer hierarchy (which is why I like the idea of the TreeView), except instead of files, I am primarily dealing with parts.
I have currently set up 5 DataAdapters (1 for each table), which are used to fill a single DataSet. I am currently populating the contents of the TreeView in a just in time fashion (i.e.: filling a parameterized query DataAdapter based on the expanded TreeView node). The DataTables in my DataSet are also only populated based on what node is selected. I am wondering if this is the best way to go, or should I just FULLY populate the DataSet (all parts in the inventory) initially and allow for a manual refresh. If I do FULLY populate the DataSet, should I also FULLY populate the TreeView as well? As an example, let's say we are talking a total of 3500 records (spread across the 5 tables). I want to make it as easy on myself as possible when it comes to enabling data manipulations (adding, editing and deleting records), which will have to be updated back through the DataAdapter(s).
I hope this makes sense. Thanks...
I have currently set up 5 DataAdapters (1 for each table), which are used to fill a single DataSet. I am currently populating the contents of the TreeView in a just in time fashion (i.e.: filling a parameterized query DataAdapter based on the expanded TreeView node). The DataTables in my DataSet are also only populated based on what node is selected. I am wondering if this is the best way to go, or should I just FULLY populate the DataSet (all parts in the inventory) initially and allow for a manual refresh. If I do FULLY populate the DataSet, should I also FULLY populate the TreeView as well? As an example, let's say we are talking a total of 3500 records (spread across the 5 tables). I want to make it as easy on myself as possible when it comes to enabling data manipulations (adding, editing and deleting records), which will have to be updated back through the DataAdapter(s).
I hope this makes sense. Thanks...