how to save multiple file paths in sql database column when user uploads multiple attachments using file upload control?

Question

1.00/5 (1 vote)

See more:

I have an asp.net FileUpload control.

Now i want to upload multiple attachments and save uploaded file paths in sql database.

here how to save multiple file paths in sql server column if user uploads multiple attachments using file upload control?

i want the code how to save multiple file paths in sql server file path column?

Posted 14-Nov-12 4:21am

deepisingh

Add a Solution

Comments

Herman<T>.Instance 14-Nov-12 10:23am

you question yourself about what you want?

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)

Christian Graus · Answer 1 · 2012-11-14T04:32:00

Solution 1

Well, you have two options. One : choose a character that is not valid for a file path, like ?, and use that as a delimiter to store a list that needs to be split. Second, create a mapping table so you can map multiple file paths to one entry by it's id. So your main table has an id column and your new table contains that id, and a file path, with one entry per path.

Posted 14-Nov-12 4:32am

Christian Graus

Comments

deepisingh 14-Nov-12 10:50am

i want code how to use delimiter and store to list and split

Christian Graus 14-Nov-12 10:54am

This is beyond trivial. The string class has a split method, and you should use StringBuilder, not just +, to build the string. This is the least good option, overall.

deepisingh 14-Nov-12 10:58am

anyone pls help me out by giving sample code

Christian Graus 14-Nov-12 11:03am

string [] paths = thepath.Split('?');

I do recommend if you ever want to be a programmer, being willing to do basic research on your own and to know some basic concepts.

deepisingh 14-Nov-12 11:04am

if user delete the file attachment then tht file path must be remove from list and save in database

Christian Graus 14-Nov-12 11:06am

Sounds like a reasonable requirement. Do you intend to do any of your job yourself ? Do you expect I can give you copy/paste code to do this for you ? I can't, I don't know the DB schema for a start, and at some point, you need to be able to write code without asking others to do it for you.

deepisingh 14-Nov-12 11:05am

string [] paths = thepath.Split('?');
after tht u want me to keep loop of strig builder and in every loop u want me to insert in db?

Christian Graus 14-Nov-12 11:15am

I think this is the worse option. How you do it is up to you. I would recommend the other option I gave, if you were asking