writing path of file into sql

Question

1.00/5 (2 votes)

See more:

I have been able to use the following method Upload multiple files in asp.net[^]to upload files successfully, but i haven't been able to figure out how to write file(s) name and path to sql. I have tried getting file names but it only returns with last file selected and not all files.

C#

string filesname = System.IO.Path.GetFileName(hpf1.FileName);

I have not be able to figure out how to get all files selected names.

Please help.

Per Req:

C#

try
{
    HttpFileCollection hfc1 = Request.Files;
    for (int i = 0; i < hfc1.Count; i++)
    {
        string ponoref = txtRequsitionNo.Text;

        String pathref = Server.MapPath("~/uploads/" + ponoref + "/");

        if (!System.IO.Directory.Exists(pathref))
        {
            System.IO.Directory.CreateDirectory(pathref);
        }

        HttpPostedFile hpf1 = hfc1[i];
        if (hpf1.ContentLength > 0)
        {
            hpf1.SaveAs(Server.MapPath("~/uploads/") + ponoref + @"/" + System.IO.Path.GetFileName(hpf1.FileName));
        }
        string filesname = System.IO.Path.GetFileName(hpf1.FileName);

        string POREF = @"uploads\" + ponoref + @"\" + filesname;

        powholeref.Text = POREF.ToString();
    }
}
catch (Exception)
{

    throw;
}

txtRequsitionNo.Text = string.Empty;

Posted 15-Dec-15 4:32am

r00n3y

Updated 15-Dec-15 9:13am

v2

Add a Solution

Comments

Tomas Takac 15-Dec-15 11:00am

Please show the whole code where you extract the file names and save them to database.

r00n3y 15-Dec-15 11:32am

I have posted the code i use to extract. nothing else. Basically im trying to get all the file names not just last one.

Richard Deeming 15-Dec-15 13:10pm

You haven't posted anywhere near enough code for anyone to diagnose the problem. You've shown a single line of code which extracts the file name from a variable which is presumably an HttpPostedFile. You haven't shown how you're calling that code, or how it "returns" the last file selected.

Click "Improve question" and update your question with the relevant parts of your code.

r00n3y 15-Dec-15 15:13pm

Updated the question.

Tomas Takac 16-Dec-15 3:40am

Well you said your problem is in storing the path and file name to a database. Yet you are not showing the related code, where you are actually storing it. How are we supposed to help you?

r00n3y 16-Dec-15 9:49am

Its not storing all files name/location. If you are uploading multiple files itll only show last file not the rest files you upload.

2 solutions

Solution 1

Don't post this under Quick Answers - if you got the code from an article, then there is a "Add a Comment or Question" button at the bottom of that article, which causes an email to be sent to the author. They are then alerted that you wish to speak to them.
Posting this here relies on them "dropping by" and realising it is for them.

Posted 15-Dec-15 5:03am

OriginalGriff

Comments

r00n3y 15-Dec-15 11:34am

I get it, but based on the comments that already there i doubt author will be replying. Thats why i decided to post this under Quick Answers.

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)

Tomas Takac · Accepted Answer · 2015-12-16T04:04:00

You are assigning all the file names into one variable. As you go over the files in the for-loop this is always overwritten by the current file name and naturally after you exit the loop there is the last one. What you need is a list.

C#

var listOfFiles = new List<string>(hfc1.Count);
for (int i = 0; i < hfc1.Count; i++)
{
    // ...

    string filesname = System.IO.Path.GetFileName(hpf1.FileName);
    listOfFiles.Add(filesname);

    // ...
}

// do something with listOfFiles