1,216
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" encoding="utf-8" ?>
- <root startDate="2010-01-01" endDate="2010-01-01">
- <table name="tablename">
- <record>
<field name="billno" type="string">123456</field>
<field name="chandi" type="string"/><!__这里没有值__>
<field name="indate" type="string">2010-01-01</field>
<!__还有好几个别的字段,这里省略。。。。。。。。__>
</record>
- <record>
<field name="billno" type="string">222222</field>
<field name="chandi" type="string"/>
<field name="indate" type="string">2010-01-01</field>
<!__还有好几个别的字段,这里省略。。。。。。。。__>
</record>
</table>
</root>
use [northwind]
go
select 1 as tag,
null as parent,
'2010-01-01' as [root!1!startDate],
'2010-01-01' as [root!1!endDate],
null as [table!2!name],
null as [record!3],
null as [field!4!name],
null as [field!4!type],
null as [field!4]
union all
select 2,1,'','', 'tablename','' ,'','',''
union
select 3,2,'','', '','' ,'' ,'',''
union
select 4,3,'','','','',ContactName ,City,customerid
from customers
FOR XML EXPLICIT
XML_F52E2B61-18A1-11d1-B105-00805F49916B
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<root startDate="2010-01-01" endDate="2010-01-01"><table name="tablename"><record><field name="Alejandra Camino" type="Madrid">ROMEY</field><field name="Alexander Feuer" type="Leipzig">MORGK</field><field name="Ana Trujillo" type="México D.F.">ANATR</field
me="Henriette Pfalzheim" type="Köln">OTTIK</field><field name="Horst Kloss" type="Cunewalde">QUICK</field><field name="Howard Snyder" type="Eugene">GREAL</field><field name="Isabel de Castro" type="Lisboa">PRINI</field><field name="Jaime Yorres" type="San
ork">HUNGO</field><field name="Patricio Simpson" type="Buenos Aires">CACTU</field><field name="Paul Henriot" type="Reims">VINET</field><field name="Paula Parente" type="Resende">WELLI</field><field name="Paula Wilson" type="Albuquerque">RATTC</field><field
(所影响的行数为 94 行)
Dim strSql As String
Dom oDom as new DomDocument
strSql = "select * from tb where..."
Set rs = Conn.Execute(strSql)
rs.Save oDom , adPersistXML
rs.Close
http://www.ehow.com/how_5974702_create-file-database-using-vb.html