从SQL Server数据库提取图片并显示在DataGrid

最新推荐文章于 2021-01-19 08:59:43 发布

peter824

最新推荐文章于 2021-01-19 08:59:43 发布

阅读量481

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/peter824/article/details/2108641

下面的代码实现从SQL Server数据库提取图片并显示在DataGrid的功能。

下面就是完整的代码，拷贝即可运行：

DataGridShowImage.aspx

<%@ Page language="c#" debug="true" Codebehind="DataGridShowImage.aspx.cs" AutoEventWireup="false"

Inherits="eMeng.Exam.DataGridShowImage.DataGridShowImage" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

<title>从数据库中取得照片并显示在DataGrid中</title>

</HEAD>

<h3 align="center">从数据库中取得照片并显示在DataGrid中</h3>

<asp:DataGrid ID="DG_Persons" AutoGenerateColumns="False" Width="99%" HeaderStyle-BackColor="#ff0000"

HeaderStyle-Font-Bold="True" HeaderStyle-ForeColor="#ffffff" ItemStyle-BackColor="Beige"

BorderColor="#000000" Runat="server" HeaderStyle-HorizontalAlign="Center">

<asp:TemplateColumn HeaderText="姓名">

<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "PersonName") %>' ID="Label1"/>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="电子邮件">

<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "PersonEmail") %>' ID="Label2"/>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="性别">

<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "PersonSex") %>' ID="Label3"/>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="出生日期">

<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "PersonDOB") %>' ID="Label4"/>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="照片">

<asp:Image Runat=server ID="Image1"

ImageUrl='<%# FormatURL(DataBinder.Eval(Container.DataItem, "PersonID")) %>' />

</ItemTemplate>

</asp:TemplateColumn>

</Columns>

</asp:DataGrid>

</form>

</body>

</HTML>

DataGridShowImage.aspx.cs

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

namespace eMeng.Exam.DataGridShowImage

{

/// <summary>

/// DataGridShowImage 的摘要说明。

/// </summary>

public class DataGridShowImage : System.Web.UI.Page

{

protected System.Web.UI.WebControls.DataGrid DG_Persons;

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

if(!this.IsPostBack)

{

BindGrid();

}

private void BindGrid()

{

string strCnn = "Data Source=.;Initial Catalog=mxh;User Id=sa;Password=;";

SqlConnection myConnection = new SqlConnection(strCnn);

SqlCommand myCommand = new SqlCommand("SELECT * FROM Person", myConnection);

myCommand.CommandType = CommandType.Text;

try

{

myConnection.Open();

DG_Persons.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

DG_Persons.DataBind();

}

catch(SqlException SQLexc)

{

Response.Write("提取数据时出现错误：" + SQLexc.ToString());

}

protected string FormatURL(object strArgument)

{

return "ReadImage.aspx?id=" + strArgument.ToString();

}

Web Form Designer generated code

}

ReadImage.aspx

<%@ Page language="c#" Codebehind="ReadImage.aspx.cs" AutoEventWireup="false"

Inherits="eMeng.Exam.DataGridShowImage.ReadImage" %>

ReadImage.aspx.cs

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Data.SqlClient;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

namespace eMeng.Exam.DataGridShowImage

{

/// <summary>

/// ReadImage 的摘要说明。

/// </summary>

public class ReadImage : System.Web.UI.Page

{

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

string strImageID = Request.QueryString["id"];

SqlConnection myConnection = new SqlConnection("Data Source=.;Initial Catalog=mxh;User Id=sa;Password=;");

SqlCommand myCommand = new SqlCommand("Select PersonImageType, PersonImage from Person Where PersonID="

+ strImageID, myConnection);

try

{

myConnection.Open();

SqlDataReader myDataReader;

myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

if(myDataReader.Read())

{

Response.Clear();

Response.ContentType = myDataReader["PersonImageType"].ToString();

Response.BinaryWrite((byte[])myDataReader["PersonImage"]);

}

myConnection.Close();

}

catch (SqlException SQLexc)

{

}

Response.End();

}

Web Form Designer generated code

}