How to save Image into folder from sql database

Question

1.36/5 (4 votes)

See more:

C#2.0

C#

ASP.NET

How to save Image into folder(Server.MapPath("Temp\\" )) from sql database.

Posted 11-Jan-12 22:13pm

Robymon

Updated 12-Jan-12 2:58am

Mehdi Gholam

v2

Add a Solution

4 solutions

Solution 1

Hi you can save like this,

C#

string fname= System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);
string activeDir = System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath + "Temp";
System.IO.Directory.CreateDirectory(activeDir);
string newPath = System.IO.Path.Combine(activeDir, fname);
FileUpload1.PostedFile.SaveAs(newPath);

Posted 11-Jan-12 22:28pm

palraj001

Comments

Robymon 12-Jan-12 4:31am

I need a solution from sql to folder. i know this.

Solution 4

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

for saving into folder:

C#

//Get Filename from fileupload control
                string filename = Path.GetFileName(imgful.PostedFile.FileName);
                //Save images into foldername folder
                imgful.SaveAs(Server.MapPath("~/foldername/" + filename));

and write ur insert query.

thank u.

Posted 7-Jun-13 3:01am

Murali0195

Updated 10-Jun-13 19:04pm

v3

Comments

CHill60 7-Jun-13 10:19am

If you have a question then post it as a question, not as a solution to a different question that is over a year old

Solution 5

If you have a limited number of images in the table you can go with the solution that need to iterate all the rows, read image bytes and write them on the disc. But this approach will be extremely expensive in case you have a large number of images. In this condition, you should use SSIS. Following is a step by step tutorial on how to do that:

http://www.mssqltips.com/sqlservertip/2693/export-images-from-a-sql-server-table-to-a-folder-with-ssis/[^]

Posted 7-Jun-13 3:13am

Zafar Sultan

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)

Om Prakash Pant · Accepted Answer · 2012-01-11T22:37:00

Once the image is saved in the database, you can retreive the image and save in a file as follows:

C#

SqlCommand mycmd = new SqlCommand("select image_field from your_table where field_id = @ID",yourSqlConn);
cmdSelect.Parameters.Add("@ID",SqlDbType.Int,4);
cmdSelect.Parameters["@ID"].Value = 100; //this can be also an input for user etc.

yourSqlConn.Open();
byte[] img=(byte[])cmdSelect.ExecuteScalar();
string strfn=Convert.ToString(DateTime.Now.ToFileTime());
FileStream fs=new FileStream(strfn,FileMode.CreateNew, FileAccess.Write);
fs.Write(img,0,img.Length);
fs.Flush();
fs.Close();

check the following article for more details:
Storing and Retrieving Images from SQL Server using Microsoft .NET[^]