Solved

The process cannot access the file "EVSET2BC7601F642B1175BD6C0A956232F5CF.xml" because it is being used by another process.

Posted on 2006-07-08
2
872 Views
Last Modified: 2012-06-27
I'm getting this exception thrown when I run one of my threads.

EXCEPTION GETEPP: The process cannot access the file "C:\EVENTSETTINGS\EVSET2BC7601F642B1175BD6C0A956232F5CF.xml" because it is being used by another process.

How would i implement a stream to write the xml, if thats the solution.

Here is the code where the problem occurs,




            Dim TEMPPATH As String = "C:\EVENTSETTINGS\EVSET" & EVI & ".xml"

            Dim CompleteTable As New DataSet
            Dim TBLCOPY As New DataTable

            TBLCOPY = TBL.Copy
            CompleteTable.Tables.Clear()
            CompleteTable.Tables.Add(TBLCOPY)

         

            Try
                CompleteTable.WriteXml(TEMPPATH)
                CompleteTable.Tables.Clear()
                CompleteTable.Dispose()

            Catch ex As Exception
                Do While Not ex.Message.ToString = ""
                    Debug.Write("EXCEPTION GETEPP: " & ex.Message.ToString & vbNewLine)
                    Thread.Sleep(1)
                Loop
            End Try


            Debug.Write(vbNewLine & "WRITING FILE: " & TEMPPATH & " TABLE COUNT: " & CompleteTable.Tables.Count & vbNewLine)

            strTag = ""



            MainForm.FieldParseControls(TEMPPATH, MainEventFormURL)



500 Points because this is urgent! :D

0
Comment
Question by:JPERKS1985
2 Comments
 
LVL 37

Accepted Solution

by:
gregoryyoung earned 500 total points
ID: 17067177
Are there other threads/processes accessing this file?

This is just telling you that something else has it opened exclusively.

perhaps you are missing a clsoe or dispose somewhere else?
0
 
LVL 1

Author Comment

by:JPERKS1985
ID: 17069425
I fixed it by removing a thread that was writing to it. I have more code that has the same issue though. any suggestions?




        Dim DSet As New DataSet
        Dim Dtbl As New DataTable
        Dim flXML As String



        flXML = (TabControl1.SelectedTab.Tag)


        DSet.ReadXml(flXML)


        Do While DSet.Tables.Count = 0
            Application.DoEvents()
        Loop



        Dim cName As ComboBox = CType(sender, System.Windows.Forms.ComboBox)
        cName.Name = CType(sender, System.Windows.Forms.ComboBox).Name

        Dim DRow As DataRow
        Dim EventFileName As String

        For Each DRow In DSet.Tables(0).Rows
            If IsDBNull(DRow.Item("VALUE")) Then
                DRow.Item("VALUE") = "NULL"
            End If
        Next

        For Each DRow In DSet.Tables(0).Rows

            If DRow.Item("VALUE") = cName.Name Then
                DRow.Item(8) = cName.Text
                TMEventInfoParseGrid.DataSource = DSet
            End If
        Next

   
        DSet.WriteXml(flXML)
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
This video discusses moving either the default database or any database to a new volume.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now