[ASP.NET] Read data from the database to generate XML

xiaoxiao2021-03-06  58

Program EX:

==================

String SQL = "SELECT ID, NAME FROM Content for XML Auto, XMLDATA";

Sqlconnection conn = new sqlconnection (system.configuration.configurationsttings.appsettings ["testdatabase"]);

Sqlcommand cmd = new SQLCOMMAND (SQL, CONN);

Cn.open ();

XmlTextReader objxmlreader = (xmlTextReader) cmd.executexmlreader ();

DataSet DS = New Dataset ();

DS.DataSetName = "XML";

DS.Readxml (ObjxmlReader, XmlReadmode.fragment);

DS.Writexml (Server.MAppath ("XML.xml"));

CONN.CLOSE ();

转载请注明原文地址:https://www.9cbs.com/read-90842.html

New Post(0)