ASP.Net Problem

[Puneet Gupta]

how to Retrive Image in Data Base(Sql Server2000)

[Stang02GT]

how to Retrive Image in Data Base(Sql Server2000)

This article will answer your question

[kunal pawar]

below code is used to show image from database but u have give page as url to image tag with proper image id
<img src="showImage.aspx?imageid=121" />
--------- showImage.aspx

<%@ Page Language="vb" AutoEventWireup="false" %>
<%@import  Namespace=System.IO %>
<%@Import namespace=System.Data.SqlClient %>
<%@Import namespace= System.Threading %>
<%@Import namespace= System  %>
<%@Import namespace= System.Data  %>
<%@Import namespace= System.Web %>
<%@ Import Namespace="System.Drawing" %>
<%@Import namespace= System.Drawing.Bitmap %>
<%@ Import Namespace="System.Configuration" %>
<%@ Import Namespace="System.Drawing.Imaging" %>
<%@Import namespace= System.Web.UI.WebControls.Image %>
<script runat="server">
    Dim con As SqlConnection
    Dim cmd As SqlCommand
    Dim dr As SqlDataReader
 
 </script>
 <%
 
     con = New SqlConnection(ConfigurationManager.ConnectionStrings("desktopConnectionString").ConnectionString.ToString())
     con.Open()
     Dim ret_img As String
     ret_img = "SELECT B.TITLE, B.IMAGEPATH FROM SESSION where  IMAGE_ID='" + Request.QueryString("imageid") + "' "
     ' ret_img = "select Image_Data from InterScope.GROSS_IMAGE_STORE where  IMAGE_ID='40' "
     cmd = New SqlCommand(ret_img, con)
     dr = cmd.ExecuteReader
    Dim imagedata As Byte()
    Dim bmp As Bitmap
    If dr.HasRows Then
        dr.Read()
        imagedata = dr.Item(0)
        ' Response.Buffer = True
        If imagedata.Length > 0 Then
            Dim srm As MemoryStream = New MemoryStream(imagedata, True)
            srm.Write(imagedata, 0, imagedata.Length)
 
            Try
 
                bmp = Bitmap.FromStream(srm)
                Dim g As Graphics = Graphics.FromImage(bmp)
                 ' Response.AddHeader("Content-Disposition", "attachment")
                 Response.ContentType = "image/JPEG"
                 bmp.Save(Response.OutputStream, ImageFormat.Jpeg)
 
                'Response.End()
            Catch ex As Exception
                '  Response.Write(ex.Message)
            End Try
 
            ' Cleanup
            'g.Dispose()
            'bmp.Dispose()
        End If
    End If
    %>