How to Save a file that is in a folder into database on button Click

Question

1.00/5 (1 vote)

See more:

Hello !!!

I have a situation where i have to save a image that is in a folder into database on button click.
I am working on an gate pass application. I have saved image that is being clicked by webcam into a folder but i am stuck at how to save this into databse on button click.

please guide me what should i do !!I don't want to insert path of this image into database but the image itself whan button Save is clicked.

Posted 29-Aug-12 2:35am

ujjwal uniyal

Updated 29-Aug-12 19:02pm

v2

Add a Solution

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)

bhagirathimfs · Answer 1 · 2012-08-29T02:39:00

Solution 2

You have saved the image in your local folder.
now insert the path of the image where it is saved into the database.

Posted 29-Aug-12 2:39am

bhagirathimfs

Comments

ujjwal uniyal 30-Aug-12 1:15am

I don;t want to save the path of the file in database but the file itself. i'll delete the file from the folder after saving it in the database

**AmitGajjar** · Answer 2 · 2012-08-29T19:25:00

Solution 3

Hi,

I found an article in code project. it will work for you,

Please check Storing and Retrieving Images from SQL Server using Microsoft .NET[^]

Although you have not specified your database but here in above article it's MSSQL

Thanks
-Amit Gajjar

Posted 29-Aug-12 19:25pm

AmitGajjar

Comments

ujjwal uniyal 30-Aug-12 1:34am

I know how to save and retrieve image from sql server. What i need to know is how to save image from folder into database. In case of file upload i know what to do.I make an instance of HttpPostedFile and then use it to save file but what should i use here ??

AmitGajjar 30-Aug-12 1:37am

What you need to do is to Convert your image into Byte Array and pass it as an SP argument. you can create Image type column in the database. is this what you want to know ?

AmitGajjar 30-Aug-12 1:38am

But if you are using latest SQL server version then Image data type is removed instead you can use varbinary(max).

__TR__ · Answer 3 · 2012-08-29T02:39:00

Solution 1

You need to use the file upload control.
Refer the below article
File Upload with ASP.NET[^]

Posted 29-Aug-12 2:39am

__TR__