62,268
社区成员
发帖
与我相关
我的任务
分享asp.net与数据库读取图片问题？？？？
图片上传到数据库里，每次显示的时候只能显示一张图片，其他的图片看不到？怎样改才能看到所以图片啊？？
显示图片代码
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档 </title>
</head>
<body>
<asp:Label ID="Label1" runat="server" Text="Label"> </asp:Label>
<%@ OutputCache duration="30" varybyparam="imageid"%>
<%@ import namespace="system.data"%>
<%@ import namespace="system.data.sqlclient"%>
<script language="vb" runat="server">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim imageid As String = Request.QueryString("imageid")
Dim sqlcon As New SqlClient.SqlConnection("server=song;uid=sa;pwd=;database=xiaoshou")
'sql数据库
Dim sqlcmd As String
sqlcmd = "select image,contenttype,bytesizel from images "
Dim sqlcommand As New SqlClient.SqlCommand(sqlcmd.ToString, sqlcon)
sqlcon.Open()
Dim sqldr As SqlClient.SqlDataReader = sqlcommand.ExecuteReader(CommandBehavior.CloseConnection)
sqldr.Read()
Response.ContentType = sqldr("contenttype")
Response.OutputStream.Write(sqldr("image"), 0, sqldr("bytesizel"))
sqlcon.Close()
End Sub
</script>
</body>
</html>
显示图片代码
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档 </title>
</head>
<body>
<asp:Label ID="Label1" runat="server" Text="Label"> </asp:Label>
<%@ OutputCache duration="30" varybyparam="imageid"%>
<%@ import namespace="system.data"%>
<%@ import namespace="system.data.sqlclient"%>
<script language="vb" runat="server">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim imageid As String = Request.QueryString("imageid")
Dim sqlcon As New SqlClient.SqlConnection("server=song;uid=sa;pwd=;database=xiaoshou")
'sql数据库
Dim sqlcmd As String
sqlcmd = "select image,contenttype,bytesizel from images "
Dim sqlcommand As New SqlClient.SqlCommand(sqlcmd.ToString, sqlcon)
sqlcon.Open()
Dim sqldr As SqlClient.SqlDataReader = sqlcommand.ExecuteReader(CommandBehavior.CloseConnection)
sqldr.Read()
Response.ContentType = sqldr("contenttype")
Response.OutputStream.Write(sqldr("image"), 0, sqldr("bytesizel"))
sqlcon.Close()
End Sub
</script>
</body>
</html>
...全文
请发表友善的回复…
发表回复
gdstcqs 2009-04-05
- 打赏
- 举报
高手都去哪拉？？？
沉序员 2009-04-05
- 打赏
- 举报
up
chenxiaohai2 2009-04-05
- 打赏
- 举报
不好意思! 我是新手! 如何在<img>显示!
gdstcqs 2009-04-04
- 打赏
- 举报
没人回答。。。
