62,046
社区成员
发帖
与我相关
我的任务
分享请教为什么gridview不能显示图片
代码如下：
在网页上放置一个gridview控件，自定义Items中使用Imagefield属性，数据库字段是Image类型数据
页面代码如下：
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="id" />
<asp:BoundField DataField="IMGTITLE" />
<asp:BoundField DataField="IMGTYPE" />
<asp:ImageField DataImageUrlField="IMGDATA" HeaderText="4">
</asp:ImageField>
</Columns>
</asp:GridView>
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>
</form>
</body>
程序代码如下：
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 _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string imgid = Request.QueryString["imgid"];
string connstr = System.Configuration.ConfigurationManager.AppSettings["conString"];
string sql = "SELECT imgdata, imgtype FROM pic ";
SqlConnection connection = new SqlConnection(connstr);
SqlCommand command = new SqlCommand(sql, connection);
connection.Open();
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
//Response.ContentType = dr["imgtype"].ToString();
//Response.BinaryWrite((byte[])dr["imgdata"]);
}
connection.Close();
string connstring = System.Configuration.ConfigurationManager.AppSettings["conString"];
SqlDataSource1.ConnectionString = connstring;
SqlDataSource1.SelectCommand = "select * from pic ";
}
}
最好提供vb的源代码
还有如何显示Image类型数据在table中
在网页上放置一个gridview控件，自定义Items中使用Imagefield属性，数据库字段是Image类型数据
页面代码如下：
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="id" />
<asp:BoundField DataField="IMGTITLE" />
<asp:BoundField DataField="IMGTYPE" />
<asp:ImageField DataImageUrlField="IMGDATA" HeaderText="4">
</asp:ImageField>
</Columns>
</asp:GridView>
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>
</form>
</body>
程序代码如下：
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 _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string imgid = Request.QueryString["imgid"];
string connstr = System.Configuration.ConfigurationManager.AppSettings["conString"];
string sql = "SELECT imgdata, imgtype FROM pic ";
SqlConnection connection = new SqlConnection(connstr);
SqlCommand command = new SqlCommand(sql, connection);
connection.Open();
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
//Response.ContentType = dr["imgtype"].ToString();
//Response.BinaryWrite((byte[])dr["imgdata"]);
}
connection.Close();
string connstring = System.Configuration.ConfigurationManager.AppSettings["conString"];
SqlDataSource1.ConnectionString = connstring;
SqlDataSource1.SelectCommand = "select * from pic ";
}
}
最好提供vb的源代码
还有如何显示Image类型数据在table中
...全文
请发表友善的回复…
发表回复
zerocoin 2006-04-24
- 打赏
- 举报
在Web中GridView是不会直接显示IMAGE的数据的,所以你要自行转换一下.
Image显示table中的方法也同上,
Image显示table中的方法也同上,
zhangxiaopin 2006-04-24
- 打赏
- 举报
<asp:ImageField DataImageUrlFieldIMGDATA" HeaderText="4" dataimageformatstring="../uploadfiles/userheadimgage/{0}">
</asp:ImageField>
</asp:ImageField>
antiking 2006-04-24
- 打赏
- 举报
最好不要这么做.最好用路径.读数据库显示图片的话你还要做个显示页面把页面.
yixi8899 2006-04-24
- 打赏
- 举报
请写详细一些我不太明白，谢谢！
