|
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
|
|
|
|
|
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
Regards // M
|
|
|
|
|
|
I used the link and could get all my orders suing namespace. Under each namespace there is a lot of elements like <order_id> and others.
I loop through my orders without problems.
But how do I select a child to a node using namespace? releative XPath in other words.
My code now look like this:
'Objects()
Dim XDoc As New XmlDocument
Dim Orders As XmlNodeList
'Try to read doc
XDoc.Load(ImportFile)
'Create an XmlNamespaceManager for resolving namespaces.
Dim XN As XmlNamespaceManager = New XmlNamespaceManager(XDoc.NameTable)
XN.AddNamespace("Order", "http://www.opentrans.org/XMLSchema/1.0")
'Get Orders from XML
Orders = XDoc.SelectNodes("//Order:ORDER", XN)
For Each Order As XmlNode In Orders
dim MyOrderId as string = Orders.SelectSingleNode("ORDER_ID",XN).innerText
next
That doesn't work if I want the OrderID.
If I use
Order.SelectSingleNode("/Order:ORDER_DATE", XN)
I get the first OrderID each time.
Ideas?
//M
|
|
|
|
|
The XML you are now working with (based on your XPath statements) does not seem to match what you posted.
|
|
|
|
|
Using your original posted XML this code outputs TomSmith as expected
XmlDocument doc = new XmlDocument();
doc.Load("c:\\Research\\Xml\\Namespaces.xml");
XmlNamespaceManager man = new XmlNamespaceManager( doc.NameTable);
man.AddNamespace("ot", "http://www.opentrans.org/XMLSchema/1.0");
XmlNode fam = doc.SelectSingleNode("//family");
XmlNode n = fam.SelectSingleNode("ot:name", man);
Console.WriteLine(n.InnerText);
|
|
|
|
|
Wonderful ..
Now lets say I want to go 1 steå under name
You select the Family but under name I have firstname and lastname ...
Can I do a SingleNodeSelect 2 steps down in the structure like "ot:name/firstname"?
//h
|
|
|
|
|
Hopefully by know you have already tried that and discovered that you need to QName all the child nodes.
"ot:name/ot:firstname"
|
|
|
|
|
Yep I had ;D
Crazy But it worked ...
Thanks all ...
/m
|
|
|
|
|
hi ,
What is the difference between XPATH and DOM XML ? both give ability to navigate the document and plus that Dom also give ability to create,insert,delete and update any part of xml document ?
|
|
|
|
|
You still seem confused about XML related tech. Try some of the tutorials at www.w3schools.com, they might help you.
led mike
|
|
|
|
|
really thanks Mr.Still , i read some tutorials at www.w3schools.com and i have confused in the 2 concept, when i make search one of people say that the difference between XPATH and DOM XML related to the performance in the common point of navigation...but i am not know why ?..so i ask here to find answer.
thanks.
|
|
|
|
|
Honeyboy_20 wrote: really thanks
F*** off a**hole
|
|
|
|
|
Dear members,
I am reading data from excel and display in xml.But i can't want repeated value in xml.
How could i get that?
Plz help me.
Exp- abc 1 xyx
ggg 1 hhh
h 2 kj
there are 1 repeated more than one time. I want to skip it from xml.
|
|
|
|
|
Is there a better way of finding substitution groups for an element in an XSD other than looking through all the other elements and checking the substitutionGroup attribute?
Marc
|
|
|
|
|
I guess I don't understand your problem because it sounds like you want to use an XPath query. I can't imagine you would not have considered that if it might be a solution.
led mike
|
|
|
|
|
led mike wrote: guess I don't understand your problem because it sounds like you want to use an XPath query. I can't imagine you would not have considered that if it might be a solution.
Good point, the issue is more that I'm working with the XSD DOM and the elements that are substitution groups for the head element can be smeared across any number of imported schemas. However, that doesn't mean that I couldn't use an XPath query on each of the schemas. So...let me give that some thought!
Marc
|
|
|
|
|
Marc Clifton wrote: can be smeared across any number of imported schemas
I've never worked with imported schemas yet. They are not accessible from the DOM object they are imported into? By accessible I mean using the XPath query with selectNodes().
led mike
|
|
|
|
|
led mike wrote: By accessible I mean using the XPath query with selectNodes().
Not that I'm aware of, but I'll have to check. The imported schemas are not merged into a single XmlSchema instance--instead, you have to recurse through the Imports collection to manually find stuff, so I doubt XPath will do that either.
Marc
|
|
|
|
|
I am new to xml. Please tell me what is the differnt between node and element.
Dushan Perera
|
|
|
|
|
Dushan123 wrote: I am new to xml.
Perhaps this tutorial [^]will be helpful.
led mike
|
|
|
|
|
|
Guffa wrote: They are the same
That is potentially misleading. Every Element is a Node, not every Node is an Element.
led mike
|
|
|
|
|
hi guys,
i have some conflicts in understanding the render process of XML , HTML has the problem of "cross-browser rendering" which means that you can not control how html tags displayed and specifically you could not determine the layout of the web page.For example, paragraphs marked up with the <p> tag might have been displayed in a 12-point Arial font in a certain browser. A different browser might have used a 14-point Helvetica font. The point is that the browsers made the presentation decisions, not the documents themselves, which is in keeping with the general concept of a markup language. As you probably know, things changed quickly for HTML when the popularity
in another hand,i read that "style sheets still don’t have complete control over how XML content appears" and the address this problem to "cross-medium rendering" so my question what is the different between cross-medium rendering and cross-browser rendering ?
i can not find any logical difference in 2 concept ?
The difference between CSS and XSLT is the that CSS allows you to style HTML documents (XSLT cannot) so when i convert my xml doc to HTML this not style? so what is consider this convert ? and when i convert the problem of layout will appear or not?
|
|
|
|
|
XSLT is a Transformation mechanism. You can use it to transform XML into any text. The fact that you can choose to transform XML into HTML does not connect XSLT to CSS or Browser rendering compatibility issues. They are not related in any way other than you may be using and dealing with all of them in a project.
led mike
|
|
|
|