Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2006-07-08
2
Medium Priority
?
881 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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Integration Management Part 2
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

972 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