fileupload control file path

Question

0.00/5 (No votes)

See more:

Hello sir.

I am using file upload contol to upload an image in folder.
The image is uploading to folder properly, but I want to save the image path in the database.
How can I save the file path in the database?
Can anybody help me please?

My code is given below:

C#

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;
using System.Data.SqlClient;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void BtnSave_Click(object sender, EventArgs e)
    {
        try
        {
            String picture;
            if (FileUpload1.PostedFile.FileName.EndsWith(".jpg") || FileUpload1.PostedFile.FileName.EndsWith(".gif") || FileUpload1.PostedFile.FileName.EndsWith(".png"))
            {
                string strfilename;

                //string filename = Path.GetFileName(FileUpload1.FileName);

                string File_Path_Text = FileUpload1.PostedFile.InputStream.ToString();
                //string filepath = FileUpload1.PostedFile.ContentLength();

                strfilename = FileUpload1.PostedFile.FileName;
                strfilename = strfilename.Substring(strfilename.LastIndexOf("\\") + 1);
                FileUpload1.SaveAs(Server .MapPath("\\Test\\" + strfilename));
                Server.MapPath("~/images/" + FileUpload1.FileName);
                picture = strfilename;

                SqlParameter [] oparam=new SqlParameter[3];
                oparam[0]=new SqlParameter("@LocationId", TxtLocationId .Text );
                oparam[1]=new SqlParameter("@LocationName", TxtLocationName.Text );
                oparam[2] = new SqlParameter("@Image", File_Path_Text);

                DataSet ds = new DataSet();
                ds = BusinessLogic.InsertImage(oparam);
                //LblShow.Text = "File Saved at:" + filepath;
            }

            //if (FileUpload1.PostedFile.ContentLength != 0)
            //{

            //    DataSet ds = new DataSet();

            //    FileUpload1.SaveAs(@"Test\\" + FileUpload1.FileName);

            //    Server.MapPath("images\\" + FileUpload1.FileName);

                //string path = FileUpload1.PostedFile.FileName;
                //FileUpload1.SaveAs("@\\Test\\" + FileUpload1.FileName);

                //Server.MapPath("\\images\\" + FileUpload1.FileName);
                //SqlParameter [] oparam=new SqlParameter[4];
                //oparam[0]=new SqlParameter("@LocationId", TxtLocationId .Text );
                //oparam[1]=new SqlParameter("@LocationName", TxtLocationName.Text );
                //oparam[2]=new SqlParameter ("@Image", FUImage .FileName );

                //DataSet ds = new DataSet();
            //}
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
}

Posted 2-Nov-10 0:34am

sathish.jampala

Updated 2-Nov-10 0:57am

Deeksha Shenoy

v2

Add a Solution

Comments

Ankur^\m/ 2-Nov-10 7:28am

Use 'Add Comment' below a user's answer to discuss with him because that notifies the user about your response, an answer doesn't.

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

Henry Minute · Answer 1 · 2010-11-02T00:45:00

Solution 1

From the code you have posted, it would seem that BusinessLogic.InsertImage() is the method that does the work.

Beyond that it is impossible to help you without seing the code for that.

Posted 2-Nov-10 0:45am

Henry Minute

Comments

Ankur^\m/ 2-Nov-10 7:25am

[moved from answer]
OP wrote:

hai. thanks for ur reply.
actually i am storing image path in varchar format.
my stored procedure is
below
USE [Test]
GO
/****** Object: StoredProcedure [dbo].[SP_InsertImage] Script Date: 11/02/2010 16:33:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
alter proc [dbo].[SP_InsertImage]
(
@LocationID int,
@LocationName nvarchar(20),
@ImagePath nvarchar(20)
)
as begin
insert into ImageTable
(
LocationID ,
LocationName,
ImagePath
)
values
(
@LocationID ,
@LocationName,
@ImagePath
)
end
exec SP_InsertImage '1','hyd','sun.png'

it is workig well.

i am just storing the file path. from where we are selecting the file.

plz help me.
how can get the filepath using fileupload control.

Hiren solanki · Answer 2 · 2010-11-02T00:57:00

Solution 2

SQL

INSERT INTO table(FilePath) VALUES (FileUpload.PostedFile.FileName)

AFAIU you can run this query inside your code and you will have your path in database.

Or I am missing something ? Kindly give your inputs for further solution.

Posted 2-Nov-10 0:57am

Hiren solanki

Comments

Ankur^\m/ 2-Nov-10 7:24am

[moved from answer]
OP wrote:

hai. thanks for ur reply.
actually i am storing image path in varchar format.
my stored procedure is
below
USE [Test]
GO
/****** Object: StoredProcedure [dbo].[SP_InsertImage] Script Date: 11/02/2010 16:33:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
alter proc [dbo].[SP_InsertImage]
(
@LocationID int,
@LocationName nvarchar(20),
@ImagePath nvarchar(20)
)
as begin
insert into ImageTable
(
LocationID ,
LocationName,
ImagePath
)
values
(
@LocationID ,
@LocationName,
@ImagePath
)
end
exec SP_InsertImage '1','hyd','sun.png'

it is workig well.

i am just storing the file path. from where we are selecting the file.

plz help me.
how can get the filepath using fileupload control.

m@dhu · Answer 3 · 2010-11-02T02:22:00

SqlParameter [] oparam=new SqlParameter[3];
                oparam[0]=new SqlParameter("@LocationId", TxtLocationId .Text );
                oparam[1]=new SqlParameter("@LocationName", TxtLocationName.Text );
//@Image is different from procedure @Imagepath
                oparam[2] = new SqlParameter("@ImagePath", FileUpload1.FileName);
//for complete path use
oparam[2] = new SqlParameter("@ImagePath", FileUpload1.PostedFile.FileName);

fileupload control file path

3 solutions

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us