从数据库中读图片的程序只能读一张图片。数据库中有多张图片。同时字符串也不能显示。/// retriving.aspx<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="server" > Public Sub Page_Load(sender As Object, e As EventArgs)
' 建立Connection 对象
Dim conn As New SqlConnection("Server=localhost;Database=testdb;Uid=sa;Pwd=")
Dim myCommand As New SqlCommand("Select * from ImageStore", conn)
conn.Open()
Dim myDataReader as SqlDataReader
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Do While (myDataReader.Read())
Response.ContentType = myDataReader.Item("ImageContentType")
Response.BinaryWrite(myDataReader.Item("ImageData"))
Loop
conn.Close()
Response.Write("ImageStore info successfully retrieved!")
End Sub
</script>
<HTML>
<HEAD>
<title>Retrieving Image from the Sql Server</title>
</HEAD>
<body style="font: 10pt verdana">
</body>
</HTML>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="server" > Public Sub Page_Load(sender As Object, e As EventArgs)
' 建立Connection 对象
Dim conn As New SqlConnection("Server=localhost;Database=testdb;Uid=sa;Pwd=")
Dim myCommand As New SqlCommand("Select * from ImageStore", conn)
conn.Open()
Dim myDataReader as SqlDataReader
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Do While (myDataReader.Read())
Response.ContentType = myDataReader.Item("ImageContentType")
Response.BinaryWrite(myDataReader.Item("ImageData"))
Loop
conn.Close()
Response.Write("ImageStore info successfully retrieved!")
End Sub
</script>
<HTML>
<HEAD>
<title>Retrieving Image from the Sql Server</title>
</HEAD>
<body style="font: 10pt verdana">
</body>
</HTML>
<img src="OutputImage.aspx?id=2">
...然后在 OutputImage.aspx 这个程序中,得到 id,
查询数据库, 输出该 id 对应的图片内容。
image src=response.binarywrite(?)等等。多谢各位大侠。
使用inelm(木野狐)的方法吧,用另外一个页面从数据库中读取图片。