VB.NET

Move actual file DOMDocument()

Please support our VB.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Mar 2007

Posts: 5

Reputation: molze is an unknown quantity at this point

Solved Threads: 1

molze

Offline

Newbie Poster

Move actual file DOMDocument()

Mar 23rd, 2007

I am upgrading a vb 6.0 app to .net and I'm having trouble moving a file. The app retrieves info from an XML. When it's done I try to move the .xml file to a history folder and I'm getting an error:
An unhandled exception of type 'System.IO.IOException' occurred in mscorlib.dll
Additional information: The process cannot access the file because it is being used by another process.
How do I release the file?
Here's my code

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
    Dim root As MSXML2.IXMLDOMElement
    Dim objXMLdoc As New MSXML2.DOMDocument30()
            objXMLdoc.Load(Filename)
            objXMLdoc.async = False
            root = objXMLdoc.documentElement.firstChild.firstChild
            GetXMLData() 'USES XPATH... TO RETRIEVE DATA
            OutPutRecord() 'outputs retrieved data to an SQL Database
            MoveFile(Filename)
    Public Function MoveFile(ByVal strfile As String) As Boolean
        Dim objfile As New FileInfo(strfile)
        'Try
        objfile.MoveTo(Filename)
        'Return True
        'Catch
        '   Return False
        '  End Try
    End Function
    Dim root As MSXML2.IXMLDOMElement
    Dim objXMLdoc As New MSXML2.DOMDocument30()
            objXMLdoc.Load(Filename)
            objXMLdoc.async = False
            root = objXMLdoc.documentElement.firstChild.firstChild
            GetXMLData() 'USES XPATH... TO RETRIEVE DATA
            OutPutRecord() 'outputs retrieved data to an SQL Database
            MoveFile(Filename)
    Public Function MoveFile(ByVal strfile As String) As Boolean
        Dim objfile As New FileInfo(strfile)
        'Try
        objfile.MoveTo(Filename)
        'Return True
        'Catch
        '   Return False
        '  End Try
    End Function

•

Join Date: Dec 2002

Posts: 461

Reputation: waynespangler is on a distinguished road

Solved Threads: 56

waynespangler waynespangler is offline

Offline

Posting Pro in Training

Re: Move actual file DOMDocument()

Mar 24th, 2007

You are still referencing the file thru the objXMLdoc. Try this

Help with Code Tags

(Toggle Plain Text)

            objXMLdoc.Load(Filename)
            objXMLdoc.async = False
            root = objXMLdoc.documentElement.firstChild.firstChild
            GetXMLData() 'USES XPATH... TO RETRIEVE DATA
            OutPutRecord() 'outputs retrieved data to an SQL Database
            objXMLdoc = Nothing
            MoveFile(Filename)

•

Join Date: Mar 2007

Posts: 5

Reputation: molze is an unknown quantity at this point

Solved Threads: 1

molze

Offline

Newbie Poster

Re: Move actual file DOMDocument()

Mar 25th, 2007

It turns out I did not show enough of my code in the first post. The process was actually croaking in another section altogether. There is another spot that I create an XML using FSO. I converted it to StreamWriter and I'm up and rolling! Well I'm ready to tackle the next challenge in the app!

Thanks Wayne