c# - 该进程无法访问该文件，因为它正被 C# asp.net 中的另一个进程使用

Question

最近上传的excel文件无法再次上传

 string OleDBconstring = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties=\"Excel 12.0;HDR=YES;\"";            
            OleDbConnection OleDBcon = new OleDbConnection(OleDBconstring + "");
            OleDBcon.Open();`enter code here`
            DataTable objSheetNmDt = OleDBcon.GetSchema("Tables");

            DataTable objExcelDt;
            objExcelDt = new DataTable();
            string sqlquery = "Select * From  [" + objSheetNmDt.Rows[0]["TABLE_NAME"].ToString() + "]";//[{0}]                   
            OleDbCommand objCm`enter code here`d = new OleDbCommand(sqlquery, OleDBcon);
            OleDbDataAdapter da = new OleDbDataAdapter();
            da.SelectCommand = objCmd;
            da.Fill(objExcelDt);

标签： c#asp.net