音乐数据库的xml [英] xml for music database
问题描述
嗨
我有来自Discogs.com的 XML格式的音乐收藏(下面的示例)，我想将其添加到数据表/数据源中，然后以文本或数据库样式的方式逐一读取数据.但是我在导入整个xml时遇到了麻烦 将文档记录到数据源中(仅显示父节点)，然后能够在esle中读取.
I have a music collection in XML format from Discogs.com (a sample below) and would like to add it to a datatable/datasource then read the data out one by one in a text or in a database style way. However I have trouble importing the entire xml document in (just showing the parent nodes) into a datasource and then being able to read in esle where.
谢谢
示例
<释放num ="124">
<releases num="124">
< release id =" 367741"状态=接受的"<图像><图像的高度=" 600" type ="primary" uri ="http://api.discogs.com/image/R-367741-1173536564.jpeg" uri150 ="http://api.discogs.com/image/R-150-367741-1173536564.jpeg"宽度="600" /<图像高度="600" type ="secondary" uri ="http://api.discogs.com/image/R-367741-1173536575.jpeg" uri150 ="http://api.discogs.com/image/R-150-367741-1173536575.jpeg"宽度="600" /</images>艺术家<艺术家< id> 7987</id>名称警察; /><加入/>"角色/><曲目/></artist>/artists> title® Reggatta De Blanc</title< labels< labels>< label catno ="AMLH 64792"；名称="A& M记录"； /</labels> extraartists>艺术家< id> 1073593</id>名称Michael 罗斯(3)//名字/////////////////////////////////////////////////////////////////////////id> 1907359</name" Janette Beckman</name> anv/>< join/>"角色摄影 通过[Back]/role> tracks/></artist> artist< id> id 2234773</id< id"名称James James Wedge</name< anv>< ；通过[Front]//role> tracks////artist< artist&id; 7987</id>< name"警察； </name> anv/< join/>角色生产者，按排列，Noises//role<轨道/</artist>< artist> id> 112605</id>名称Nigel Gray</名称> anv/>< join/>角色生产者，工程师</角色<轨道 /</artist>艺术家< id> 95878</id<名称>安迪·萨默斯(Andy Summers)//名称< anv" Summers</anv< join/>"笔迹/角色A2，A5/曲目/artist/artist id 126442/id姓名Stewart Copeland& Copeland&nv; join/"角色" Written-By</role"轨道> A2，A5</轨道<艺术家> ；< id> 126442</id>名称Stewart Copeland</name< anv> S.谷轮</anv>加入 />角色" -By"轨道< A3，B2，B4，B5<轨道</artist>/artist< id> 13961< id>名称; sting< anv/>< join/>角色-Written-By< tracks<轨道A1至B1，B3， B6< tracks>/artist</extraartists>< formats>< format name ="Vinyl"
<release id="367741" status="Accepted"><images><image height="600" type="primary" uri="http://api.discogs.com/image/R-367741-1173536564.jpeg" uri150="http://api.discogs.com/image/R-150-367741-1173536564.jpeg" width="600" /><image height="600" type="secondary" uri="http://api.discogs.com/image/R-367741-1173536575.jpeg" uri150="http://api.discogs.com/image/R-150-367741-1173536575.jpeg" width="600" /></images><artists><artist><id>7987</id><name>Police, The</name><anv /><join /><role /><tracks /></artist></artists><title>Reggatta De Blanc</title><labels><label catno="AMLH 64792" name="A&M Records" /></labels><extraartists><artist><id>1073593</id><name>Michael Ross (3)</name><anv /><join /><role>Art Direction, Design</role><tracks /></artist><artist><id>1907359</id><name>Janette Beckman</name><anv /><join /><role>Photography By [Back]</role><tracks /></artist><artist><id>2234773</id><name>James Wedge</name><anv /><join /><role>Photography By [Front]</role><tracks /></artist><artist><id>7987</id><name>Police, The</name><anv /><join /><role>Producer, Arranged By, Noises</role><tracks /></artist><artist><id>112605</id><name>Nigel Gray</name><anv /><join /><role>Producer, Engineer</role><tracks /></artist><artist><id>95878</id><name>Andy Summers</name><anv>Summers</anv><join /><role>Written-By</role><tracks>A2, A5</tracks></artist><artist><id>126442</id><name>Stewart Copeland</name><anv>Copeland</anv><join /><role>Written-By</role><tracks>A2, A5</tracks></artist><artist><id>126442</id><name>Stewart Copeland</name><anv>S. Copeland</anv><join /><role>Written-By</role><tracks>A3, B2, B4, B5</tracks></artist><artist><id>13961</id><name>Sting</name><anv /><join /><role>Written-By</role><tracks>A1 to B1, B3, B6</tracks></artist></extraartists><formats><format name="Vinyl"
推荐答案
您已经尝试过
TheDataSet.ReadXML(ThePathOfTheXMLFile)
这篇关于音乐数据库的xml的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
