use multiple <img src="displayimage.aspx?id=1"> <img src="displayimage.aspx?id=2"> ...in displayimage.aspx, use id to get the right image out and use Response.BinaryWrite(), see http://www.dotnetbips.com/displayarticle.aspx?id=60Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET http://aspalliance.com/das/datagridimages.aspx
给一个显示图片的例程给你:Public Class imgshow Inherits System.Web.UI.Page#Region " Web 窗体设计器生成的代码 " '该调用是 Web 窗体设计器所必需的。 <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() End Sub Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init 'CODEGEN: 此方法调用是 Web 窗体设计器所必需的 '不要使用代码编辑器修改它。 InitializeComponent() End Sub#End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load '在此处放置初始化页的用户代码 Dim StrConn As String Dim SqlCmd As String Dim MyConn As New SqlClient.SqlConnection() Dim MyComm As New SqlClient.SqlCommand() Dim MyReader As SqlClient.SqlDataReader Dim StrTid As String StrTid = Trim(Request.Params("xsdm")) StrConn = '数据库连接串 MyConn = New SqlClient.SqlConnection(StrConn) MyConn.Open() SqlCmd = "SELECT IMG, IMGTYPE, IMGSIZE FROM images where id=" & StrTid MyComm = New SqlClient.SqlCommand(SqlCmd, MyConn) MyReader = MyComm.ExecuteReader() MyReader.Read() Response.ContentType = MyReader.Item("imgtype") '设定输出文件类型 '输出图象文件二进制数制 Response.OutputStream.Write(MyReader.Item("img"), 0, MyReader.Item("imgsize")) MyConn.Close() Response.End() End SubEnd Class 表结构如下:TABLENAME: IMAGESID INT '图片ID IMG IMAGE '图片数据 IMGTYPE VARCHAR(255) '图片类形 IMGSIZE INT '图片大小
当我在asp.net页面显示数据库的图片时竟然出现一个下载对话框,真是不解啊
<img src="displayimage.aspx?id=1">
<img src="displayimage.aspx?id=2">
...in displayimage.aspx, use id to get the right image out and use Response.BinaryWrite(), see
http://www.dotnetbips.com/displayarticle.aspx?id=60Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET
http://aspalliance.com/das/datagridimages.aspx
Inherits System.Web.UI.Page#Region " Web 窗体设计器生成的代码 " '该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() End Sub Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub#End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
Dim StrConn As String
Dim SqlCmd As String
Dim MyConn As New SqlClient.SqlConnection()
Dim MyComm As New SqlClient.SqlCommand()
Dim MyReader As SqlClient.SqlDataReader
Dim StrTid As String
StrTid = Trim(Request.Params("xsdm"))
StrConn = '数据库连接串
MyConn = New SqlClient.SqlConnection(StrConn)
MyConn.Open()
SqlCmd = "SELECT IMG, IMGTYPE, IMGSIZE FROM images where id=" & StrTid
MyComm = New SqlClient.SqlCommand(SqlCmd, MyConn)
MyReader = MyComm.ExecuteReader()
MyReader.Read()
Response.ContentType = MyReader.Item("imgtype") '设定输出文件类型
'输出图象文件二进制数制
Response.OutputStream.Write(MyReader.Item("img"), 0, MyReader.Item("imgsize"))
MyConn.Close()
Response.End()
End SubEnd Class
表结构如下:TABLENAME: IMAGESID INT '图片ID
IMG IMAGE '图片数据
IMGTYPE VARCHAR(255) '图片类形
IMGSIZE INT '图片大小
只要抓住一点:<img src='imgview.aspx?imgid='+yourimgID>
即可.其它由imgview文件根据imgid在取得图片字段数据后.response.binarywrite(dr.item("imgdata"))即可.