the process cannot access the file because it is being used by another process

Question

1.00/5 (1 vote)

See more:

Hi guys,

I have a asp.net web application where i'm trying to upload & read the excel file.

But frequently i'm facing this error:

The process cannot access the file 'C:\gis.xlsx' because it is being used by another process.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.IO.IOException: The process cannot access the file 'C:\gis.xlsx' because it is being used by another process.

Source Error: 


Line 43: 
Line 44:                 string FilePath = Server.MapPath(FolderPath + FileName);
Line 45:                 FileUpload1.SaveAs(FilePath);
Line 46: 
Line 47:                 Repeater1.DataSource = ImportExcel.Import_To_Grid(FilePath, Extension, "Yes", rbHDR.SelectedItem.Text);

Source File: C:\Users\Developer\documents\visual studio 2010\Projects\GIS\GIS\ImportGIS.aspx.cs    Line: 45

c# code

if (FileUpload1.HasFile)
            {
                string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
                string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
                string FolderPath = ConfigurationManager.AppSettings["FolderPath"];

                string FilePath = Server.MapPath(FolderPath + FileName);
                FileUpload1.SaveAs(FilePath);//Error

                Repeater1.DataSource = ImportExcel.Import_To_Grid(FilePath, Extension, "Yes", rbHDR.SelectedItem.Text);
                Repeater1.DataBind();

                FileUpload1.Dispose();
            }

importExcel.cs

public static System.Data.DataTable Import_To_Grid(string FilePath, string Extension, string isHDR, string SheetName)
        {
            string conStr="";
            switch (Extension)
            {
                case ".xls": //Excel 97-03
                    conStr = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString;
                    break;
                case ".xlsx": //Excel 07
                    conStr = ConfigurationManager.ConnectionStrings["Excel07ConString"].ConnectionString;
                    break;
            }
            conStr = String.Format(conStr, FilePath, isHDR);
            OleDbConnection connExcel = new OleDbConnection(conStr);
            OleDbCommand cmdExcel = new OleDbCommand();
            OleDbDataAdapter oda = new OleDbDataAdapter();
            System.Data.DataTable dt = new System.Data.DataTable(); 
            cmdExcel.Connection = connExcel;

            //Get the name of First Sheet
            connExcel.Open();
            System.Data.DataTable dtExcelSchema;
            dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            //string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
            connExcel.Close();

            //Read Data from First Sheet
            connExcel.Open();
            cmdExcel.CommandText = "SELECT modetrans, name, regno, grade, division, fatname, nameofcomp, TRIM(faph) AS faph, TRIM(moph) AS moph, TRIM(compph) AS compph, TRIM(resiph) AS resiph, TRIM(resiph1) AS resiph1, nationality, sex  From [" + SheetName + "$]";
            oda.SelectCommand = cmdExcel;
            oda.Fill(dt);
            connExcel.Close(); 
        
            return dt;
        }

please, can any one help me...

Thanks

Posted 15-Nov-14 20:45pm

abdul subhan mohammed

Updated 15-Nov-14 21:04pm

v6

Add a Solution

Comments

Afzaal Ahmad Zeeshan 16-Nov-14 2:49am

Do you create it on the runtime?

Anyways the chances are that you're using the file somewhere, mostly when you use the resources it is a better approach to use them in using block.

MT_ 16-Nov-14 3:00am

What exactly are you doing in ImportExcel.Import_To_Grid? can you show that?

abdul subhan mohammed 16-Nov-14 3:04am

i have added .cs code

abdul subhan mohammed 16-Nov-14 3:02am

still i'm getting the same error

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ullas_Krishnan · Answer 1 · 2014-11-15T21:30:00

Error is because the fileupload or any control or object still connected to the Excel file..

You need to dispos and use "Using" block for avoiding the object still used afer the function..

Also the excel file should be open by "Open" Exclusive mode.. can set this property

You can try to open the file in read-only mode:

var app = new Microsoft.Office.Interop.Excel.Application();
var workbook = app.Workbooks.Open(filename, ReadOnly: true);

Or you can try to save it in shared mode:

workbook.SaveAs(filename, AccessMode: XlSaveAsAccessMode.xlShared);

Thanks,
ullas

MT_ · Answer 2 · 2014-11-15T21:30:00

Try this, see if it helps...

C#

public static System.Data.DataTable Import_To_Grid(string FilePath, string Extension, string isHDR, string SheetName)
{
try
{

// your complete code here
}
catch
{

}
finally
{
    if(cmdExcel !=null)
    {
        cmdExcel.Dispose();
        cmdExcel = null;
    }
    if(connExcel != null)
    {
        connExcel.Dispose();
        connExcel = null;
    }
}

}

gdevlekar · Answer 3 · 2014-11-15T21:37:00

As Error Says You are accessing Resource(File,Disk,etc) which is already used by Another process.Like in Most Situation you need to close/Dispose its objects Streams,Connections.

You should close try catch finally in method Import_To_Grid and Close or Dispose Streams or Connection inside Catch Block

You like this:
Each time to create new File

C#

string FilePath = Server.MapPath(FolderPath + FileName+DateTimeNow.ToString());

C#

public static System.Data.DataTable Import_To_Grid(string FilePath, string Extension, string isHDR, string SheetName)
        {

try
{

using( OleDbConnection connExcel = new OleDbConnection(conStr);)
{
using(OleDbCommand cmd=new OleDbCommand(connExcel,"mySQL"))
{

//Read Your Excel Here
}

}


return dt;


}

catch(Exception e)
{
connExcel.Dispose();
cmd.Dispose();

return null;
}
Finally
{
connExcel.Dispose();
cmd.Dispose();

}
     }

the process cannot access the file because it is being used by another process

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0