请问怎样将SQL Server 2000中，数据表的数据导出成一个XML的文件？

Question

把数据从sql读到ds中,然后writexml不行?
读到ds后!
ds.WriteXml(filename,System.Data .XmlWriteMode.IgnoreSchema);

Answer 1

SELECT Customers.CustomerID, ContactName,
       Orders.OrderID, OrderDate, Orders.CustomerID,
       ProductID, Quantity
FROM Customers, Orders, [Order Details]
WHERE Customers.CustomerID = Orders.CustomerID
AND Orders.OrderID = [Order Details].OrderID
ORDER BY Customers.CustomerID, Orders.OrderID
FOR XML AUTO, XMLDATA
------------------
or DataSet.GetXml();