Store the information in the database into an XML file under asp

save.asp

<!--#includefile="adovbs.inc"-->

<%

'Constantsfileincludedabove.

'If the file exists, delete it

DimobjFSO

SetobjFSO=Server.CreateObject("Scripting.FileSystemObject")

IfobjFSO.FileExists(Server.MapPath("db_xml.xml")) Then

objFSO.DeleteFileServer.MapPath("db_xml.xml")

EndIF

SetobjFSO=Nothing

'Variable declaration

DimcnnXML'ADOconnection

DimrstXML'ADOrecordset

'Create a data connection object

SetcnnXML=Server.CreateObject("ADODB.Connection")

'This is an example of connecting to the access database:

'cnnXML.Open"Provider=Microsoft.Jet.OLEDB.4.0;DataSource="_

'&Server.MapPath("db_scratch.mdb")&";"

'The following is an example to explain:

cnnXML.Open"Provider=SQLOLEDB;DataSource=10.2.1.214;"_

&"InitialCatalog=samples;UserId=samples;Password=password;"_

&"ConnectTimeout=15;NetworkLibrary=dbmssocn;"

SetrstXML=Server.CreateObject("ADODB.Recordset")

SetrstXML=cnnXML.Execute("SELECT*FROMscratchORDERBYid;")

Response.Write"<p>SavingdataasXML...</p>"&vbCrLf

'Save to xml format.

rstXML.SaveServer.MapPath("db_xml.xml"),adPersistXML

'Close the object and release the resource

rstXML.Close

SetrstXML=Nothing

cnnXML.Close

SetcnnXML=Nothing

Response.Write"<p>XMLfilewriten...</p>"&vbCrLf

Response.Write"<p>Click<ahref=""db_xml.xml"">here</a>toviewthefile.</p>"&vbCrLf

%>

Articles that may be of interest to you:

asp access database and generate XML file example Javascript+XMLHttpRequest+asp.net Refreshless reading database data ASP XML operation class code ASP read XML instance Youku album acquisition program Lei Feng version ASP XMLDom main methods of operating XML files on the server side and implementing the refinement of Asp operation Xml, including sample code ASP.NET+XML to create network hard disk principles analysis asp xmlhttp download a sentence asp.net TreeView and XML generate list tree three steps Asp parsing XML and displaying the source code paging method examples of XML to JSON in ASP.net processing XML data examples ASP.net XmlDocument class explains the classic code of how to add, delete, modify and search operations in asp.net.