DataGrid中，读取数据库中的图片并绑定数据列或磁盘目录中的图片，用输出流方式...

最新推荐文章于 2024-07-20 20:04:43 发布

weixin_30765475

最新推荐文章于 2024-07-20 20:04:43 发布

阅读量50

点赞数

文章标签：数据库 ui c#

原文链接：http://www.cnblogs.com/Dragon-China/archive/2006/12/20/598289.html

版权

显示效果如下

SID	图片显示
180
181
182
183
184
1

图片显示页面Html：DataGridShowPicture.aspx

<%@ Page language="c#" Codebehind="DataGridShowPicture.aspx.cs" AutoEventWireup="false" Inherits="_0921test.DataGridShowPicture" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <title>DataGridShowPicture</title>
        <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
        <meta content="C#" name="CODE_LANGUAGE">
        <meta content="JavaScript" name="vs_defaultClientScript">
        <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
    </HEAD>
    <body MS_POSITIONING="GridLayout">
        <form id="DataGridShowImage" method="post" runat="server">
            <table style="Z-INDEX: 101; LEFT: 400px; POSITION: absolute; TOP: 72px" align="center">
                <tr>
                    <td align="center">
                        <asp:datagrid id="dgShowPicture" HeaderStyle-HorizontalAlign="Center" Runat="server" BorderColor="#3366CC"
                            ItemStyle-BackColor="Beige" HeaderStyle-ForeColor="#ffffff" HeaderStyle-Font-Bold="True" HeaderStyle-BackColor="#ff0000"
                            Width="160px" AutoGenerateColumns="False" BorderStyle="None" BorderWidth="1px" BackColor="White"
                            CellPadding="4" PageSize="5" AllowPaging="True" AllowCustomPaging="True">
                            <FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle>
                            <SelectedItemStyle Font-Bold="True" ForeColor="#CCFF99" BackColor="#009999"></SelectedItemStyle>
                            <ItemStyle ForeColor="#003399" BackColor="White"></ItemStyle>
                            <HeaderStyle Font-Bold="True" HorizontalAlign="Center" ForeColor="#CCCCFF" BackColor="#003399"></HeaderStyle>
                            <Columns>
                                <asp:TemplateColumn HeaderText="SID">
                                    <ItemTemplate>
                                        <asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "PID") %>' ID="Label1"/>
                                    </ItemTemplate>
                                </asp:TemplateColumn>
                                <asp:TemplateColumn HeaderText="图片显示">
                                    <ItemTemplate>
                                        <asp:Image Runat=server ID="Image1" Height =50 Width=50 ImageUrl='<%# FormatURL(DataBinder.Eval(Container.DataItem, "Mulname")) %>'/>
                                    </ItemTemplate>
                                </asp:TemplateColumn>
                            </Columns>
                            <PagerStyle VerticalAlign="Middle" Font-Bold="True" HorizontalAlign="Center" ForeColor="#003399"
                                BackColor="#99CCCC" Mode="NumericPages"></PagerStyle>
                        </asp:datagrid>
                    </td>
                </tr>
            </table>
        </form>
    </body>
</HTML>

图片显示页面ＣＳ：DataGridShowPicture.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 _0921test
{
    /**//// <summary>
    /// DataGridShowPicture 的摘要说明。
    /// </summary>
    public class DataGridShowPicture : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.DataGrid dgShowPicture;


        private void Page_Load(object sender, System.EventArgs e)
        {
            // 在此处放置用户代码以初始化页面
            if(!this.IsPostBack)
            {
                BindGrid();
            }
        }

        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /**//// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        private void BindGrid()
        {
            string connectionString = "workstation id=WANGSZ;packet size=4096;integrated security=SSPI;data source=WANGSZ;persist security info=False;initial catalog=nature";

            string sqlstr = "SELECT PID,Mulname FROM Picture where PID like '%18%'";
            try
            {
                using (SqlConnection connection = new SqlConnection(connectionString))
                {
                    DataSet ds = new DataSet();
                    try
                    {
                        connection.Open();
                        SqlDataAdapter Dta= new SqlDataAdapter(sqlstr,connection);
                        Dta.Fill(ds,"ds");
                        Dta.Dispose();
                        dgShowPicture.DataSource = ds;
                        this.dgShowPicture.VirtualItemCount=5;
                        dgShowPicture.DataBind();
                    }
                    catch(System.Data.SqlClient.SqlException ex)
                    {
                        throw new Exception(ex.Message);
                    }
                }
            }
            catch(SqlException SQLexc)
            {
                Response.Write("提取数据时出现错误：" + SQLexc.ToString());
            }
        }

        protected string FormatURL(object strArgument)
        {
            return "DataGridReadImage.aspx?PID=" + strArgument.ToString();
        }

    }

}

图片读取页面ＨＴＭＬ: DataGridReadImage.aspx

<%@ Page language="c#" Codebehind="DataGridReadImage.aspx.cs" AutoEventWireup="false" Inherits="_0921test.DataGridReadImage" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <title>DataGridReadImage</title>
        <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
        <meta name="CODE_LANGUAGE" Content="C#">
        <meta name="vs_defaultClientScript" content="JavaScript">
        <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
    </HEAD>
    <body MS_POSITIONING="GridLayout">
        <form id="Form1" method="post" runat="server">
            <FONT face="宋体"></FONT>
        </form>
    </body>
</HTML>

图片读取页面ＣＳ: DataGridReadImage.aspx

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;

using System.IO;

namespace _0921test

{

/**//// <summary>

/// DataGridReadImage 的摘要说明。

/// </summary>

public class DataGridReadImage : System.Web.UI.Page

{

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

{

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

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

SqlConnection myConnection = new SqlConnection("workstation id=WANGSZ;packet size=4096;integrated security=SSPI;data source=WANGSZ;persist security info=False;initial catalog=nature");

//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"]);

// }