• Download DBImage.zip - 5.0 KB

Introduction

Actually it is not good to store Image file into Database But some time it is necessary to store it. Here I am giving solution to storing and displaying Image to Database.

Using the code

This will help you to storing and Displaying Image to Database -here Sql Server 2005.

First of all create page named AddEmployee.aspx and add repeater to it shown in source file.

The main idea is that: I am storing Image files into database directly into Binary Format. So storing it first convert it into Binary:

            SqlParameter prmFName = 

Now at Image viewing time:

      <td id=

At the DisplayImage.aspx Page:

            cmdAddEmp.CommandText = 

Response.BinaryWrite(byteImg) writes binary content of the Image and display Image.