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>
