Вот мой контрол, которым я делаю это:
1.
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="SQL_Image.ascx.vb" Inherits="SQL_Image" %>
<asp:Image ID="Image1" runat="server" />
1.
2.
3.
4.
5.
Partial Class SQL_Image
Inherits System.Web.UI.UserControl
Public Sub Show(ByVal ConnectionStringsName As String, ByVal SelectStatement As String)
Image1.ImageUrl = "SQLImage.aspx?ConnectionStringsName=" & ConnectionStringsName & "&SelectStatement=" & SelectStatement
End Sub
End Class
Плюс вот такая страничка SQLImage.aspx к этому контролу:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="SQLImage.aspx.vb" Inherits="SQLImage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
</form>
</body>
</html>
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
Imports System.Data.SqlClient
Partial Class SQLImage
Inherits System.Web.UI.Page
Dim CN As SqlConnection, CMD As SqlCommand, DR As SqlDataReader
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
CN = New SqlConnection(ConfigurationManager.ConnectionStrings(Request.QueryString("ConnectionStringsName")).ConnectionString)
CN.Open()
CMD = New SqlCommand(Request.QueryString("SelectStatement"), CN)
DR = CMD.ExecuteReader
If DR.Read Then
Response.ContentType = "image/bmp"
Response.BinaryWrite(CType(DR( 0 ), Byte()))
End If
DR.Close()
CN.Close()
End Sub
End Class
Эх, может быть кому-нибудь будет не жалко помочь мне и в моих проблемах:
http://www.sql.ru/forum/actualthread.aspx?tid=261504
