XML / XSL

How to use createdocumentfragment(.NET) function to add a document fragment containing namespace prefix?

4-Feb-09 5:14

I did not verified this but my memory is that an entity is required for that character to be handled correctly by parsers etc.

http://www.google.com/#hl=en&q=xml+entity&btnG=Google+Search&aq=f&oq=xml+entity&fp=3WTwdsC3GPc[^]

cool_mars29-Jan-09 4:09

cool_mars

29-Jan-09 4:09

<report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<body>
<reportitems>
<textbox name="textbox1">
<rd:defaultname>textbox1</rd:defaultname>
<visibility>
<hidden>true</hidden>
</visibility>
<top>2.75in</top>
<width>1in</width>
<style>
<paddingleft>2pt</paddingleft>
<paddingright>2pt</paddingright>
<paddingtop>2pt</paddingtop>
<paddingbottom>2pt</paddingbottom>
</style>
<zindex>3</zindex>
<cangrow>true</cangrow>
<left>4.75in</left>
<height>1.125in</height>
<value>tttttttttttttttttttttttttttttttttttttttttttt</value>
</textbox>
</reportitems>
</body>
<language>en-US</language>
<topmargin>1in</topmargin>
</report>

I have a xml document like this, when i tried to use createdocumentfragment() to add another textbox node

<textbox name="textbox2">
<rd:defaultname xmlns:rd="#unknown">textbox2</rd:defaultname>
<visibility>
<hidden>true</hidden>
</visibility>
<top>2.75in</top>
<width>1in</width>
<style>
<paddingleft>2pt</paddingleft>
<paddingright>2pt</paddingright>
<paddingtop>2pt</paddingtop>
<paddingbottom>2pt</paddingbottom>
</style>
<zindex>3</zindex>
<cangrow>true</cangrow>
<left>4.75in</left>
<height>1.125in</height>
<value>ssssssssssssssssssssssssssssssssss</value>
</textbox>
since there is a <rd:defaultname xmlns:rd="#unknown"></rd:defaultname>, I get an error saying rd namespace not declared.

Anyone has some idea about it?

Thanks in advance!

Ricky

Re: How to use createdocumentfragment(.NET) function to add a document fragment containing namespace prefix? [modified]

George L. Jackson30-Jan-09 8:50

George L. Jackson

30-Jan-09 8:50

As far as I know, you have to repeat the explicit declarations in the document fragment:

<textbox xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" name="textbox2">
    <rd:defaultname xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox2</rd:defaultname>
    <visibility>
        <hidden>true</hidden>
    </visibility>
    <top>2.75in</top>
    <width>1in</width>
    <style>
        <paddingleft>2pt</paddingleft>
        <paddingright>2pt</paddingright>
        <paddingtop>2pt</paddingtop>
        <paddingbottom>2pt</paddingbottom>
    </style>
    <zindex>3</zindex>
    <cangrow>true</cangrow>
    <left>4.75in</left>
    <height>1.125in</height>
    <value>ssssssssssssssssssssssssssssssssss</value>
</textbox>

"We make a living by what we get, we make a life by what we give." --Winston Churchill

modified on Friday, January 30, 2009 3:03 PM

using intellisense in XSLT editor in VS2008

Member 197996529-Jan-09 2:50

Member 1979965

29-Jan-09 2:50

Greetings!

I would like to use XSLT for ASP server control generation, but when I try to get asp namespace in editor I'm not getting and intellisense for asp controls.

what url should I use for xmlns:asp to get it working?

thanks!

Not getting ANY help from this site on XSLT

crystal915428-Jan-09 3:56

28-Jan-09 3:56

I'll make this simple:

Here's my XML input:

<a>
<b>123</b>
<c>234</c>
<d>
<e id="c" />
<f id="a" />
</d>
</a>

I want this as output: (note all is same but e & f id's are alpha sorted

<a>
<b>123</b>
<c>234</c>
<d>
<f id="a" />
<e id="c" />
</d>
</a>

led mike28-Jan-09 4:39

28-Jan-09 4:39

crystal9154 wrote:
Not getting ANY help from this site on XSLT

crystal9154 wrote:
Could someone kindly offer me the correct xslt code

I'm sorry no one has offered to do your work for you, no really, I am. Dead | X|

crystal915428-Jan-09 4:57

28-Jan-09 4:57

bite me, no life

led mike28-Jan-09 5:00

28-Jan-09 5:00

f*** off a**hole

crystal915428-Jan-09 5:13

28-Jan-09 5:13

see thread above

led mike28-Jan-09 5:22

28-Jan-09 5:22

no, I really meant it, f*** off. Besides since you can't get your job done, how do you have the time to post your useless insults to me on the internet? Ah, maybe we are on to something here. Unsure | :~

crystal915428-Jan-09 5:46

28-Jan-09 5:46

obviously you possess zero life

crystal915428-Jan-09 5:59

28-Jan-09 5:59

hey sh-t for brains, led mike
i solved the problem myself so thanks for being an a-hole.
hey read your bio,
at least understanding your an a-hole is step 1 to recovery
buh bye

led mike28-Jan-09 6:08

28-Jan-09 6:08

crystal9154 wrote:
thanks for being an a-hole

No problem. Post some useless jackass questions anytime you want some more. I'm here all week.

crystal9154 wrote:
i solved the problem myself

Imagine that! What a novel idea! Are you sure that's what you are getting paid for though, I mean if they really want you to get other people to do your work using internet forums then perhaps you should have waited until someone provided you the code.

xslt: sort xml by child attribute and copy to new xml

indian14330-Jan-09 6:41

indian143

30-Jan-09 6:41

Hi Friend,

May be u r true but still but if u want to take help from others u should have patience. That we all should realize.

Thanks,
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

crystal915426-Jan-09 13:46

Re: xslt: sort xml by child attribute and copy to new xml

26-Jan-09 13:46

Could someone kindly offer me the correct xslt code to sort by factoryNum and copy to new xml, retaining all elements and attributes from original XML? Thanks in advance

'******************************
Here's my code but not working:
'******************************

Dim xslt As String =
"<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0'>" & _
"<xsl:template match='winelist'>" & _
"<xsl:for-each select='wine/winery'>" & _
"<xsl:sort select='@factoryNum' order='descending' data-type='number'/>" & _
"<xsl:copy-of select='.'/>" & _
"</xsl:for-each>" & _
"</xsl:template>" & _
"</xsl:stylesheet>"

'****************************
Here's my source xml:
'****************************

<?xml version="1.0" encoding="utf-16"?>
<winelist>
<wine>
<winery factoryNum="2">Lindeman's</winery>
<product>Bin 65</product>
<year>1998</year>
<prices>
<list>6.99</list>
<discounted>5.99</discounted>
<case>71.50</case>
</prices>
</wine>
<wine>
<winery factoryNum="1">Benziger</winery>
<product>Carneros</product>
<year>1997</year>
<prices>
<list>10.99</list>
<discounted>9.50</discounted>
<case>114.00</case>
</prices>
</wine>
<wine>
<winery factoryNum="4">Kendall Jackson</winery>
<product>Vintner's Reserve</product>
<year>1998</year>
<prices>
<list>12.50</list>
<discounted>9.99</discounted>
<case>115.00</case>
</prices>
</wine>
<wine>
<winery factoryNum="3">Duckpond</winery>
<product>Merit Selection</product>
<year>1996</year>
<prices>
<list>13.99</list>
<discounted>11.99</discounted>
<case>143.50</case>
</prices>
</wine>
</winelist>

George L. Jackson28-Jan-09 6:02

George L. Jackson

28-Jan-09 6:02

Demanding help and insulting members who volunteer their expert assistance is pitiful!

As far as your problem is concerned, I would place the result of the sorted nodes in a variable. Then, I would copy the sorted nodes in the variable.

"We make a living by what we get, we make a life by what we give." --Winston Churchill

How do I read this XML file?

MaWeRic25-Jan-09 22:59

MaWeRic

25-Jan-09 22:59

I have an XML file looking like this (just an example):

<br />
  <?xml version="1.0" encoding="UTF-8" ?> <br />
 <family><br />
 <name xmlns="http://www.opentrans.org/XMLSchema/1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0" type="standard"><br />
  <firstname>Tom</firstname> <br />
  <lastname>Smith</lastname> <br />
  </name><br />
 <name xmlns="http://www.opentrans.org/XMLSchema/1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0" type="standard"><br />
  <firstname>Dale</firstname> <br />
  <lastname>Smith</lastname> <br />
  </name><br />
  </family><br />

I can read up the document as a XMLDocument and navigate through SelctNodes if the Namespace attribute is not present. I have understood that I need to specify some kind of namespace using a namespace manager.

This is my code so far :

<br />
'Create objcts<br />
Dim m_xmld As XmlDocument<br />
Dim m_nodelist As XmlNodeList<br />
Dim m_node As XmlNode<br />
'Create the XML Document<br />
m_xmld = New XmlDocument()<br />
'Load the Xml file<br />
m_xmld.Load("D:\family.xml")<br />
'Get the list of name nodes <br />
m_nodelist = m_xmld.SelectNodes("/family/name")<br />
'How many nodes<br />
msgbox(m_nodelist.count)<br />

Anyone can fill in the missing parts for me? C# or VB.NET .. doesn't matter Big Grin | :-D

Regards // M

Re: How do I read this XML file?

led mike26-Jan-09 4:49