Hello everyone,

I have an issue in working with xml files. i want to change the contents of an xml from two applications simultaneously.
this is my xml document
<?xml version="1.0" encoding="Windows-1252"?>
<OrderList>
<Order>
<Orderno>30</Orderno>
<Key>456</Key>
</Order>
<Order>
<Orderno>30</Orderno>
<Key></Key>
</Order>
</OrderList>

currently i have the code for update the contents
Dim XMLDom As New XmlDocument()
'//load your xml file
XMLDom.Load("c:\t2.xml")
Dim newXMLNodes As XmlNodeList = XMLDom.SelectNodes("/OrderList/Order/Orderno")

For Each newXMLNode1 As XmlNode In newXMLNodes
MsgBox(newXMLNode1.InnerText)
If newXMLNode1.InnerText = "31" Then
newXMLNode1.InnerText = "AS31"
End If


Next


XMLDom.Save("c:\t2.xml")
XMLDom = Nothing


its main problem is that i load the full document to XMLDom and finaly i overwrite the existing xml document,so i lost the data from the second application .
Can anyone please help me with this


rehna

You need to provide some locking mechanism on the file.

The core of this problem is with the way that XmlDocument works. When you load it, it reads the whole XML file into object memory and releases the file. So another instance of the program can do the same and neither will know about the other. I haven't done this type of work but I imagine there is some way to lock the file using the System.IO.File class. You can load an XmlDocument from a file stream. So you could manually open the file using the File class methods to obtain a file stream with a lock on the file, then fill your XmlDocument from it, keeping the file open. This will provide the lock at the file system level so another program instance can't write to it until you release it. The other program could be forced to wait to provide read-only access to the file.

-Peter
compiledthoughts.com