Image upload and display from database

Question

0.00/5 (No votes)

See more:

uploading image in database and wants to show that image in gridview bt when uploading image i m getting an issue..help me/remove erroer plzz..

C#

protected void Button1_Click(object sender, EventArgs e)
   {
       if (FileUpload1.HasFile)
       {
           String str = FileUpload1.FileName;
           FileUpload1.PostedFile.SaveAs(Server.MapPath(",") + "~//uploadedimages//" + str);
           string path = "~//Uploads//"+str.ToString();
           con.Open();
           SqlCommand cmd = new SqlCommand("insert into uploads values('" + TextBox1.Text + "','" + path + "')", con);
           cmd.ExecuteNonQuery();
           con.Close();
           Label1.Text = "Image upload Successfully";
       }
       else
       {
           Label1.Text = "Plz select ur image and upload";
       }

   }

error occoured when i use path as= "~//uploadedimages//"

Could not find a part of the path 'F:\Atverse\Web Example\Image\,~\uploadedimages\Chrysanthemum.jpg'.

error occoured when i use path as= ""~F:/Atverse/Web Example/Image/uploadedimages/"

The given path's format is not supported.

plzz tell me error..or right code for this.

Posted 7-Jan-14 19:29pm

amit1992

Add a Solution

Comments

Sibasisjena 8-Jan-14 1:54am

Check my solution. If this will not work then give me your file structure.

amit1992 8-Jan-14 2:17am

@sibasis05 sir ur code when i use on my machine is showing error in Cmd.ExecuteNonQuery();

unable to remove this error...many times before also..

Sibasisjena 8-Jan-14 2:33am

Ok please check my next updated solution

amit1992 8-Jan-14 2:41am

changes which u made in updated code i tried before and nw replaced my code with ur given code bt error is...

""Column name or number of supplied values does not match table definition.""

i m giving u the database table query of this..

CREATE TABLE [dbo].[uploads](
[uid] [int] NOT NULL,
[uname] [varbinary](max) NULL,
[uimg] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Sibasisjena 8-Jan-14 2:50am

please wait, i will give you a updated sol.

amit1992 8-Jan-14 2:51am

Okk sir i m waiting

Sibasisjena 8-Jan-14 3:02am

Check my solution 4. I have updated it. Your table structure is wrong . The primary key column always will be the Identity(1,1). Please check my solution.

amit1992 8-Jan-14 3:16am

Error at same palace cmd.executenonquery(); bt

Nw occouring error in conversion of datatype...
Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.

Sibasisjena 8-Jan-14 3:20am

Run this script in sql server management studio:
ALTER TABLE [dbo].[FileUploads]
ALTER COLUMN [uname] VARCHAR(MAX)

amit1992 8-Jan-14 3:59am

After using this sql script Image Path is going in database bt
error is in next part.
in this line...
FileUpload1.SaveAs(theFileName);

Could not find a part of the path 'F:\Atverse\Web Example\Image\Uploads\Hydrangeas.jpg'

Sibasisjena 8-Jan-14 1:59am

i think you have some problem in retriving the file path

4 solutions

Solution 2

Please have a look on the below link
save image in file and path in database asp.net[^]

C#

protected void Button1_Click(object sender, EventArgs e)
        {
            if (FileUpload1.HasFile)
            {
                string theFileName = Path.Combine(Server.MapPath("~/Uploads"), FileUpload1.FileName);

                SqlCommand cmd = new SqlCommand("insert into FileUploads values('" + TextBox1.Text + "','" + theFileName + "')", con);
                cmd.ExecuteNonQuery();
                con.Close();
                if (File.Exists(theFileName))
                {
                    File.Delete(theFileName);
                }
                FileUpload1.SaveAs(theFileName);
                Label1.Text = "Image upload Successfully";
            }
            else
            {
                Label1.Text = "Plz select ur image and upload";
            }

        }

You can have a look upon :
How to get the path, a good article [^]

Posted 7-Jan-14 19:53pm

Sibasisjena

Updated 7-Jan-14 21:02pm

v5

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)

Gitanjali Singh · Accepted Answer · 2014-01-07T19:49:00

Solution 1

C#

string
                filename = Path.GetFileName(fileupload1.FileName);
                fileupload1.SaveAs(Server.MapPath("~/")
                + filename);

Give it a try,Hope this will help.

Posted 7-Jan-14 19:49pm

Gitanjali Singh

Comments

amit1992 8-Jan-14 4:54am

@Gitanjali Singh using your code image is uploading and going into database bt not going in folder(which is in Website->uploadimage) so gridview is not showing images

amit1992 8-Jan-14 4:58am

Sry i was making a mistake its going in folder also nw.
Thnxx..

Sibasisjena · Accepted Answer · 2014-01-07T20:34:00

Run this script in sql server management studio

SQL

CREATE TABLE [dbo].[FileUploads](
	[uid] [int] IDENTITY(1,1) NOT NULL,
	[uname] [nvarchar](max) NULL,
	[uimg] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

change the following line in the method:

C#

SqlCommand cmd = new SqlCommand("insert into FileUploads values('" + TextBox1.Text + "','" + theFileName + "')", con);

Updated one:

C#

protected void Button1_Click(object sender, EventArgs e)
        {
            string connectionString = "Put your connection string here";
            if (FileUpload1.HasFile)
            {
                string theFileName = Path.Combine(Server.MapPath("~/Uploads"), FileUpload1.FileName);

                using (var con = new SqlConnection(connectionString))
                {
                    con.Open();
                    SqlCommand cmd = new SqlCommand("insert into uploads values('" + TextBox1.Text + "','" + theFileName + "')", con);
                    cmd.ExecuteNonQuery();
                }
                if (File.Exists(theFileName))
                {
                    File.Delete(theFileName);
                }
                FileUpload1.SaveAs(theFileName);
                Label1.Text = "Image upload Successfully";
            }
            else
            {
                Label1.Text = "Plz select ur image and upload";
            }

        }

Don't forget to use your own connection string to the server.

Suk@nta · Accepted Answer · 2014-01-07T19:58:00

Solution 3

C#

FileUpload1.SaveAs(Server.MapPath("~/uploadedimages/") + str);

I think it helps you...
let me know if any problem u got..

Posted 7-Jan-14 19:58pm

Suk@nta