Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > XML > simple(?) xml/xsl problem with xml from sql query

Reply
Thread Tools

simple(?) xml/xsl problem with xml from sql query

 
 
dSchwartz
Guest
Posts: n/a
 
      03-05-2004
I'm creating xml files from a dataset:
myDataSet.WriteXml(m_XmlFile, XmlWriteMode.IgnoreSchema);

and saving them to disk. Then i want to use the Xml control to format
this xml with xsl stylesheet. here is part of my xml file created by
the line above:

<?xml version="1.0" standalone="yes" ?>
<NewDataSet>
<articles>
<XML_F52E2B61-18A1-11d1-B105-0080F4...>
<sm_articles article_id="2" article_title="xxxx" ... />
<sm_articles article_id="3" article_title="yyyy" ... />
</XML_F52E.......>
</articles>
</NewDataSet>

Now in my xslt i can do a for-each select="//articles" and it will
give me one item, but i'm not able to get past the <XML_.... tag. If
i try select="//sm_articles" i don't get errors, like its returning an
empty node.

so my question is what is the <XML_.... tag all about and how do i get
past it? If i manually take that tag out then my Xml control works
fine with my xsl stylesheet, but i have to build these xml files on
the fly from sql server.

Thanks for your time!
 
Reply With Quote
 
 
 
 
Bryant Likes
Guest
Posts: n/a
 
      03-06-2004
"dSchwartz" <> wrote in message
news: om...
> I'm creating xml files from a dataset:
> myDataSet.WriteXml(m_XmlFile, XmlWriteMode.IgnoreSchema);


Where are you getting the XML in the DataSet from? That looks like the
column header that is returned when you run a FOR XML Query.

--
Bryant


 
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
SQL Server Scripts : List all tables name that contain particularcolumn name using SQL Query jayeshsorathia@gmail.com ASP .Net 0 08-31-2012 07:35 AM
SQL Reference, SQL Queries, SQL help ecoolone ASP .Net 0 01-03-2008 10:58 AM
What Happened to Sql Enterprise Manager and Sql Query Analyser in Visual Studio 2005 Edward ASP .Net 4 04-10-2006 04:15 PM
Build dynamic sql query for JSTL <sql:query> Anonymous Java 0 10-13-2005 10:01 PM
Tools to extract data from SQL database and convert it into XML & insert XML data into SQL databases Harry Zoroc XML 1 07-12-2004 10:10 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57