Save a file form path to sql databse using save button click

Question

1.00/5 (1 vote)

See more:

Hi All,

I have created on form.
Controls are as follows.

txtPathfile - text box
cmdUpload - button
opendialoguebox1- opendialoguebox

I able to do getting path of the uploaded file in to the txtPathfile.text

but i cannot save that file like documents/images...into sql database.

Please help me.

rajug

Posted 29-May-13 19:14pm

rajugknr

Updated 30-May-13 3:10am

v4

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 30-May-13 2:29am

What have you tried ? And in which technology ?
Please tag your question with correct tech. tags ?

rajugknr 30-May-13 2:32am

If I used "update TABLENAME set FIELDNAME = @P_PathFile" is this code can save the file in to the sql database

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 30-May-13 4:22am

If you want to save you should use INSERT statement and if you want update, then you should use UPDATE statement.

rajugknr 30-May-13 2:43am

I am using windows application with C# language.
I need to save the uploaded file into the sql database using file full path that is on one textbox control.

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

_Damian S_ · Answer 1 · 2013-05-29T20:24:00

Create a stored procedure that takes one parameter, and pass the value of the txtPathfile into the parameter.

If you are wanting to update an existing record, use an update statement like this:

SQL

update TABLENAME set FIELDNAME = @P_PathFile

If you are wanting to insert into a new record, use an insert statement like this:

SQL

insert into TABLENAME (FIELD1, FIELD2,...,FIELDN) values (VALUE1, VALUE2, ..., VALUEN)

Murali0195 · Answer 2 · 2013-06-01T00:30:00

Solution 2

Hii...
try this one,its may useful to u.

How to store & retrieve images in mysql database using asp.net c#[^]

thank u.

Posted 1-Jun-13 0:30am

Murali0195