[ASP.NET] Read data from the database to generate XML
Source: Unknown Author: Unknown Recommended rating: Visits: 8
Program EX: ================= String SQL = "SELECT ID, NAME FROM Content for XML AUTO, XMLDATA"; SQLConnection Conn = New SqlConnection (System.configuration.configurationSettings.Appsettings [ "testDataBase"]); SqlCommand cmd = new SqlCommand (sql, conn); conn.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 ();
