classic asp called aspx/c#

I have a data.aspx /c# webpage that contain string like xml file.
<xml>
<Houses>
  <House>100 main street</House>
</Houses>
</xml>

And If I have classic asp webpage called abc.asp with <select></select> and I want <select> has datasource from data.aspx. Is it possible to code in classic asp on abc.asp and call/populate the data to <select></select>?
LVL 1
ITsolutionWizardAsked:
Who is Participating?
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
you have to write the binding yourself, something like this:

Set oXML = Server.CreateObject("MSXML2.DomDocument.6.0") 'creating the parser object
oXML.Load("data.aspx") 'loading the XML from the file 

opts = "<option value=''>Please Choose</option>"
For Each oNode In oXML.SelectNodes("/xml/houses")
    sValue = oNode.Text
    opts = opts & "<option value='" & sValue & "'>" & sValue & "</option>"
Next

Set oXML = Nothing

if opts <> "" then
     Response.Write "<select name='houses'>" & opts & "</select>"
end if

Open in new window

0
 
ITsolutionWizardAuthor Commented:
And I also want to data.aspx datasource to be be updated when it is called.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.