Asp. NET allows images to be stored in a binary form in the database

This morning a netizen asked me this question, before I was directly in the database file name, has not tried to store the whole picture into the database, the Internet search for a bit, and tested some of them, the code is as follows:
Create the SQL statement for the table that holds the picture:

SQL code

2. Use [Niunantest]
4. GO
6. /****** object: Table [dbo].[ Picdata] Script Date: 03/30/2010 14:51:58 ******/
8. SET ansi_nulls on
10. GO
12. SET quoted_identifier on
14. GO
16. CREATE TABLE [dbo].[ Picdata] (
18. [ID] [int] IDENTITY (*) not NULL,
20. [Content] [Image] NULL,
22. [CreateDate] [DateTime] not NULL CONSTRAINT [df_picdata_createdate] DEFAULT (getdate ()),
24. CONSTRAINT [Pk_picdata] PRIMARY KEY CLUSTERED
26. (
28. [id] ASC
30. ) with(Pad_index = off, Statistics_norecompute = off, Ignore_dup_key = off, allow_row_locks = on , A Llow_page_locks = on ) on [PRIMARY]
32. ) on [PRIMARY] textimage_on [PRIMARY]

Here is the code snippet to save the picture to the database:

C # code

2. int len = fu.  Postedfile.contentlength; //Picture size
4. byte[] pic = new Byte[len]; //Create a byte array, size is the size of the picture, the database stores this thing
6. Fu. PostedFile.InputStream.Read (pic, 0, Len); //The file in the upload control is stored in a binary read in the pic byte array
8. Insert a picture into the database
10. SqlConnection connection = new
12. SqlConnection (@"server=.\sqlexpress;database=niunantest;uid=sa;pwd=123456");
14. Try
16. {
18. Connection. Open ();
20. SqlCommand cmd = new SqlCommand ("insert into Picdata"
22. + "([content]) VALUES (@pic)", connection);
24. Cmd.  Parameters.Add ("@pic", pic);
26. Cmd. ExecuteNonQuery ();
28. Label1.Text = "picture inserted database succeeded!"  ";
32. Image1.imageurl = "getpic.ashx?t=" + DateTime.Now.Ticks; //Display pictures just inserted into the database
34. }
36. Finally
38. {
40. Connection. Close ();
42. }

Here is a snippet of the picture taken from the database:

C # code

2. MemoryStream stream = new MemoryStream ();
4. SqlConnection connection = new
6. SqlConnection (@"server=.\sqlexpress;database=niunantest;uid=sa;pwd=123456");
8. Try
10. {
12. Connection. Open ();
14. SqlCommand command = new
16. SqlCommand ("SELECT top 1 [content] from Picdata ORDER by id DESC", connection);
18. byte[] image = (byte[]) command.  ExecuteScalar ();
20. Stream. Write (image, 0, image. Length);
22. Bitmap Bitmap = new Bitmap (stream);
24. Context.  Response.ContentType = "Image/jpeg";
26. Bitmap. Save (context. Response.outputstream, System.Drawing.Imaging.ImageFormat.Jpeg);
28. }
30. Finally
32. {
34. Connection. Close ();
36. Stream. Close ();
38. }

In fact, through the flow of the picture into a byte array to the database, and then read the byte array from the database, and then through the byte array to create a stream, and then through the flow of the image output, found that you stored in the database is a GIF image, and then take out the image can be converted to JPG, Because when we take out the image, we set his contenttype to be image/jpeg.

SOURCE Download: http://niunan.net/download/picsave2db.7z