Hi this is the code i'm using:
VB Code:
Dim ds as new Dataset("data") ds.ReadXML("c:\\test.xml") With DataGrid1 .Datasource = dsAuthors .DataMember = "schedulle" .CaptionText = .Datamember End With
It gives an error on the ReadXML line:
"The same table(media) cannot be the child table in two nested relations"
If i try a more general xml it works fine but i really need to make it work :/ Help!
Here are the contents of test.xml
Code:<?xml version="1.0" encoding="UTF-8" ?> <Schedule xmlns="urn:ScheduleSchema.xml" xmlns:l="urn:schemas-rcsworks-com:LinkSchema" xmlns:p="urn:schemas-rcsworks-com:ProductSchema" xmlns:n="urn:schemas-rcsworks-com:NoteSchema" xmlns:sc="urn:schemas-rcsworks-com:ScriptSchema" xmlns:m="urn:schemas-rcsworks-com:MediaSchema" xmlns:s="urn:schemas-rcsworks-com:SongSchema" xmlns:t="urn:schemas-rcsworks-com:TrafficSchema" xmlns:w="urn:schemas-rcsworks-com:WebPageSchema" xmlns:c="urn:schemas-rcsworks-com:CategorySchema"> <Day date="2005-04-07"> <TimeMarker scheduledTime="10:58:00" index="344" revision="2" type="hard" startTime="10:58:00" /> <Group groupID="00650000001976030000" index="349" revision="4" intendedDuration="0.00" groupType="music" maxUnits="0" actualTime="10:59:55" actualDuration="4.51"> <Event eventID="1" eventType="link" elementSpecificData="0" status="notYet" timing="none" startOffset="0.00" startTime="10:59:55" scheduledDuration="5.00" segue="pause" failureCode="0" editCode="0"> <l:Link title="Sinal Hor?rio 5s" ID=" 33" internalID="007B00020000AD450000" thirdPartyAudioFileName="" category="s" level="1" packet="0" percentBack="100" dateAdded="2003-10-02" mediaField="" opening="" ending="" isVoiceTrack="0" materials="" stopset="No" lastPlayDate="2005-04-06" lastPlayTime="15:59:55" lastEditedDate="2005-04-04" enteredCategory="2003-10-02" playsInCategory="0" totalPlays="0" maintenanceFlag="0" comment="" isLive="0" isExternal="0" additionalArtists="" composers="" publisher="" lyricist="" isrc="" arranger="" license="" label="" recordNumber="" promoter="" country="" content="NO" address="" radioText="" barcode=""> <s:Codes energy=" " textureOpen=" " textureClose=" " soundCode1=" " soundCode2=" " opener=" " type=" " /> <m:Media ID="{42BEB7EA-09C8-48E3-852E-5AF5DC1D819A}" runTime="4.51" intro1="" intro2="" intro3="" fileName="{42BEB7EA-09C8-48E3-852E-5AF5DC1D819A}.wav" hookStart="" hookEnd="" trimStart="0.00" trimEnd="4.72" JITA="0" totalTime="4.72" earlyNextToPlay="" linkOverLapNTP=""> <m:Location protocol="unc" path="\\RR-BU\RCS_AUDIO\V14\!RENA-FM\AUDIO\" /> </m:Media> </l:Link> </Event> </Group> </Day> </Schedule>




Reply With Quote