DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

How to Read XML file and to add some information into it

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Jul 2008

Posts: 12

Reputation: karthiknv is an unknown quantity at this point

Solved Threads: 0

karthiknv

Offline

Newbie Poster

How to Read XML file and to add some information into it

Jul 4th, 2008

Hi,
I have a problem.
I need to read some data from a text file and need to put it into XML file using VB6.

I have the follwoing input from the text file:

Suite id="ADD"
description="Add Validation Suite"
TestCase id="ATC_V_Add001"
and so on..........

and I want the following format in XML file. I have to update the XML file with the following info:

<?xml-stylesheet type="text/xsl" href="TestSuite.xsl"?>
<LLD>
<Cycle>
<Suite id="ADD" description="Add Validation Suite">
<TestCase id="ATC_V_Add001" description="Verify the Rulecode ADD001 with Address Overlap in the same Zone or City exception">
<LinkPVID>54221487</LinkPVID>

<Results>Exception ADD001 is generated see details in Exception info section</Results>

<StepTable id="StartUpApplication" description="To launch the application" />

</TestCase>
</Suite>
</Cycle>
</LLD>

•

Join Date: Feb 2008

Posts: 509

Reputation: selvaganapathy is an unknown quantity at this point

Solved Threads: 88

selvaganapathy selvaganapathy is offline

Offline

Posting Pro

Re: How to Read XML file and to add some information into it

Jul 4th, 2008

Hi,
You can use Microsoft XML, Version 2.0 or any to parse XML FIles.
Include Microsoft XML, Version 2.0 or any Type Library in to your project

> Project > Reference > Microsoft XML, Version 2.0 or any version
This below link will help u
http://msdn.microsoft.com/en-us/libr...8VS.85%29.aspx

KSG

•

Join Date: Jul 2008

Posts: 12

Reputation: karthiknv is an unknown quantity at this point

Solved Threads: 0

karthiknv

Offline

Newbie Poster

Re: How to Read XML file and to add some information into it

Jul 7th, 2008

Hi,
Could you tell me how to select a node having a attribute. In the example

<Suite id="ADD" description="Add Validation Suite">
How to select the Suite node using the "id' value.

Thanks,
karthik

•

Join Date: Feb 2008

Posts: 509

Reputation: selvaganapathy is an unknown quantity at this point

Solved Threads: 88

selvaganapathy selvaganapathy is offline

Offline

Posting Pro

Re: How to Read XML file and to add some information into it

Jul 7th, 2008

This Code select the ID Node. Save your xml in C:\Test.xml or Change the Name in Load () function.
I am not correct exactly. but it will do.

 Help with Code Tags 
 vb Syntax (Toggle Plain Text) 
   Dim xDOM As DOMDocument
   Set xDOM = New DOMDocument
 
   Dim xRoot As IXMLDOMElement
   Dim xNodeList As IXMLDOMNodeList
   Dim xNM As IXMLDOMNamedNodeMap
   Dim xID As IXMLDOMNode
   xDOM.Load "c:\test.xml"  ' Or your File Name
 
   Set xRoot = xDOM.documentElement
   Set xNodeList = xRoot.getElementsByTagName("Suite")
 
   If (Not xNodeList Is Nothing) Then
      Set xNM = xNodeList(0).Attributes
      Set xID = xNM.getNamedItem("id")
      MsgBox iM.Text
   End If
   Dim xDOM As DOMDocument
   Set xDOM = New DOMDocument
   
   Dim xRoot As IXMLDOMElement
   Dim xNodeList As IXMLDOMNodeList
   Dim xNM As IXMLDOMNamedNodeMap
   Dim xID As IXMLDOMNode
   xDOM.Load "c:\test.xml"  ' Or your File Name
   
   Set xRoot = xDOM.documentElement
   Set xNodeList = xRoot.getElementsByTagName("Suite")
   
   If (Not xNodeList Is Nothing) Then
      Set xNM = xNodeList(0).Attributes
      Set xID = xNM.getNamedItem("id")
      MsgBox iM.Text
   End If

Last edited by selvaganapathy; Jul 7th, 2008 at 11:47 pm.

KSG

•

Join Date: Jul 2008

Posts: 12

Reputation: karthiknv is an unknown quantity at this point

Solved Threads: 0

karthiknv

Offline

Newbie Poster

Re: How to Read XML file and to add some information into it

Jul 8th, 2008

Sorry, i forgot to mention my exact requirement
i need to select the node with the value of id

Eg:To select the "Suite" node with "id "value="ADD" and need to add some more node under it

Thanks,
Karthik