GridView显示数据库图片

最新推荐文章于 2015-11-17 16:42:00 发布
最新推荐文章于 2015-11-17 16:42:00 发布
阅读量884 收藏 1
点赞数
文章标签： 数据库 asp button image server dataset

示：

前台代码：view plaincopy to clipboardprint?
<div>  
           <table cellpadding="0" cellspacing="0" border="0" width="80%" style="font-size: 11px" mce_style="font-size: 11px">  
               <tr>  
                   <td align="center">  
                       <asp:GridView ID="GridView1" runat="server" AllowPaging="true" PageSize="3" AllowSorting="True" 
                           AutoGenerateColumns="False" HeaderStyle-VerticalAlign="Middle" CellPadding="3" 
                           Font-Size="9pt" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" 
                           Height="221px" Width="100%">  
                           <Columns>  
                             <asp:BoundField DataField="ImageID" HeaderText="编号" />  
                               <asp:BoundField DataField="ImageName" HeaderText="用户名称" />  
                               <asp:TemplateField HeaderText="头像">                                 
                                   <ItemTemplate>  
                                       <asp:Image ID="Image1" Height="80" Width="100"  runat="server" ImageUrl='<%# "ImageHandler.ashx?ImID="+ Eval("ImageID")  %>' />  
                                   </ItemTemplate>  
                               </asp:TemplateField>  
                           </Columns>  
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />  
                           <EditRowStyle BackColor="#999999" />  
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />  
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />  
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />  
                           <PagerSettings Visible="False" />  
                           <FooterStyle Font-Bold="True" />  
                           <HeaderStyle Font-Bold="False" Font-Italic="False" />  
                       </asp:GridView>  
                   </td>  
               </tr>  
               <tr>  
                   <td>  
                       <asp:Button ID="Button1" runat="server" Text="上传图片" OnClick="Button1_Click" />  
                   </td>  
               </tr>  
           </table>  
           <asp:Panel ID="Panel2" runat="server" BorderStyle="Solid" BorderWidth="1px" BackColor="White"  Width="80px" Height="50px" 
              Style="z-index: 101; left: 56px; position: absolute; top: 90px" mce_Style="z-index: 101; left: 56px; position: absolute; top: 90px">  
               <table>  
                   <tr>  
                       <td style="width: 150px" colspan="2">  
                           <asp:FileUpload ID="FU_image" runat="server" />  
                       </td>  
                   </tr>  
                   <tr>  
                       <td style="width: 70px">  
                           图片名称:</td>  
                       <td>  
                           <asp:TextBox ID="T_image" runat="server"></asp:TextBox></td>  
                   </tr>  
                   <tr>  
                       <td style="width: 70px">  
                       </td>  
                       <td style="width: 115px">  
                           <asp:Button ID="Bt_Save" runat="server" Text="保存" OnClick="Bt_Save_Click" />  
                           <asp:Button ID="Bt_Cacel" runat="server" Text="取消" OnClick="Bt_Cacel_Click" /></td>  
                   </tr>  
               </table>  
           </asp:Panel>  
       </div> 
 <div>
            <table cellpadding="0" cellspacing="0" border="0" width="80%" style="font-size: 11px" mce_style="font-size: 11px">
                <tr>
                    <td align="center">
                        <asp:GridView ID="GridView1" runat="server" AllowPaging="true" PageSize="3" AllowSorting="True"
                            AutoGenerateColumns="False" HeaderStyle-VerticalAlign="Middle" CellPadding="3"
                            Font-Size="9pt" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"
                            Height="221px" Width="100%">
                            <Columns>
                              <asp:BoundField DataField="ImageID" HeaderText="编号" />
                                <asp:BoundField DataField="ImageName" HeaderText="用户名称" />
                                <asp:TemplateField HeaderText="头像">                              
                                    <ItemTemplate>
                                        <asp:Image ID="Image1" Height="80" Width="100"  runat="server" ImageUrl='<%# "ImageHandler.ashx?ImID="+ Eval("ImageID")  %>' />
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                            <EditRowStyle BackColor="#999999" />
                            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                            <PagerSettings Visible="False" />
                            <FooterStyle Font-Bold="True" />
                            <HeaderStyle Font-Bold="False" Font-Italic="False" />
                        </asp:GridView>
                    </td>
                </tr>
                <tr>
                    <td>
                        <asp:Button ID="Button1" runat="server" Text="上传图片" OnClick="Button1_Click" />
                    </td>
                </tr>
            </table>
            <asp:Panel ID="Panel2" runat="server" BorderStyle="Solid" BorderWidth="1px" BackColor="White"  Width="80px" Height="50px"
               Style="z-index: 101; left: 56px; position: absolute; top: 90px" mce_Style="z-index: 101; left: 56px; position: absolute; top: 90px">
                <table>
                    <tr>
                        <td style="width: 150px" colspan="2">
                            <asp:FileUpload ID="FU_image" runat="server" />
                        </td>
                    </tr>
                    <tr>
                        <td style="width: 70px">
                            图片名称:</td>
                        <td>
                            <asp:TextBox ID="T_image" runat="server"></asp:TextBox></td>
                    </tr>
                    <tr>
                        <td style="width: 70px">
                        </td>
                        <td style="width: 115px">
                            <asp:Button ID="Bt_Save" runat="server" Text="保存" OnClick="Bt_Save_Click" />
                            <asp:Button ID="Bt_Cacel" runat="server" Text="取消" OnClick="Bt_Cacel_Click" /></td>
                    </tr>
                </table>
            </asp:Panel>
        </div>

后台代码：view plaincopy to clipboardprint?
SqlConnection sqlcon;  
    string strCon = "Data Source=(local);Database=wxd;Uid=sa;Pwd=sa";  
    protected void Page_Load(object sender, EventArgs e)  
    {  
        if (!IsPostBack)  
        {  
            this.Panel2.Visible = false;  
            bind();  
        }  
    }  
    //绑定GridView  
    public void bind()  
    {  
        string sqlstr = "select  [ImageName],[ImageID] from [Image]";  
        sqlcon = new SqlConnection(strCon);  
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);  
        DataSet myds = new DataSet();  
        sqlcon.Open();  
        myda.Fill(myds, "Admin");  
        GridView1.DataSource = myds;  
        GridView1.DataBind();  
    }  
    protected void Bt_Cacel_Click(object sender, EventArgs e)  
    {  
        this.Panel2.Visible = false;  
    }  
    //保存图片  
    protected void Bt_Save_Click(object sender, EventArgs e)  
    {          
        Stream imgStream=FU_image.PostedFile.InputStream;  
        int imgLen=FU_image.PostedFile.ContentLength;  
        string imgName=this.T_image.Text;  
        byte[] imgBinaryData=new byte[imgLen];  
        int n=imgStream.Read(imgBinaryData,0,imgLen);  
      
     SqlConnection connection = new SqlConnection("Data Source=(local);Database=wxd;Uid=sa;Pwd=sa");  
     SqlCommand command = new SqlCommand("insert into Image (ImageName,Image) values ( @img_name, @img_data)", connection);  
   
     SqlParameter param0 = new SqlParameter("@img_name", SqlDbType.VarChar, 50);  
     param0.Value = imgName;  
     command.Parameters.Add(param0);  
   
     SqlParameter param1 = new SqlParameter("@img_data", SqlDbType.Image);  
     param1.Value = imgBinaryData;  
     command.Parameters.Add(param1);  
   
     connection.Open();  
     int numRowsAffected = command.ExecuteNonQuery();  
     connection.Close();  
     this.Panel2.Visible = false;  
     this.T_image.Text = "";  
     bind();  
    }  
    //显示保存  
    protected void Button1_Click(object sender, EventArgs e)  
    {  
        this.Panel2.Visible = true;  
    } 
SqlConnection sqlcon;
    string strCon = "Data Source=(local);Database=wxd;Uid=sa;Pwd=sa";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.Panel2.Visible = false;
            bind();
        }
    }
    //绑定GridView
    public void bind()
    {
        string sqlstr = "select  [ImageName],[ImageID] from [Image]";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "Admin");
        GridView1.DataSource = myds;
        GridView1.DataBind();
    }
    protected void Bt_Cacel_Click(object sender, EventArgs e)
    {
        this.Panel2.Visible = false;
    }
    //保存图片
    protected void Bt_Save_Click(object sender, EventArgs e)
    {       
        Stream imgStream=FU_image.PostedFile.InputStream;
        int imgLen=FU_image.PostedFile.ContentLength;
        string imgName=this.T_image.Text;
        byte[] imgBinaryData=new byte[imgLen];
        int n=imgStream.Read(imgBinaryData,0,imgLen);
   
     SqlConnection connection = new SqlConnection("Data Source=(local);Database=wxd;Uid=sa;Pwd=sa");
     SqlCommand command = new SqlCommand("insert into Image (ImageName,Image) values ( @img_name, @img_data)", connection);
 
     SqlParameter param0 = new SqlParameter("@img_name", SqlDbType.VarChar, 50);
     param0.Value = imgName;
     command.Parameters.Add(param0);
 
     SqlParameter param1 = new SqlParameter("@img_data", SqlDbType.Image);
     param1.Value = imgBinaryData;
     command.Parameters.Add(param1);
 
     connection.Open();
     int numRowsAffected = command.ExecuteNonQuery();
     connection.Close();
     this.Panel2.Visible = false;
     this.T_image.Text = "";
     bind();
    }
    //显示保存
    protected void Button1_Click(object sender, EventArgs e)
    {
        this.Panel2.Visible = true;
    }

 

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/wxd_860825/archive/2009/09/24/4589164.aspx

wyj2010shenghuo
关注
GridView中显示数据库里的图片
04-11 1300
很多人开始有这个疑问，GridView控件中的ImageField没有DataField属性，那么如何才能绑定到SQL Server中的Image Field？自从DynamicImage控件从beta2中消失后，这就成了个问题。但是，ASP.NET2.0随之也给我们带来了另外一种解决方案，那就是方便地利用HttpHandler(.ashx)动态显示数据库中的图片，这点在VS2005中提供了P
关于GridView中显示Image图片列的方法及示例
09-25
关于GridView中显示Image图片列的方法及示例
[Android] 通过GridView仿微信动态添加本地图片
weixin_34167819的博客
11-17 548
原文：http://blog.csdn.net/eastmount/article/details/41808179     前面文章讲述的都是"随手拍"中图像处理的操作,此篇文章主要讲述GridView控件实现添加本地图片并显示.主要是关于GridView控件的基本操作,通常可以通过自定义继承BaseAdapter的适配器加载图片,而下面讲述的不是自定义的适配器,而是调用SimpleAda...
GridView显示数据库图片与加入图片代码
imsong52的专栏
04-04 1519
 处理程序代码@ WebHandler Language="C#" Class="GetImg" %>using System;using System.Web;using System.Data;using System.Data.SqlClient;using System.Drawing;using System.Drawing.Imaging;using System.IO;usi
使用Gridview绑定数据库中的图片
05-14
为了能够在Gridview中显示数据库中的图片，首先需要将图片数据存储到数据库中。这可以通过以下步骤实现： 1. **创建数据库表**：在数据库中创建一个表（例如命名为`Image`），包含至少三个字段： - `ImageID` ...
gridview 显示图片的实例代码
01-20
5. **GridView显示读出的二进制图片** 如果不使用URL方式，你可以在RowDataBound事件中动态设置Image控件的`ImageUrl`，或者直接在模板列中将二进制数据写入响应流。这通常涉及到更多的代码，因为需要在事件处理...
GridView绑定数据库显示数据库当中的图片
最新发布
07-09
要在GridView中绑定数据库并显示数据库中的图片，你按照以下步骤进行操作： 1. 在GridView中添加一个模板列TemplateField），用于显示图片。 2. 在模板列中添加一个Image控件，用于显示图片。 3. 在GridView的...
将图片保存到数据库并用GridView显示
寻找被遗忘的记忆
08-30 619
            int len = Upload.PostedFile.ContentLength;            byte[] pic = new byte[len];            Upload.PostedFile.InputStream.Read(pic, 0, len);// 插入图片和说明到数据库中ashx读取上传至数据库中的图片public class GetImage : IHttpHandler {     public bool IsReusable{      
GridView自制数据源并显示图片
Ming.Blog.
10-21 811
1:GridView不仅能绑定数据库而且我们自己也可以写DataTable数据源:    protected void Page_Load(object sender, EventArgs e)    ...{        bind();    }    protected void bind()    ...{        DataTable dt = new DataTable()
数据库中图片的二进制存储和显示
weixin_30825581的博客
05-02 295
与图片的二进制数据库存储和显示 1.将图片以二进制存入数据库 2.读取二进制图片在页面显示 3.设置Image控件显示从数据库中读出的二进制图片 4.GridView中ImageField以URL方式显示图片 5.GridView显示读出的二进制图片 ==================== 1.将图片以二进制存入数据库 //保存图片到数据库 protected vo...
使用GridView显示数据库中二进制存储的图片教程
5. **GridView显示读出的二进制图片** 要在GridView中直接显示二进制图片，需要在GridView的ItemTemplate中添加一个Image控件，然后在RowDataBound事件中动态设置Image控件的`ImageUrl`属性。这通常涉及到获取当前...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值