i can successfully upload, view and load an excel file into my webapp then into my db. However when i go to upload a second time i keep getting the following error msg:
The process cannot access the file <myfilename> because it is being used by another process.
Now before everyone starts telling me to use .Dispose.. I am, everywhere I can..and I've isolated it to just the using the view functionality as a test... once viewed (connected to xls sheet) then file becomes "locked" and doesn't seem to relese. Below is the code. I am looking for any advice on what I am missing to unlock and reupload. thanks
I got this from 4guysfromrolla.com however they don't cover this issue i've encountered.
---gets my file (notice the fileuploadexcel object is being disposed-bolded)
Protected Sub upload(ByVal sender As Object, ByVal e As System.EventArgs)
Dim fname As String fname = Session("usr").ToString & "_Xlimp.xls"
If FileUploadExcel.HasFile Then Try 'alter path for your project
View Complete Post