XML and XmlDataSource Control

XML to CSV

Beginneerr — Mon, 23 Nov 2009 18:40:51 GMT

hi all

i stuck with one bad prob.

i hv one xml file and i want to convert it into csv file.

i found some code but its not working. its using xslt but i hv no idea abt xslt,so i am not getting proper output.

plz reply asap

thanks

generic list to xml.

Mazenx — Mon, 23 Nov 2009 19:15:33 GMT

Hello , I have created a list of ( members for example ) using system.collections.generic , however...I want this list to be written as xml on my harddrive , I want exactly something like DataTable.WriteXML....can anyone suggest a solution ??

Get Started with NHibernate

yrb.yogi — Tue, 26 May 2009 06:10:45 GMT

Hello,

I have started to learn NHibernate....i have developed new apps with Nhibernate....i got error of mapping exception...

and same i found answer some where from the net....answer is to set build action property of xml file....

i have developed one website and i want to use nhibernate.....

so please tell me how to set xml's file build action property to "Embedded"...

because i could note found any such property of Build action......

where is property of build action of my apps file...???

ASP.NET 2.0: XPath or programmatically read XML document?

arecev — Fri, 20 Nov 2009 16:36:15 GMT

Just confirming a thought: when an ASP.NET 2.0 page has a gridview with an XmlDataSource, it is more efficient to choose which when you must apply business rules to the data before displaying it?

Approach #1:
Set hidden inputs to the values in the XML document using XPath, get and process the data using GridViewRow.FindControl, then set a separate gridview control to the finished value.

Approach #2:
Programmatically loop through the XML document, processing the data then set the gridview control to the finished value.

Approach 1 seems more efficient, but approach 2 seems easier to program and manage the code. Also, the second approach allows for clear separation of presentation and business logic.

Would appreciate opinions.

Thanks.

Xml validation on form without xsd.

charly.p — Mon, 23 Nov 2009 08:43:02 GMT

How to validate an given xml, typed by user, without having a xsd shema ?

It is more to check for xml syntax errors and all other stuff without an xsd shema.

As the provided xml is not always the same.

Any ideas ?

Kind regards,

how to call a static method from xslt in vs2008?

Eswaran_MCA — Mon, 23 Nov 2009 12:19:52 GMT

Hi all,

I am developing a web application using vs2008. In this I have class file. this class file contains a static method name called getString(inputParam) and returns a string. I need to call this function in my xslt file..

How to call that static function in xslt file?

Thanks
r.e

Is it better to use the XmlTextWriter or XmlWriter?

newbie2C# — Sun, 22 Nov 2009 21:43:30 GMT

I have been reading a little bit about some of the members in the XML namespace. Should I use the XmlTextWriter and XmlTextReader for most of my reading form and writing to XML file activities instead of the XmlWriter and XmlReader?

When should I use which one?

Drill Down possibility with an xml file(TreeView)

naijacoder74 — Mon, 23 Nov 2009 05:21:52 GMT

I have a XML Data file.
And i would like to be able to view the data via a drill down, treeview or hide/show view.

Any ideas looking for a Query,Jscript or asp.net possibilities.

Thanks in Advance

Web.sitemap use XMLDataSource

steschu — Sun, 22 Nov 2009 17:57:34 GMT

Hi,

I want to display a certain node's subnodes coming from a web.sitemap in a Repeater Control using a XmlDataSource

Why not a SiteMapDataSource then? Because, I haven't found a way to select a SiteMap node by a certain attribute. The nodes seem to be only accessible through their url-attributes. Since my desired SiteMapNode hasn't got any url-attribute, I use XmlDataSource.

The sitemap-File:

<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
    <siteMapNode title="MainCat" description="">
        <siteMapNode title="SubCat" description="">
            <siteMapNode url="~/page1.aspx" title="Page1 Title"></siteMapNode>
            <siteMapNode url="~/page2.aspx" title="Page2 Title"></siteMapNode>
            a.s.o

The XmlDataSource:

<asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/Web.sitemap" XPath="siteMap/siteMapNode/siteMapNode[@title='SubCat']"></asp:XmlDataSource>

In a Repeater I want to use HyperLinkControl, binding the NavigateUrl-Property to the url-Attribute and the text-Property to the text-Attribute. So I tried like

Text='<%# XPath("siteMapNode[@title]") %>'

It didn't work, neither did any other combination of '@' 'title' and 'siteMapNode'.

Can anyone provide the right syntax? That would be great.

Stephan

what is tokenized stream access with xml?

newbie2C# — Sun, 22 Nov 2009 18:58:32 GMT

I'm reading a tutorial that says "This article provides fast, tokenized stream access to XML rather than using an object model such as the XML Document Object Model (DOM)." I looked on the web for an explanation for tokenized stream access but couldn't find one. Can someone please tell me what it is or refer me to an article? Thanks.

binding xmldatasource to dropdownlist

dieseldave — Sat, 21 Nov 2009 20:53:11 GMT

Here is the xml - partial

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<geonames>
<country>
<countryCode>AD</countryCode>
<countryName>Andorra</countryName>
<isoNumeric>20</isoNumeric>
<isoAlpha3>AND</isoAlpha3>
<fipsCode>AN</fipsCode>
<continent>EU</continent>
<capital>Andorra la Vella</capital>
<areaInSqKm>468.0</areaInSqKm>
<population>72000</population>
<currencyCode>EUR</currencyCode>
<languages>ca,fr-AD,pt</languages>
<geonameId>3041565</geonameId>
<bBoxWest>1.42211079597473</bBoxWest>
<bBoxNorth>42.6586990356445</bBoxNorth>
<bBoxEast>1.78038918972015</bBoxEast>
<bBoxSouth>42.4350738525391</bBoxSouth>
</country>

Here in my code

<asp:XmlDataSource ID="XmlDataSource1" runat="server" 
    DataFile="~/xml/countryInfo.xml" XPath="geonames/country/countryName/">
</asp:XmlDataSource>

<asp:DropDownList ID="countryList" runat="server" DataSourceID="XmlDataSource1" 
    Font-Names="verdana" Font-Size="8pt" ForeColor="Black" 
    DataTextField="countryName" DataValueField="countryName">
</asp:DropDownList>

I must not be configuring the xpath correctly - i always get errors or the drop down is blank

Tgis version returns: Expression must evaluate to a node-set.

Arabic Data in XML File

aijazalimajor — Fri, 20 Nov 2009 11:38:19 GMT

How to store abrabic data in XML Document using asp.net?

xsl split

igharrac — Sat, 21 Nov 2009 07:50:07 GMT

I have the folowing xml and i want to do 3 things:

<product>
    <title>Title1</title>
    <link>http://www.homepages.nl/h1/id/OOSTENRIJK/places/test.html</link>
</product>

1: check in <link> if it contains www.homepages.nl

if true,

2: get "OOSTENRIJK" and put this in a node <city> (must use kind of split function so i can check on "/")

3:get "places" and put this in node <region> (must use kind of split function so i can check on "/")

output for this example should be:

<product>
    <title>Title1</title>
    <link>http://www.homepagea.nl/h1/id/OOSTENRIJK/places/test.html</link>
    <city>OOSTENRIJK</CITY>
    <region>places</region>
</product>

Does somebody nowa how to achieve this with an <xsl:template.

Regards

copy node from one xml doc to another

corbybender — Fri, 20 Nov 2009 14:12:34 GMT

I've tried a variety of things I've found on the net but nothing works. Here's the shakedown.

I have two xml documents. A source and a destination. I need to copy all the values from a node in the source document into the same node on the destination document.

Source Doc example:

</Location>

</Details>

</config>

Destination Doc has:

</Location>

</Details>

</config>

So basically I need the "MyItem" chunks of data from the first document to replace all the "MyItem" chunks in the destination document. I don't need to append them, just flat out replace basically the entire <Location> </Location> chunk.

Here's some of what I have tried to no avail...maybe seeing where I'm coming up short would help to point me in the right direction...

XmlTextReader mySourceReader = new XmlTextReader(this.txtSourceDoc.Text);

XmlDataDocument mySourceDoc = new XmlDataDocument();

mySourceDoc.Load(mySourceReader);

mySourceReader.Close();

XmlTextReader myDestinationReader = new XmlTextReader(this.txtDestinationDoc.Text);

XmlDataDocument myDestinationDoc = new XmlDataDocument();

myDestinationDoc.Load(myDestinationReader);

myDestinationReader.Close();

XmlNode rootDest = myDestinationDoc["/config"];

XmlNode nodeOrig = mySourceDoc["/config/Location/Details"].ChildNodes[1];

XmlNode nodeDest = myDestinationDoc.ImportNode(nodeOrig, false);

rootDest.AppendChild(nodeDest);

XmlTextWriter myWriter = new XmlTextWriter(this.txtDestinationDoc.Text, Encoding.UTF8);

myWriter.Formatting = Formatting.Indented;

myDestinationDoc.WriteTo(myWriter);

myWriter.Close();

Any help would be greatly appreciated. Thank you in advance for your time. -Corby-

I've tried a variety of things I've found on the net but nothing works. Here's the shakedown.

I have two xml documents. A source and a destination. I need to copy all the values from a node in the source document into the same node on the destination document.

Source Doc example:

</Location>

</Details>

</config>

Destination Doc has:

</Location>

</Details>

</config>

Here's some of what I have tried to no avail...maybe seeing where I'm coming up short would help to point me in the right direction...

XmlTextReader mySourceReader = new XmlTextReader(this.txtSourceDoc.Text);

XmlDataDocument mySourceDoc = new XmlDataDocument();

mySourceDoc.Load(mySourceReader);

mySourceReader.Close();

XmlTextReader myDestinationReader = new XmlTextReader(this.txtDestinationDoc.Text);

XmlDataDocument myDestinationDoc = new XmlDataDocument();

myDestinationDoc.Load(myDestinationReader);

myDestinationReader.Close();

XmlNode rootDest = myDestinationDoc["/config"];

XmlNode nodeOrig = mySourceDoc["/config/Location/Details"].ChildNodes[1];

XmlNode nodeDest = myDestinationDoc.ImportNode(nodeOrig, false);

rootDest.AppendChild(nodeDest);

XmlTextWriter myWriter = new XmlTextWriter(this.txtDestinationDoc.Text, Encoding.UTF8);

myWriter.Formatting = Formatting.Indented;

myDestinationDoc.WriteTo(myWriter);

myWriter.Close();

Any help would be greatly appreciated. Thank you in advance for your time. -Corby-

Example modal popup in XSL

Dangermouse — Wed, 18 Nov 2009 11:46:51 GMT

Hi, I have recently been using XSL and need to integrate the modal popup control inside. Can anybody provide an example of this please?

Specify variable columns in Xslt

l_szn — Fri, 20 Nov 2009 08:20:33 GMT

Hi, I have a problem I no way cannot solve .......

Suppose I have such an xml:

"<root>
<object>
<color>black</color>
<size>11aaaaaaaaaa</size>
<cost>22aaaaaaaaaaaaaaa</cost>
</object>
<object>
<color>green</color>
<size>33</size>
<cost>44</cost>
</object>
<object>
<color>red</color>
<size>55</size>
<cost>66</cost>
</object>
<object>
<color>black</color>
<size>77</size>
<cost>88</cost>
</object>
</root>",

How can I write a Xslt for it to get a table with the color, size and cost columns, but without specifying them explicitly in '<xsl:value-of>' tag ?.....

I mean these tag names may change, or their number may change ('root' and 'object' tags remain the same) ....

Currently my Xslt looks like this:

"<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="/">
<xsl:variable name="columns" select="3" />
    <HTML>
      <HEAD>
        <STYLE>
          .HDR {background-color:black;font-weight:bold;font-size:14px;font-family:Arial,Helvetica,sans-serif;border=2;color:white;}
        </STYLE>
      </HEAD>
      <BODY>

        <TABLE border="1">
   <thead>
       <tr>
       <xsl:for-each select="root/object[1]/*">
       <th>
       <xsl:value-of select="local-name() "/>
       </th>
       </xsl:for-each>
       </tr>
   </thead>
<tbody>

          <xsl:for-each select="root/object">
<tr>
      <xsl:if test="position() mod 2 = 1">
            <TD bgcolor="silver">
       <xsl:value-of select="."/>
       </TD>
          </xsl:if>
      <xsl:if test="position() mod 2 = 0">
            <TD bgcolor="white"><xsl:value-of select="."/>
                </TD>
          </xsl:if>
</tr>
          </xsl:for-each>
</tbody>
        </TABLE>
      </BODY>
    </HTML>
</xsl:template>
</xsl:stylesheet>"

Of course the result is a table with three columns where all three nodes are in the first cell ......

Loading xml with multiple records

RK123 — Wed, 18 Nov 2009 15:05:13 GMT

Hi,

I am very new to XML. I am running into a very weird problem. I have a powerbuilder app that consumes xml generated from a .net webservice. That webservice uses writexml method to generate XML based on a dataset. When queried on a single record the XML generated with single record is well consumed, but when the weservice returns multiple records in XML it is failing to load. I cannot find any special characters in it.What might be the problem. The encoding is UTF-16. I need some direction to even reaserch as I feel lost at this point.

Thanks

Getting XML from a URL programmatically

puggs — Thu, 19 Nov 2009 14:17:56 GMT

How can I call a URL from a code behind page to view the returned XML?

This URL contains details that need to be parsed before I finish creating all the elements on the web page.

For example:

https://example.com/xml/getresults.ns?myresult

returns:

<topnode>
<name>
<firstname>Phillip</firstname>
</name>
</topnode>

I need to parse the XML in the code behind without the client seeing the URL or the returned XML.

Many thanks

Defining the element node in non-sequence order in XSD

Thirumalai_pm — Thu, 19 Nov 2009 05:40:43 GMT

Hi Friends,

Pls let me know how to develop an XSD with elements in non sequence order in XSD. Consider I have the following node

<xs:element name="person">
    <xs:complexType>
      <xs:sequence>
       <xs:element name="familyName" />
        <xs:element name="firstName" />
      </xs:sequence>
    </xs:complexType>
</xs:element>

Here in XML the familyName, firstName must be in sequence order, like

But my requirement is - in XML the <familyName> and <firstName> can occur in any order. So <firstName> can be first and </familyName> can be second and vise-versa.

Can anyone pls let me know how to define like that.

Thanks. Thirumalai M

Need help with Linq to XML and XML Intellisense

atconway — Tue, 17 Nov 2009 14:52:45 GMT

1st: here is the simple .xsd I am using:

<?xml version="1.0" encoding="iso-8859-1"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="urn:Import:Error">
  <xs:element name="Datafeed">
    <xs:complexType>
      <xs:sequence>
	<xs:element name="Error">
	  <xs:complexType>
	    <xs:sequence>
		<xs:element name="Code" type="xs:unsignedShort" />
		<xs:element name="Message" type="xs:string" />
	    </xs:sequence>
	  </xs:complexType>
	</xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>

Here is the 'Imports' directive I use:

Imports <xmlns:DataError="urn:Import:Error">

Now here is the issue; I have (2) sets of code that should do the exact same thing, but I can only get the Linq to XML working where I hardcode the element names, as opposed to the one that uses the Intellisense. So here is the code that returns results properly parsed:

Dim MyXmlError = From xe In MyXmlDoc.Descendants("Datafeed") _
                 Select Code = xe.Element("Error").Element("Code").Value, _
                          Message = xe.Element("Error").Element("Message").Value

Here is the exact same code using the Intellisense (which I much prefer), but does not work. It returns with a statements of "Enumeration yielded no results" when debugging MyXmlError:

Dim MyXmlError2 = From xe In MyXmlDoc.Descendants.<DataError:Datafeed> _
                        Select Code = xe.<DataError:Error>.<DataError:Code>.Value, _
                               Message = xe.<DataError:Error>.<DataError:Message>.Value

So the above code is the one I am trying to get working. I have tried several variations, but still have not gotten it to read the XML properly. Can anyone spot out or help me update the code to work properly?

Thanks!

dataset writexml generates newdataset as a root element

mrugank1711 — Tue, 01 Sep 2009 17:13:52 GMT

I am trying to output a strongly typed dataset using the internal dataset.writexml method. The xml that is output is not valid because the root element is defined as "NewDataSet". Is there a way to write a dataset without the 'newDataSet' root element?

I created the strongly typed dataset using the Visual Studio 2008 Dataset template and importing an xsd file created from my xml. Do I need to modify the strongly typed dataset attributes so that the current root element does not have the System.Xml.Serialization.XmlRootAttribute ?

Thanks,

How do I query the root element value using Linq to XML

atconway — Wed, 18 Nov 2009 16:42:31 GMT

Ok, this should be the simplest thing to do, but I am missing something here. Take a look to the following XML:

<MyData1>
Hello
    <Child1>
    </Child1>

</MyData1>

How can I get the value of "Hello" from the root element using Linq to XML? I know that should be the easiest thing in the world, but I am not using the proper methods or something. I can easily write the query to drill down past the root, but getting the actual value from the root has slipped by me. I tried:

Dim XmlData = From xe In MyXmlDoc.Root.<.....

But using 'Root' produced an error stating it is not queryable. I could post some other variations I tried, but to save time could someone please point out how to write the Linq statement that will return back the value "Hello" into an anonomous type named "Message" or whatever?

Thank you!

Remove note in xml file

aspfun — Mon, 16 Nov 2009 22:19:02 GMT

I used dataset writexml method to write xml file as below:

<NewDataSet>
<SpecSum>
    <USER>ANDYK</USER>
    <Grouper>Allergy/Immunology</Grouper>
    <Auths>0</Auths>
    <Cost>0</Cost>
</SpecSum>
    ...... (many notes are here)
</NewDataSet>

How to remove <NewDataSet> note?

Data grouping with Listview

X-Zero — Tue, 17 Nov 2009 19:27:15 GMT

Hello everyone,

Right now, I am stuck on what to do next here. Basically, what I'm trying to figure out how to do data grouping using Listview. I have an XML and XSL file then using XMLdatasource to display the output in the Listview table.

My XML file looks similar to this:
<dataset>
   <data>
       <row>
           <value>Toyota</value>
           <value>12345</value>
           <value>Prius</value>
        </row>
       <row>
           <value>Toyota</value>
           <value>67891</value>
           <value>Matrix</value>
        </row>
       <row>
           <value>Honda</value>
           <value>912834</value>
           <value>Civic</value>
        </row>

</data>
</datset>
=======================================================

My XSLT file looks like this:
<xml version="1.0">
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<data>
    <xsl:for-each select="row">
         <row>
             <xsl:attribute name="Car">
                  <xsl:value-of select= "value[1]" />
             </xsl:attribute>

             <xsl:attribute name="ID">
                  <xsl:value-of select= "value[2]" />
             </xsl:attribute>

              <xsl:attribute name="Model">
                  <xsl:value-of select= "value[3]" />
             </xsl:attribute>
         </row>
    </for-each>
</data>
</xsl:stylesheet>
===================================
I want an output similar to this:
Toyota
    12345 - Prius
    67891 - Matrix
Honda
    912834 - Civic

The display layout doesn't really matter. It's just the matter of how to group the data.

Thanks!

Using session variable in XML tag

bbcompent1 — Wed, 11 Nov 2009 13:58:10 GMT

I'm trying to use the value of a session variable for this weather xml data feed. I can declare the variable just fine, however when I try to use it in the feed URL, it says the tag is not well formed. Here is what I have, probably would be a simple fix for one of you XML gurus...

http://feeds.weatherbug.com/rss.aspx?zipcode=<%=Session["zipcode"] %>&feed=currtxt

I can response.write the session variable just fine anywhere on the page. Please help :)