Read and write image files to SQL Server database

server|sqlserver| Data | Database using ASP to read and write image files to SQL Server database

A form that sends an image file

Img_upload.asp



Second, accept the form from the image file

In the img_upfile.asp file


With the above code, the image file already exists in the variable MyData

Third, the image data into the database

The above code first to determine the database ID record in the field of newid has no data, if there is to update the database with the current data, if not the data inserted.

Please note: The NEWID is defined elsewhere, and the reader does not have to ignore

Read the image file in the database and display it on the Web page
Use the following code to display the data on the Web page, please note that the, label SRC indicates the showimg.asp file. That is, the tag does not necessarily point to. gif


The core part is in the showimg.asp file:


After you remove the data, output it to the browser with Response.BinaryWrite and GetChunk.