Why it can't work wih "__uuidof(MSXML2::DOMDocument60)"? - XML / XSL Discussion Boards

Re: Ought to be basic, but I'm not getting it!

Scott_Roberts17-Aug-06 13:17

17-Aug-06 13:17

Okay, I converted this to VB as follows:

Private Sub Button_Clicked(ByVal sender As Object, ByVal e As EventArgs) Handles btnWKKI.Click, btnWWWC.Click
Dim strStation As String = sender.Text

Dim xDocument As New XmlDocument()
xDocument.Load("http://distribution.customradionews.net/Forecast_XML/" & strStation & ".xml")

Dim xpPeriod As String = "//dwml/data/time-layout[2]/start-valid-time[3]/@period-name"
Dim xpTemp As String = "//dwml/data/parameters/temperature[2]/value[3]/text()"

Dim nTemp As XmlText = xDocument.SelectSingleNode(xpTemp)
Dim nPeriod As XmlAttribute = xDocument.SelectSingleNode(xpPeriod)

Console.WriteLine("{0} - {1}", nPeriod.Value, nTemp.Value)

Dim nlPeriod As XmlNodeList = xDocument.SelectNodes("//dwml/data/time-layout[2]/start-valid-time/@period-name")
Dim nlTemp As XmlNodeList = xDocument.SelectNodes("//dwml/data/parameters/temperature[2]/value/text()")

Dim n As Integer = 0
While n < nlPeriod.Count
Console.WriteLine("{0} - {1}", (nlPeriod.Item(n) as XmlAttribute).Value, (nlTemp.Item(n) as XmlText).Value)
n += 1

End While
End Sub

However, the IDE gives "Expression Does Not Produce A Value" on Console.WriteLine("{0} - {1}", (nlPeriod.Item(n) as XmlAttribute)...the second part of the statement is okay. What did I miss?

Re: Ought to be basic, but I'm not getting it!

Scott_Roberts17-Aug-06 16:17

Scott_Roberts

17-Aug-06 16:17

Found the way to make that last statement work:

Console.WriteLine("{0} - {1}", (TryCast(nlPeriod.Item(n), XmlAttribute)).Value, (TryCast(nlTemp.Item(n), XmlText)).Value)

Thanks again for your help! It works beautifully!

Position in a node set

whozurmommy16-Aug-06 21:11

whozurmommy

16-Aug-06 21:11

Like many here, I'm new to XML, so please excuse me if I use the wrong terminology:

My XML document (and XMLDataSource) is this:

<gpx>
<trk> <number>1
<trkseg> <trkpt lat="45" lon="-122"> <ele>85
2006-04-16
<trkpt lat="45" lon="-122.6"> <ele>84
2006-04-16
<trkpt lat="45" lon="-122.7"> <ele>82
2006-04-16

I'm using an XPath statement ("XPath="gpx/trk/trkseg/trkpt") to bind all the trkpt elements to my data source. My goal is to return a page that displays all of the ELE data points, and numbers them according to their position in the XML file. It should read something like this:

ele = 85, position = 1
ele = 84, position = 2
ele = 82, position = 3

My DataList control correctly identifies all of the 'ele' elements using this syntax <%# XPath("ele") %>, however I have not be able to figure out how to find the position within my dataset. Using <%# XPath("position()") %> always returns 1, and everything else I have tried either returns the same number or throughs an exception. Can anyone clue me in as to what black magic is required to have XPath (I'm assuming its XPath) return its location within a series of identical elements?

-=STZ=-

Re: Position in a node set

Dustin Metzgar17-Aug-06 5:51

Dustin Metzgar

17-Aug-06 5:51

There's nothing really black magic about it. The position() function really depends on context. It will return the position of the node currently being processed. It's hard to tell what you're doing from what's given. Can you post some of the code you're working on?

Logifusion[^]
If not entertaining, write your Congressman.

Re: Position in a node set

whozurmommy17-Aug-06 8:41

whozurmommy

17-Aug-06 8:41

Here is my code:

<asp:DataList ID="DataList1" runat="server" DataSourceID="XmlDataSource1">
<ItemTemplate>
#<%# XPath("position()")%>. elevation point = <%# XPath("ele") %>
</ItemTemplate>
</asp:DataList>
<asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/crashminus1.xml" XPath="gpx/trk/trkseg/trkpt" TransformFile="~/NS_strip.xsl">
</asp:XmlDataSource>

You can see this code being run here = http://www.loc8r.com/steve/test8.aspx
And you can see my XML file here = http://www.loc8r.com/steve/crashminus1.xml

I assumed that position() acted as you described, and if that were the case I'd suspect that the logic would be like this.

1. The ItemTemplate repeater class sets the context to the 1st TRKPT xml element. Position() should return 1.
2. The ItemTemplate repeater class increments the context to the 2nd TRKPT xml element. Position() should return 2.
3. The ItemTemplate repeater class increments the context to the 3rd TRKPT xml element. Position() should return 3.

As I mentioned position() is always returning "1", although "ele" is correctly displaying the 3 different values within the 3 different elements.

-=STZ=-

Re: Position in a node set

Dustin Metzgar17-Aug-06 9:18

Dustin Metzgar

17-Aug-06 9:18

It's quite possible that position may not be at all effective when being used in this way. Take a look at this snippet:

string s = @"
<root>
   <child>a</child>
   <child>b</child>
   <child>c</child>
</root>
";
XmlDocument doc = new XmlDocument();
doc.LoadXml(s);
XmlNodeList nl = doc.SelectNodes("//child");
foreach (XmlNode n in nl)
   Console.WriteLine(n.CreateNavigator().Evaluate("position()"));

This will print out all 1's as well. I imagine that behind the scenes, a very similar process is happening to execute your XPath statements. So far, I have been unable to come up with an alternative XPath that will work. You may want to do this another way.

Logifusion[^]
If not entertaining, write your Congressman.

Re: Position in a node set

whozurmommy17-Aug-06 18:58

whozurmommy

17-Aug-06 18:58

Thanks for trying Dustin. I guess I need to see if I can track someone down at work and see if they can explain it to me. -=STZ=-

Why it can't work wih "__uuidof(MSXML2::DOMDocument60)"?

Eric Vonjacson15-Aug-06 21:21

Eric Vonjacson

15-Aug-06 21:21

Hi All,

I have a problem with MSXML6 which bother me a lot.
First I have a xml file named "Infor.xml" like this:

<?xml version="1.0" ?>
<Root xmlns="http://EricFeng.org/2004-08-09">
<SubNode>
<Name>Eric</Name>
<Age>24</Age>
</SubNode>
</Root>

Then the codes to analyze this file is like this:

#import <msxml6.dll>
//...

MSXML2::IXMLDOMDocument2Ptr pNewDocument;
pNewDocument.CreateInstance(__uuidof(MSXML2::DOMDocument));
//load the xml file
pNewDocument->load(_bstr_t("Infor.xml"));
MSXML2::IXMLDOMNodeListPtr pNodeList;
//get he sub node "Root/SubNode"
pNodeList = pNewDocument->selectNodes(_bstr_t("Root/SubNode"));
cout<<"The new Node length is "<<pNodeList->Getlength()<<endl;

MSXML2::IXMLDOMNodePtr pSubNode = pNodeList->Getitem(0);
MSXML2::IXMLDOMElementPtr pElement = pSubNode->selectSingleNode(_bstr_t("Name"));
if(pElement != NULL)
{
cout<<"Name is: "<<pElement->Gettext()<<endl;
pElement.Release();
}
pElement = pSubNode->selectSingleNode(_bstr_t("Age"));
if(pElement != NULL)
{
cout<<"Age is: "<<pElement->Gettext()<<endl;
pElement.Release();
}
//....

With MSXML6, I change the "__uuidof(MSXML2::DOMDocument)" to "__uuidof(MSXML2::DOMDocument40)" or "__uuidof(MSXML2::DOMDocument60)". Then the codes above can't work.

I searched the help file os msxml6 and found that the GUIDS are related the version of MSXML. The table can be like this:

ProgID Version
MSXML2::DOMDocument msxml3.dll
MSXML2:: DOMDocument40 msxml4.dll
MSXML2::DOMDocument60 msxml6.dll

With MSXML6. Should I need to replace the "__uuidof(MSXML2::DOMDocument)" wihe "__uuidof(MSXML2::DOMDocument60)"?

Thanks,
Eric

XML node insertion

biaali15-Aug-06 4:36

biaali

15-Aug-06 4:36

how can we insert a new Xmlnode at a specific position by specific position i mean i want to insert a data in an alphabetical order using C#

bia

Re: XML node insertion

Dustin Metzgar15-Aug-06 5:09

Dustin Metzgar

15-Aug-06 5:09

All kinds of ways. Search for the node that is before or after the position you want to insert your new node and use InsertBefore or InsertAfter respectively on the parent node. That's if you have an XmlDocument object open. Another way is to just insert the node at the end and apply a stylesheet. The xsl:for-each can have a child element xsl:sort that can sort your nodes in alphabetical order.

Logifusion[^]
If not entertaining, write your Congressman.

New to XML

lehya14-Aug-06 5:17

lehya

14-Aug-06 5:17

I have a page with data retrieving from user:
Name, landline no, Question to ask and Timings..Once i click on button of this page, say callback.aspx, it will generate a xml file automatically with a file name userinfo.xml

Now i try to read this file in another .aspx page say read.aspx from userinfo.xml...Everything is working fine..except for..
If another user enters info in callback and submits. And when i check it from read.aspx or userinfo.xml the previous data is lost and the new data is written...Is there any possibility that dynamically data can be appended to userinfo.xml
Please help..the following is the code in callback.aspx

string xmlFile = Server.MapPath("userInfo.xml");
XmlTextWriter writer = new XmlTextWriter(xmlFile, Encoding.UTF8);
//start writing
writer.WriteStartDocument();
writer.WriteComment("Posted on @" + DateTime.Now.ToString());
writer.WriteStartElement("UI");
//creating the <browserinfo> element
writer.WriteElementString("name", sname);
writer.WriteElementString("landline",slandline);
writer.WriteElementString("question",squestion);
writer.WriteElementString("time",stime);
writer.WriteElementString("Date",DateTime.Now.ToString());
writer.WriteEndElement();
writer.WriteEndDocument();

writer.Close();

Re: New to XML

Dustin Metzgar14-Aug-06 8:57

Dustin Metzgar

14-Aug-06 8:57

Well, you've got a few problems to deal with here. First of all is this line:

lehya wrote:
XmlTextWriter writer = new XmlTextWriter(xmlFile, Encoding.UTF8);

This is a shortcut to remove some of the tedium of opening a file. But, its assumption is that you want to erase the old file if one is there, not append to it.

The second problem is that you're dealing with an XML file. You can't just append to the end of the file. You have to add your new elements as a part of the existing document.

Appending to the end of an XML document is not easy. You have some options though. Open the XML in an XmlDocument object and just append your child nodes in there where appropriate, then save the file. If the XML file is big, this will take up lots of memory and be slow. Another option is to open up the existing file with an XmlReader and open up a temporary file with an XmlWriter. Read the existing XML until you get to the end of the document and while you're doing it, write those elements out to the writer. Before writing the EndDocument, write in your new elements. Then delete the old file and rename the temp file to the correct filename.

Logifusion[^]
If not entertaining, write your Congressman.

Re: New to XML

lehya14-Aug-06 10:31

lehya

14-Aug-06 10:31

Thanks buddy...Sounds like it works..But reading everything and writing into a temporary file...saving it as a new file..oh this sounds too hard..but i will try

Re: New to XML

Dustin Metzgar14-Aug-06 11:00

Dustin Metzgar

14-Aug-06 11:00

You could also write to a MemoryStream so long as the XML is not too big. The MemoryStream will have a smaller memory footprint than the XmlDocument object.

Logifusion[^]
If not entertaining, write your Congressman.

Re: New to XML [modified]

manowj18-Aug-06 22:38

manowj

18-Aug-06 22:38

Hi lehya,

First check whether the xml file exists, If not create xml [ u have done this], if exists load xml file, get the root node element and append every node you add as as child node [plz don`t use processing instructions while appending to xml] and save the xml.

<ex: <Contact_info> => Root Element
<contacts>
<name>test</name>
<age>35</age>
<sex>M</sex>
</contacts>
<contacts>
<name>test</name>
<age>35</age>
<sex>M</sex>
</contacts>
</Contact_info>

-- modified at 4:38 Saturday 19th August, 2006

Regards,
Manowj

Re: New to XML

Dustin Metzgar22-Aug-06 11:13

Dustin Metzgar

22-Aug-06 11:13

You're probably already past this, but I've seen this question enough times that I thought I might write an article on it. Link[^]

Logifusion[^]
If not entertaining, write your Congressman.

MS Access 2003 and Exporting in a XML Format

sweep12314-Aug-06 3:53

sweep123

14-Aug-06 3:53

I have a series of tables in MS Access 2003 and would like to export a subset of the data out in an XML format.

I have come accross the Application.ExportXML facility in MS Access 2003, but is this applicable if I need to export 2 fields from Table A, 3 from Table B and 1 from Table C.

My question is, should I write a VBA module to export the data I require or are they an example on how to use Application.ExportXML in the way required.

I cant find much documentation on this facility.

Sorry if this is the wrong forum.

Many thanks

Re: MS Access 2003 and Exporting in a XML Format

Stephen McGuire14-Aug-06 15:18

Stephen McGuire

14-Aug-06 15:18

Create a query containing your required fields then use Application.ExportXML with the query as your DataSource.

Application.ExportXML _
ObjectType:=acExportQuery, _
DataSource:="YourQuery", _
DataTarget:="Path\YourFile.xml"

The above shows the required properties. For a list of additional (optional) properties, see the Access 2003 help file for the ExportXML method.

Steve

Access violation exception while trying to create a XML Element

adidas.levy12-Aug-06 22:52

adidas.levy

12-Aug-06 22:52

Hey guys!

I'm kind of new to XML using VC++ 6.0.
I know XML DOM and XML MiniDOM from python...

and I use MSXML4.0.

anyway, I try to create an element, or a node,
and as I run my little application it carshed due to "Access violation"
the exception occures in the functions
raw_createElement(...) and raw_createNode(...)

it happens all the time, and frankly I really don't know what the heck is wrong in there....

here is a fragment of my source:

#define PHONEBOOK_NODE _T("Node")
hr= m_pDomDocument.CreateInstance("Msxml2.DOMDocument.4.0");
sprintf(node, "%ld", m_NodeID);
l_XMLNode = m_pDomDocument->createNode(l_vtType, _T(node), _T(""));
l_XMLElement = m_pDomDocument->createElement(PHONEBOOK_NODE);

where:
m_pDomDocument is IXMLDOMDocument2Ptr
l_XMLNode is IXMLDOMNodePtr
l_XMLElement is IXMLDOMElementPtr

I'll be very glad (and so my boss) if someone will be kind to
share his or her opinion about that...

thanx,
Adidas

Re: Access violation exception while trying to create a XML Element

led mike15-Aug-06 6:03

led mike

15-Aug-06 6:03

adidas.levy wrote:
I'm kind of new to XML using VC++ 6.0.
I know XML DOM and XML MiniDOM from python...

Are you saying you are new to C++ development? If so you are "starting" off with a much to complex project.

An "Access Violation" is not a XML/XSL problem it is a C++ problem so this question belongs in the Visual C++/MFC forum.

led mike

Re: Access violation exception while trying to create a XML Element

adidas.levy15-Aug-06 19:52

adidas.levy

15-Aug-06 19:52

Hey,

No, I'm not new to C++ programming, I'm programming C++ for over 3 years.
I am used to program under UNIX operating systems and not under Windows.
recently I started programming under Windows...

anyway, I solved the problem, I just had an additional call to "CoInitialize()" which caused the problem....

Need XML Help

Amit Kumar G12-Aug-06 9:53

Amit Kumar G

12-Aug-06 9:53

Hi All

First of all thanks for your valuable time. I am new to XML and i have very basic query.I need to generate my AsP.NET MENUS through XML and i build the XML file as below

<code><?xml version="1.0" encoding="utf-8"?>
<Menus xmlns="http://tempuri.org/XYZ.xsd">
<Menu Name="Electronics">
<ChildName>TV</ChildName>
<ChildUrl>//localhost/Tv.aspx</ChildUrl>
<ChildName>Mp3 Player</ChildName>
<ChildUrl>//localhost/MP3.aspx</ChildUrl>
</Menu>
<Menu Name="Furniture">
<ChildName>Tables</ChildName>
<ChildUrl>//localhost/tables.aspx</ChildUrl>
<ChildName>Chairs</ChildName>
<ChildUrl>//localhost/chair.aspx</ChildUrl>
<ChildName>Beds</ChildName>
<ChildUrl>//localhost/beds.aspx</ChildUrl>
so on.......
</Menu>
</Menus></code>
How i can read these XML nodes values???? I am confused and i tried dom, xmltextreader etc.......I am not sure which is the best way to use and how to use. I can load XML document but after that i am not able to read these nodes values....I am using ASP.Net, VB.Net version 1.x

Please provide some good sample source code. Thanks in advance for your help....One small request please help me ASAP.

Amit

Re: Need XML Help

Rizwan Bashir15-Aug-06 3:48

Rizwan Bashir

15-Aug-06 3:48

Define Dataset and read the XML in DataSet like
ds.readXML(FilePath)
and here you go.. you have the details do what ever you want.
there are many other ways to read the XML but this is the easiest among all.

Rizwan Bashir
ALM Soft[^]

Re: Need XML Help

Amit Kumar G15-Aug-06 14:16

Amit Kumar G

15-Aug-06 14:16

Thanks for your reply. And it really helps me to move one step. Now i am facing another problem. I am able to load my menus through xml, but it is taking some time to load. Moreover my other frmaes loaded before menus load..... Any thoughts???

Namespace in XMLDocument

VSush10-Aug-06 0:34

VSush

10-Aug-06 0:34

Hi,
I am sorry if this is a very basic question.
I am new to XMLs.
I am using .net XMLDocument class to operate with xml files.
I would like to know what is the significance of a namespace when parsing XMLs. what and why is a namespace used?

Thanks.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.