Use XML to retreive/insert data into SQL database

bamse111

New Member
I have some spare time so i was reading about xmlit says here:XML can be generated from a databasewith this code:\[code\]<%response.ContentType = "text/xml"set conn=Server.CreateObject("ADODB.Connection")conn.provider="Microsoft.Jet.OLEDB.4.0;"conn.open server.mappath("/db/database.mdb")sql="select fname,lname from tblGuestBook"set rs=Conn.Execute(sql)response.write("<?xml version='1.0' encoding='ISO-8859-1'?>")response.write("<guestbook>")while (not rs.EOF)response.write("<guest>")response.write("<fname>" & rs("fname") & "</fname>")response.write("<lname>" & rs("lname") & "</lname>")response.write("</guest>")rs.MoveNext()wendrs.close()conn.close()response.write("</guestbook>")%>\[/code\]after i read from the table and change data that i want , can i add the new data in the sql table again ?
plz provide me some links.Regards
 
Back
Top