I have a stored procedure that returns a dataset. I want this dataset to
fill a tree view.
Here is the Stored Procedure Query
SELECT Product.Product_#, Product.Part_Number, Status.Status,
Traveler_Step.Step, Station.Station_Name
FROM Product INNER JOIN
Traveler_Step ON Product.Traveler_Step_# =
Traveler_Step.Traveler_Step_# INNER JOIN
Station ON Traveler_Step.Station_# = Station.Station_#
INNER JOIN
Status ON Product.Status_# = Status.Status_#
WHERE (Station.Station_# = 8)
Here is a typical result
Product_# Part_Number Status Step
Station_Name
----------- -------------------- -------------------- ----------- --------------------
48 123789 Active 40 Hot Mill
231 U06107LG Active 20 Hot Mill
I would like the tree view master node to be Station Name, the first child
node to be the Part Number with an icon next to it indicating the status,
next child node under part_number the Step and Product_#.
So this is what I am after
HotMill
|
-----(Active icon) 123789
|
------40
|
------48
I understand I need hierarchical data, but the stored procedure only returns
one dataset. How can I do this?
Thanks.
John