ADO.NET 3.5 Cookbook, 2nd Edition

8.10. Displaying an Image from a Database in a Web Forms Control

Problem

You need to display an image from a database field in an ASP.NET control.

Solution

Fill an ASP.NET Image control from a database field by pointing the ImageUrl property of an Image control to a second web page that retrieves the image from the database and streams it back to the caller.

Follow these steps:

1. Create a C# ASP.NET web application named BindWebFormSimpleControl.

2. Add the following control to the Default.aspx design surface:

   • Image control named productPhotoImage

   The completed layout of the Web Form page Default.aspx is shown in Figure 8-19.

   

   Figure 8-19. Layout for Default.aspx in LoadImageIntoWebFormControl solution

   The code in Default.aspx in the project LoadImageIntoWebFormControl is shown in Example 8-19.

   Example 8-19. File: Default.aspx for LoadImageIntoWebFormControl solution

   <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs"
       Inherits="LoadImageIntoWebFormControl._Default" %>
   <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
       "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   <html xmlns="http://www.w3.org/1999/xhtml" >
   <head runat="server">
       <title>Untitled Page</title>
   </head>
   <body>
       <form id="form1" runat="server">
       <div>
           <asp:Image ID="productPhotoImage" runat="server" Height="200px" Width="200px" />
       </div>
       </form>
   </body>
   </html>

3. Create the C# code-behind code in ...