首先有三张表
Table1 ----QuestQuestID
Name
DescriptorTable2----ConditionConditionID
QuestID
Type
DescriptorTable3----RewardRewardID
QuestID
ItemId
Descriptor
现在想把三张表 根据QuestID 导出XML 需要XML格式
<root>
<item QuestID="" Name="" Descriptor = "" >
<Condition ConditionID="" QuestID ="" Type="" Descriptor/>
<Reward>
<item QuestID=""ItemId="" Descriptor=""/>
<item QuestID=""ItemId="" Descriptor=""/>
</Reward>
</item>
<item QuestID="" Name="" Descriptor = "" >
<Condition ConditionID="" QuestID ="" Type="" Descriptor/>
<Reward>
<item QuestID=""ItemId="" Descriptor=""/>
<item QuestID=""ItemId="" Descriptor=""/>
</Reward>
</item>
</root>麻烦各位高手,给出思路,和关键代码。。谢谢了
Table1 ----QuestQuestID
Name
DescriptorTable2----ConditionConditionID
QuestID
Type
DescriptorTable3----RewardRewardID
QuestID
ItemId
Descriptor
现在想把三张表 根据QuestID 导出XML 需要XML格式
<root>
<item QuestID="" Name="" Descriptor = "" >
<Condition ConditionID="" QuestID ="" Type="" Descriptor/>
<Reward>
<item QuestID=""ItemId="" Descriptor=""/>
<item QuestID=""ItemId="" Descriptor=""/>
</Reward>
</item>
<item QuestID="" Name="" Descriptor = "" >
<Condition ConditionID="" QuestID ="" Type="" Descriptor/>
<Reward>
<item QuestID=""ItemId="" Descriptor=""/>
<item QuestID=""ItemId="" Descriptor=""/>
</Reward>
</item>
</root>麻烦各位高手,给出思路,和关键代码。。谢谢了
是三张表导出一个XML文件。。
好像是我还没表达清楚。 我现在有三张表、 都有QuestID字段 然后需要导成一个XML文件。 格式就是上面那个样子的
<item QuestID="" Name="" Descriptor = "" />
<item QuestID="" Name="" Descriptor = "" />
<item QuestID="" Name="" Descriptor = "" />
</root>
这样的另外两张表妹办法关联啊
呃,现在我用XmlTextWriter.WriteStartDocument() 搭出格式了.. 数据与字段名要怎么循环添加进去呢?(是三张表)
现在导出是分开的,三个表的对应关系要怎么设置呢?
ds.Relation.Add(IARE);
DtatRelation ICRE = new DtatRelation("QRRE1",ds.Tables["Quset"].Columns["QuestID"],ds.Tables["Condition"].Columns["QuestID"]);
ds.Relation.Add(ICRE);ds.WriteXml("TestXml.xml");导出后
<root>
<Quest QuestID="1"/>
<Quest QuestID="2"/>
<Quest QuestID="3"/>
<Reward id = "0" QuestID="1"/>
<Reward id = "1" QuestID="1"/>
<Reward id = "2" QuestID="1"/>
<Reward id = "3" QuestID="1"/>
<Condition id = "0" QuestID="1">
<Condition id = "1" QuestID="2">
<Condition id = "2" QuestID="3">
<Condition id = "3" QuestID="4">
</root>是这样的格式、、