how to delete the uploaded file from the folder in asp.net

Question

0.00/5 (No votes)

See more:

I had uploaded a file in the database and that file is also contains by a folder of the website page in asp.net.
Now i want to delete the file from the database and the folder also. I have successfully deleted the
file from the database but file is not deleting from the folder of the website.
so tell me the proper answer.
The whole detail is given below:-

Firstly I had uploaded a file(whether it is image,word file etc.)Now u can
understand that file will also go to the folder .It mean to say that file will go the database(sql server) and also go to the folder of the website.

Now If i want to delete that file then it is deleting from the databse(sql server)
but not to deleting from the folder of the website(asp.net).Folder name like (image,upload etc.)

Here is my c# code for delete a file from the database and the folder also.The folder name is "Uploads" which you can see in the code and the databse table name is "emp" so now you can understand that file is deleting from the database table "emp" but not deleting from the folder "Uploads".

Code is given below:-

C#

protected void btndelete_Click(object sender, EventArgs e)
    {
 string connectionString = WebConfigurationManager.ConnectionStrings["cnn"].ConnectionString;
        
          string filename = FileUpload1.FileName;
          FileUpload1.PostedFile.Equals(Server.MapPath("~\\Uploads\\" + filename));
          string path = "~\\Uploads\\" + filename;

       SqlConnection cnn = new SqlConnection(connectionString);
        try
        {
            cnn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "delete from emp ";
            
            cmd.CommandType = CommandType.Text;
            cmd.Connection = cnn;
            cmd.ExecuteNonQuery();

          if (File.Exists(path))
            {
                File.Delete(path);
                 
            }

           
            cnn.Close();
        }
        catch (Exception ex)
        {
            Response.Write(ex.ToString());
        }
        finally
        {
           lblinfo2.Text = "";
           lblinfo2.Text= " Deleted Successfully ";
        }

    }

Posted 13-Sep-11 3:00am

PATEL RAJEEV

Updated 13-Sep-11 3:12am

Herman<T>.Instance

v2

Add a Solution

6 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)

Sunasara Imdadhusen · Answer 1 · 2011-09-13T03:15:00

Solution 1

Please visit following link

ASP.NET File Upload with Progress Bar[^]

Posted 13-Sep-11 3:15am

Sunasara Imdadhusen

amit_jain_online · Answer 2 · 2012-03-29T00:29:00

Solution 3

refer Delete files from server directory

Posted 29-Mar-12 0:29am

amit_jain_online

bhargavpp · Answer 3 · 2011-09-13T03:35:00

Solution 2

in finally block write this

C#

if (File.Exists(path))
            {
                File.Delete(path);

            }

Posted 13-Sep-11 3:35am

bhargavpp

ujjwal uniyal · Answer 4 · 2012-03-29T01:09:00

use file info

using System.io

 File.Delete(Server.MapPath("../Nurturing/" + fnevents));
            FileInfo fInfoEvent;
            fInfoEvent = new FileInfo(fnevents);
            fInfoEvent.Delete();

here fnevents is the name of the file that u are deleting. Nurturing is the name of the folder.

It will do the work for you

Anuja Pawar Indore · Answer 5 · 2013-04-17T04:58:00

Solution 6

Refer this
http://msdn.microsoft.com/en-us/library/system.io.file.delete.aspx[^]
This works fine for me

C#

string Path = Server.MapPath("~/JPEG/Document/" + Session["ID"].ToString())+"Tble" + test+ ".jpg";
if (System.IO.File.Exists(Path))
{

System.IO.File.Delete(Path);

}

Posted 17-Apr-13 4:58am

Anuja Pawar Indore

Updated 17-Apr-13 4:59am

v2

babu saravanan · Answer 6 · 2013-04-17T06:54:00

Make sure the ASP user has permissions to this folder. By default this user is not given access to much of the hard drive.

using System.IO;

First Way

C#

protected void Button1_Click(object sender, System.EventArgs e) {
       string filePath = Request.PhysicalApplicationPath + "Elephant.jpg";

       try
       {
           File.Delete(filePath);
           Label1.Text = "File deleted";

       }
       catch(Exception ex)
       {
           Label1.Text = "an error occured<br />";
           Label1.Text = ex.Message.ToString();
       }
   }

Second Way

C#

try {
FileInfo TheFile = new FileInfo(MapPath(".") + "\\" + txtFile.Text);
if (TheFile.Exists) {
File.Delete(MapPath(".") + "\\" + txtFile.Text);
}
else {
throw new FileNotFoundException();
}
}