Saving image file into the database

Question

how can i save the file using c# into the SQL server dataqbase after user has selected the file location using fileupload control in asp.net .

are you sure you want to store these images into database? because it consume a lot of space ? — rahularyansharma
– rahularyansharma, Commented Jul 4, 2011 at 11:02
shabdar.org/sql-server/105-store-save-images-in-sql-server.html — rahularyansharma
– rahularyansharma, Commented Jul 4, 2011 at 11:04
possible duplicate of [C# : Saving an Image into DB ](stackoverflow.com/questions/5806159/c-saving-an-image-into-db) — marc_s
– marc_s, Commented Jul 4, 2011 at 11:08
i have already seen that.but i didnt get a good answer there — saurabh goyal
– saurabh goyal, Commented Jul 4, 2011 at 11:12

Cody Gray · Accepted Answer · 2012-05-26 12:13:54Z

0

You might try something like this:

if (this.fileUploader.PostedFile == null ||
    this.fileUploader.PostedFile.ContentLength < 1)
{
   this.LabelError.Text = this.GetGlobalResourceObject("Messages", "NoFileToUpload")
                              .ToString();
   return;
}

MyTableWithImageField i = new MyTableWithImageField();

i.ImageData = this.fileUploader.FileBytes;

command.CommandText = @"InsertMyTableWithImageField";
command.CommandType = CommandType.StoredProcedure;

command.Parameters.AddWithValue("@ImageData", i.ImageData);

You may also want to check this from MSDN: Uploading Files in ASP.NET 2.0

edited May 26, 2012 at 12:13

Cody Gray♦

246k53 gold badges513 silver badges591 bronze badges

answered Jul 4, 2011 at 11:11

Ventsy Popov

52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Saving image file into the database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related