我想做一个 gridview上显示图片,图片是SQL SERVER数据库中读取的! 求一个列子!谢谢
解决方案 »
- <asp web>运行项目提示成功,但只列出项目清单
- 一键发送邮件问题
- 类的变量初始化不能是复杂表达式,为什么,是规定吗??
- 如何获得文本框中选中的文本
- 重载“GetType”方法未获取“1”参数,帮我看看错在哪里?
- Server Error in '/' Application.
- 正则表达式的问题?
- 我想把*.cs的文件编译成dll的动态链接库,请问我该如何做呢?
- 通过firebug我看到有些控件生成的webresource.axd会过期的时间限制(Expires),这样控件的js,css,gif等资源文件,在未过期前不会重复下载,但有的控件生成的webresource.axd就没有Expires,请问该如何加上?
- TryParse函数
- public变量为何在!ispostback赋值后,在其他方法中又变为无值了.
- GridView怎么设置分页
在GV 中要显示的列放一个image
然后 this.Image1.ImageUrl="从数据库取出的相对路径";
在GV 中要显示的列放一个image
然后 this.Image1.ImageUrl="从数据库取出的相对路径";
<asp:TemplateField HeaderText="图片">
<ItemTemplate>
<asp:Image ID="Image2" runat="server" ImageUrl="~/image/1.jpg" />
</ItemTemplate>
</asp:TemplateField>
把~/image/1.jpg改成你数据库读出来的相对路径就OK了
<ItemTemplate>
<FONT face="宋体">
<TABLE cellSpacing="0"cellPadding="0"border="0"> <TR> <TD><IMG alt=产品照片 src='<%# Eval("ImagePath") %>' ></A></TD>
</TR>
</TABLE>
</FONT>
</ItemTemplate>
</asp:datalist>
<%# Eval("ImagePath") %>数据库读出的路径
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="imagestore.aspx.cs" Inherits="imagestore_imagestore" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div style="margin-top:100px; text-align:center">
<asp:Image ID="Image1" Width="90px" Height="120px" runat="server" />
<br />
<asp:FileUpload ID="FileUpload1" runat="server" /><br /><asp:Button ID="Button1" runat="server"
Text="上传文件" OnClick="Button1_Click" />
</div>
<br />
<div style="margin-top:150px; text-align:center">
<asp:Button ID="Button2" runat="server" Text="显示图片" OnClick="Button2_Click" />
<br />
<table>
<tr>
<td>
<asp:Image ID="imgshow" runat="server" />
<asp:ImageMap ID="ImageMap1" runat="server">
</asp:ImageMap></td>
</tr>
</table>
</div>
</form>
</body>
</html>imagestore.aspx.cs页面using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;
using System.Drawing;
using System.Drawing.Imaging;
public partial class imagestore_imagestore : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection( ConfigurationManager.ConnectionStrings["test"].ConnectionString);
con.Open();
SqlDataAdapter ap = new SqlDataAdapter("select * from image where 1=0", con);
new SqlCommandBuilder(ap);
DataTable dt = new DataTable();
ap.Fill(dt); string filename = FileUpload1.PostedFile.FileName;
Image1.ImageUrl = filename;
filename = filename.Substring(filename.LastIndexOf('.') + 1);
byte[] img = new byte[FileUpload1.PostedFile.ContentLength];
FileUpload1.PostedFile.InputStream.Read(img, 0, FileUpload1.PostedFile.ContentLength);
DataRow dr = dt.NewRow();
dr["pic"] = (byte[])img;
dr["pictype"] = filename;
dr["piclen"] = FileUpload1.PostedFile.ContentLength;
dt.Rows.Add(dr);
ap.Update(dt);
con.Close();
}
protected void Button2_Click(object sender, EventArgs e)
{
imgshow.ImageUrl = "./Default.aspx";
}
}从数据库读取图片的页面 Default.aspx的cs页面,Default.aspx页面是空的
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;public partial class imagestore_Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["test"].ConnectionString);
con.Open();
SqlDataAdapter ap = new SqlDataAdapter("select top 1 * from image order by id desc", con);
DataTable dt = new DataTable();
ap.Fill(dt);
string pictype = dt.Rows[0]["pictype"].ToString();
byte[] arry = (byte[])dt.Rows[0]["pic"];
Response.Buffer = false;
Response.ContentType = pictype;
Response.BinaryWrite(arry);
}
}
}