Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Controls > load table with data from xml file

Reply
Thread Tools

load table with data from xml file

 
 
faamugol
Guest
Posts: n/a
 
      03-04-2004
Hi,
I have data in the following xml file mydata.xml

<DATA
<RECORD datevalue="01.01.2003 10:00" mwh="0,001" />
<RECORD datevalue="01.01.2003 10:05" mwh="0,002" />
<RECORD datevalue="01.01.2003 10:10" mwh="0,001" />
<RECORD datevalue="01.01.2003 10:15" mwh="0,003" />
<RECORD datevalue="01.01.2003 10:20" mwh="0,001" />
</DATA

Set SourceObj
Server.CreateObject("MSXML2.DOMDocument.4.0"
SourceObj.async = fals
SourceObj.setProperty "SelectionLanguage"
"XPath
filename = Server.MapPath("mydata.xml"

SourceObj.load(filename

set ar1 = SourceObj.documentElement.selectNodes

("//RECORD/@datevalue"
set ar2
SourceObj.documentElement.selectNodes("//RECORD/@mwh"

I want to do the following

To store in my two tables tab1 and tab2 with data from ar1 and ar
without using a LOO
I use the JOIN functio
tab1 = Join(ar1, ','
tab2 = Join(ar2, ',') but dont wor

Can any one give me a idea or some links do it without

Thand you for your suggestio

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem to insert an XML-element by XSLT-converting from one XML-file into another XML-file jkflens XML 2 05-30-2006 09:41 AM
Different results parsing a XML file with XML::Simple (XML::Sax vs. XML::Parser) Erik Wasser Perl Misc 5 03-05-2006 10:09 PM
Table/table rows/table data tag question? Rio HTML 4 11-05-2004 08:11 AM
Problem with xml.load & xsl.load in JSP David Shen Javascript 0 08-28-2003 06:12 PM
Could not load type VTFixup Table from assembly Invalid token in v-table fix-up table. David Williams ASP .Net 2 08-12-2003 07:55 AM



Advertisments