insert multiple file upload files in database column as a hyperlink

Question

0.00/5 (No votes)

See more:

C#

foreach (HttpPostedFile postedFile in fudoc.PostedFiles)
                   {

                            doc = Path.GetFileName(postedFile.FileName);

               postedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/Document/"), doc));

                           docName += String.Format("{0}", doc);


                   }

//string insert query..... //please help me out. how to insert multiple files in single column in database as a hyperlink. //thanks

Posted 6-Nov-14 17:58pm

Bunty Arslan

Add a Solution

1 solution

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)

Mukesh Ghosh · Accepted Answer · 2014-11-06T18:58:00

Solution 1

Store all the link as comma separated in a column, while fetch break the string based on comma.

Posted 6-Nov-14 18:58pm

Mukesh Ghosh

Comments

Bunty Arslan 7-Nov-14 1:02am

docName += String.Format("{0}<br/>", doc);
like this ?

Mukesh Ghosh 7-Nov-14 1:05am

no, this way docName += ","+String.Format("{0}", doc);
Once complete docName prepared, remove last "," before insert in DB by trim function

Bunty Arslan 7-Nov-14 1:11am

insert into table (document) values('"+docname.trim(,)+"');
like this?

Mukesh Ghosh 7-Nov-14 1:14am

Please debug first & see what docname contain before asking small steps.

Bunty Arslan 7-Nov-14 1:18am

,doc1.docx,doc2.docx
docname contains this.

Bunty Arslan 7-Nov-14 1:20am

how can i trim?
this is my final task please help me out

Mukesh Ghosh 7-Nov-14 1:21am

Can't you create simple hyper link for single document (eg. for doc1.docx) &
concate the way i have shown?http://www.dotnetperls.com/trimstart. Note i am here to guide you but i will not do your homework.

Bunty Arslan 7-Nov-14 1:24am

it creates single hyperlink. but i want to store multiple hyperlink using the same file upload control.