I basically want to pull raw data from a SQL Server 2000 DB table into an XML page (looped data), and display this data in an ASP.NET page. I've looked high and low, but can't find info on how to do this. The closest thing that I've found is from W3Schools, but it uses ASP instead of ASP.NET. This is the URL for that page: http://www.w3schools.com/xml/xml_server.asp
...and this is the code that they reference:
response.ContentType = "text/xml"
sql="select fname,lname from tblGuestBook"
set rs=Conn.Execute(sql)rs.MoveFirst()response.write("<?xml version='1.0' encoding='ISO-8859-1'?>")
while (not rs.EOF)
response.write("<fname>" & rs("fname") & "</fname>")
response.write("<lname>" & rs("lname") & "</lname>")
So is there either a way to do this in ASP.NET easily, or a way to do the same thing in an XML page? Thanks for any help.