delete Image path from database and also delete image from folder in asp.net

Question

4.00/5 (2 votes)

See more:

i store a image path in a folder as well as database.so i need when a user delete a image from database same time image within folder should be delete.plz give me idea how to implement .

Posted 18-Nov-13 21:09pm

manvendra patel

Updated 23-Feb-20 18:31pm

v2

Add a Solution

Comments

bbirajdar 19-Nov-13 3:13am

In the delete button click event , call two methods-
1. To delete image name from database
2. To delete image file from the disk.

Done.....

Member 12007795 6-Oct-15 9:34am

I have one problem when I update the image then the earlier image would not deleted from the folder of the project give me solution on that

5 solutions

Solution 5

Write a stored procedure, in that first store the image name in a variable and then delete the record from the database, and then return that variable value to the calling method, here check the value is valid or not, if valid then the return value is Path of the image, if not then surly the error has occured while deleting record. now you can delete the image file from the folder.
as like below...

System.IO.File.Delete(path);

Posted 20-Nov-13 1:26am

Dnyaneshwar@Pune

Solution 2

Hi,
You can use SqlTransaction to delete the image from database under this transaction. Then delete the image from the folder.
I think you can use this code to delete image :

string filePath = Server.MapPath("~/" + PathDB);
if (System.IO.File.Exists(filePath))


{


System.IO.File.Delete(filePath);


}

Where PathDB contains the path from database.
I hope it will be helpful for you.
good luck

Posted 18-Nov-13 21:58pm

fkassaie

Updated 18-Nov-13 21:59pm

v3

Solution 1

Hi Mavendra,

Try this link[^].
Hope it will be very useful to you.

Regards,
RK

Posted 18-Nov-13 21:39pm

♥…ЯҠ…♥

Solution 3

C#

if (delImage != "" && delImage != null)
                              {
                                  System.IO.File.Delete(Request.PhysicalApplicationPath + "Upload/" + delImage);
                              }

delimage - image name

Posted 18-Nov-13 22:37pm

King Fisher

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)

manvendra patel · Accepted Answer · 2013-11-20T01:11:00

C#

foreach (DataListItem li in dlimagegallery.Items)
        {


            Image imagepath = li.FindControl("Image1") as Image;
            string path = Server.MapPath("imagepath");

            if (System.IO.File.Exists(path))
            {


                System.IO.File.Delete(path);
                Label1.Text = "File succefully deleted";

            }

Image find control does not find image Url.when i bind Label1.Text=imagepath then it show System.Web.UI.WebControls.Image.but this namespace i am already used. plz give me anyone soln.