Accessing an XML sequence
-
Hi I'm trying to access a sequence which is part of a node in an XML file.
<property pr_ref="ABC" ... > <sellingpoint text="HALLWAY" /> <sellingpoint text="DINING ROOM" /> <sellingpoint text="KITCHEN" /> </property>I can iterate through the "property" nodes and retrieve their columns (pr_ref) but how on earth do I access the sequence of selling points? I've tried childrows and parents rows and I'm lost! I'm using VB.NET and I have the entire file in a DataSet. The second table of the dataset seems to contain ALL of the sellingpoint rows, not just those related to the one property.:confused: I'm desperate! Bernhard Don't worry, nobody lives forever. -
Hi I'm trying to access a sequence which is part of a node in an XML file.
<property pr_ref="ABC" ... > <sellingpoint text="HALLWAY" /> <sellingpoint text="DINING ROOM" /> <sellingpoint text="KITCHEN" /> </property>I can iterate through the "property" nodes and retrieve their columns (pr_ref) but how on earth do I access the sequence of selling points? I've tried childrows and parents rows and I'm lost! I'm using VB.NET and I have the entire file in a DataSet. The second table of the dataset seems to contain ALL of the sellingpoint rows, not just those related to the one property.:confused: I'm desperate! Bernhard Don't worry, nobody lives forever.Well, if you have created the class for handling your dataset (Generate code or something), then you should be able to use a function of
propertyRow, which named likeGetSellingpointRows(). If you don't see it, then you can try using GetChildRows anyway. I can't help you much with VB, but here is a link to IBuySpy[^]. You can download a VB version and see how they did this (look in PortalCfg.vb and Components/Configuration.vb): Philip Patrick Web-site: www.stpworks.com "Two beer or not two beer?" Shakesbeer