使用VB.NET写入XML文件 [英] Write XML File using VB.NET
问题描述
我有以下查询,其中包括创建XML文件的几个子选择. 选择 I have the following query which includes several subselects which creates an XML file. SELECT ( imageid AS , 图像说明 AS
imagecatalogueno = dbo . ProductCatelogue
FOR <跨度le ="color:#0000ff; font-size:xx-small"> XML AUTO ,
产品可用 , productrating , ProductUserDefined1 , ProductUserDefined2 , ProductUserDefined3 , ProductUserDefined4 , ProductUserDefined6 , ProductUserDefined7 , , ProductUserDefined9 , ProductUserDefined10 , , TemplatePage , ShippingClass , ,
( 选择 SKU , 状态 , 变体 , 销售价格 FROM
位置 = dbo 产品 . ProductCatelogue FOR XML 变量" ), 元素
( SELECT imageid AS id,imagecaption AS caption FROM Image
WHERE imagecatalogueno = dbo.Product.ProductCatelogue
FOR XML AUTO, ROOT('Images'),ELEMENTS,TYPE),
Productavailable,productrating,productmanufacturer,ProductUserDefined1,ProductUserDefined2,ProductUserDefined3,ProductUserDefined4,ProductUserDefined5,
ProductUserDefined6,ProductUserDefined7,ProductUserDefined8,ProductUserDefined9,ProductUserDefined10,ProductSearch,TemplatePage,ShippingClass,ShippingSurcharge,
( SELECT SKU,InstockQty, status,Variant,RRPPrice,SellingPrice FROM Variant
WHERE productcatalogue = dbo.Product.ProductCatelogue
FOR XML AUTO,ROOT('Variants'),ELEMENTS,TYPE),
(
选择 类别 类别订单 FROM 类别
WHERE productcatalogueno dbo . . 自动 , ), ELEMENTS , TYPE )
SELECT category,categoryorder FROM category
WHERE productcatalogueno = dbo.product.ProductCatelogue
FOR XML AUTO,ROOT('Categories'),ELEMENTS,TYPE)
从
产品
FOR
推荐答案
您可以读取DataTable或DataSet,然后使用WriteXML方法将所有数据写入XML文件.
Dim dbadp作为新的SQLDataAdapter("Select * From表",连接字符串)
dbadp.Fill(dTable)
dbadp.dispose()
dTable.WriteXML("C:\ Test.xml")
You can read a DataTable or a DataSet and then use the WriteXML method to write all the data to the XML file.
Dim dbadp as new SQLDataAdapter("Select * From Table", connectionstring)
dbadp.Fill(dTable)
dbadp.dispose()
dTable.WriteXML("C:\Test.xml")
这篇关于使用VB.NET写入XML文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!