C# export to excel from sql server

I have created a temporary excel file and then copied to the destination. But when I try to delete the temporary file, it throws exception that the file is in use.

Here is the code: File.Copy(sourceFile,destFile,true); File.Delete(sourceFile); //Here it is throwing the exception

perhaps try File.Move(sourceFile, destFile); make sure to do this first though:if (File.Exists(destFile)) File.Delete(destFile);

I have already tried [File.Exists(destFile)] but it does not work. It seems that after copying the file the source file is not released for some time. So, I added following code... System.Threading.Thread.Wait(1000); File.Delete(sourceFile); Then it worked. But it blocks the UI for 1sec. Is there other method I can use? I also cannot use File.Move(sourceFile,destFile) because if the destination already consists similar filename, then it does not work. Thanks in advance...

right, i'm saying get rid of file.copy and then file.delete() and just do this: if (File.Exists(destFile)) File.Delete(destFile); File.Move(sourceFile, destFile); This will delete the file first from the destination directory and then move the new file there. This way you don't need to worry about copying the file, waiting one second and then deleting it.