saving a physical path of image in database and upload image to disired folder

Question

0.00/5 (No votes)

See more:

i am trying to save image physical path in database and upload image to the disired folder in my project using file upload control..

i am new in uploading images so don't know exactly how to do that..

i tried to do that using this method

C#

if (FileUpload1.HasFile)
        {
            string path = Server.MapPath(".") + "\\Images\\" + FileUpload1.FileName;
            FileUpload1.SaveAs(path);

         
            string query = "insert into Products(CategoryID,ProductName,ProductImage,UnitCost,Description)select CategoryID,'" + txtproname.Text + "','" + FileUpload1.FileName + "'," + txtproprice.Text + ",'" + txtprodesc.Text + "' from Categories where CategoryName='" + DropDownList1.Text + "'";

i am not exactly understanding the Server.MathPath. but its uploading the images in the admin folder where my page products.aspx (from which i am uploading images ) is present. moreover its save just the filename like

C#

product.gif

(not the ful path.)

i want to save image in the root images folder. can anyone pls help me to do that. and i want to save complete physical path in database as

~/images/product.gif

Posted 11-Sep-11 12:42pm

codegeekalpha

Add a Solution

Comments

AditSheth 12-Sep-11 8:34am

Instead of "." in server.MapPath use "~" to locate root folder
"." - Current Page Folder Location
"~" - Project Folder Location

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

s_magus · Accepted Answer · 2011-09-11T14:22:00

If the path you pass to MapPath does not start with either a forward or back slash the method returns a path relative to the directory the page is in. Which is what you are seeing when images are uploaded in the admin folder. The following should produce what you want.

C#

string path = Server.MapPath(@"/Images") + FileUpload1.FileName;

As for the DB issue it is only inserting product.gif since you are just passing in FileUpload1.FileName which contains just the filename. If you want the full path you need to pass in the path variable. You should really get out of the bad habit of writing you SQL statements using string concatenation. There are no pros to using string concatenation, and plenty of cons.

AditSheth · Accepted Answer · 2011-09-12T02:30:00

Solution 4

If you want to save rooted path like Path ="Images\product.gif"

C#

if (FileUpload1.HasFile)
{
    string path =  @"Images\" + FileUpload1.FileName;
    FileUpload1.SaveAs(Server.MapPath("~") + @"\" + path);
    // Save process strfilename = path 
}

Posted 12-Sep-11 2:30am

AditSheth

angappans · Accepted Answer · 2011-09-12T00:33:00

XML

hi,

try to give following format.,


<code>if (FileUpload1.postedfile.contentlength>0)
{
  string path = Server.Mappath(@"~/images/"+'"+FileUpload1.Filename+"')
  FileUpload1.SaveAs(path);

//now save the path value to your database.

   string query = "insert into Products(CategoryID,ProductName,ProductImage,UnitCost,Description)select CategoryID,'" + txtproname.Text + "','" + path  + "'," + txtproprice.Text + ",'" + txtprodesc.Text + "' from Categories where CategoryName='" + DropDownList1.Text + "'";
}
else
{
messagebox("file content length is zero");
}</code>
i hope this is useful to you...
take care

Anuja Pawar Indore · Accepted Answer · 2011-09-12T02:09:00

try this

C#

public const string FOLDER_UPLOADIMAGE_PATH = ".\\UploadedImages\\";
HttpPostedFile file = FUProductImage.PostedFile;
            string strfilename = FUProductImage.PostedFile.FileName;
            string c = System.IO.Path.GetFileName(strfilename);
            FUProductImage.PostedFile.SaveAs(Server.MapPath(FOLDER_UPLOADIMAGE_PATH + c));
            string filepath = Server.MapPath(FOLDER_UPLOADIMAGE_PATH + c);

saving a physical path of image in database and upload image to disired folder

4 solutions

Solution 1

Solution 4

Solution 2

Solution 3

Add your solution here

Preview 0