asp.net 显示ACCESS数据库二进制图片

[xiaoaogong9]

在index.aspx页中datalist控件中显示图片.
图片以二进制形式存储在access数据库中.
应该怎样写?

[wzwen]

关注一下……

[xiaoaogong9]

有没有帮帮我啊?初学者的痛苦啊!

[xiaoaogong9]

帮帮忙啊?初学者的辛酸史啊!

[fei997yang]

图片src指向单独的页面，这个页面根据参数输出图片

[xiaoaogong9]

不显示啊

[xiaoaogong9]

这是第一个页面的前台代码
<asp:datalist id="MyList" repeatcolumns="2" borderwidth="0" runat="server" Height="91px" Width="621px">
<ItemTemplate>
<table>
<tr>
<td>
<img width="40" height="40" src='<%# DataBinder.Eval(Container.DataItem, "pID", "Img.aspx?id={0}")%>'/>
</td>
</tr>
</table>
</ItemTemplate>
</asp:datalist>
后台
OleDbConnection objConn = new OleDbConnection();
objConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\2005ms\\shiyan\\house\\house\\fyfile\\fyasp.mdb";
objConn.Open();
OleDbCommand objCmd = new OleDbCommand("select * from FileLibrary", objConn);
OleDbDataAdapter da = new OleDbDataAdapter(objCmd);
DataSet ds = new DataSet();
da.Fill(ds, "aa");
MyList.DataSource = ds.Tables["aa"];
MyList.DataBind();
objConn.Close();
img.aspx的后台代码
int id = int.Parse(Request["id"].ToString());
OleDbConnection objConn = new OleDbConnection();
objConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\2005ms\\shiyan\\house\\house\\fyfile\\fyasp.mdb";

objConn.Open();

OleDbCommand objCmd = new OleDbCommand("select pid,ContentType,Data from FileLibrary where pID==@id order by pID desc", objConn);
objCmd.Parameters.Add("@id", OleDbType.Integer);
objCmd.Parameters["@id"].Value = id;
OleDbDataReader objDr = objCmd.ExecuteReader();

while (objDr.Read())
{
Response.BinaryWrite((byte[])objDr["Data"]);
}

objDr.Close();
objConn.Close();
这样不显示啊不知道怎么回事

[编程有钱人了]

/*图片二进制读取于存储到数据库
这里用的是MYSQL数据库的BLOB字段存储的图片二进制数据
由于用的是MYSQL数据库 所以在引用存储的方法与MSSQL数据库不一样，
MYSQL用的是“？”，而MSSQL数据库是“@”,请大家注意参考
只要把MySql开头换成sql就行*/
using System;
using System.Data;
using System.Configuration;
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.Imaging;
using MySql.Data.MySqlClient;//引用MYSQL命名空间
public partial class _Default : System.Web.UI.Page 
{
      MySqlConnection conn = new MySqlConnection(System.Configuration.ConfigurationManager.AppSettings["conmy"]);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.Page.IsPostBack) 
        {
            this.show();
        }
    }
    
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (FileUpload1.HasFile)
        {
            //文件扩展名
            string Ex=FileUpload1.FileName.Substring(FileUpload1.FileName.LastIndexOf('.') + 1);
            if (Ex.ToLower() == "jpg" || Ex.ToLower() == "gif")
            {
                int ImageSize = FileUpload1.PostedFile.ContentLength;//图片的大小
                string ImageType = this.FileUpload1.PostedFile.ContentType;//图片类型
                Stream ImageStream = this.FileUpload1.PostedFile.InputStream;
                Byte[] ImageCount = new Byte[ImageSize];//调用方法转化二进制数据
                int bt = ImageStream.Read(ImageCount, 0, ImageSize);
          
                MySqlCommand comm = new MySqlCommand("testpic",conn);
                comm.CommandType = CommandType.StoredProcedure;
                MySqlParameter pj = new MySqlParameter("?myimage", MySqlDbType.LongBlob,ImageCount.Length);//图片
                pj.Value =ImageCount;//给这字段赋值二进制数据
                comm.Parameters.Add(pj);
                MySqlParameter pname = new MySqlParameter("?imagename", MySqlDbType.VarChar, 100);//图片名称
                pname.Value=FileUpload1.FileName;
                comm.Parameters.Add(pname);
                MySqlParameter psize = new MySqlParameter("?imagesize", MySqlDbType.Int32);//图片名称
                psize.Value =ImageSize;
                comm.Parameters.Add(psize);
                conn.Open();
                comm.ExecuteNonQuery();
                conn.Close(); 
      
              this.Label1.Text="插入成功!";
              this.show();        
              
            }
            else
            {
                this.Label1.Text = "格式不正确！！！";
            }
            }
        else
        {
            this.Label1.Text = "没有文件！！！";
        }
    }
    private byte[] ImageToByte(string path)//声名一个把图片转化到二进制数据的方法
    {
        FileStream buffer = new FileStream(path, FileMode.Open, FileAccess.Read);
        BinaryReader br = new BinaryReader(buffer);
        byte[] image = br.ReadBytes((int)buffer.Length);
        return image;
    }
    private void show() 
    {
        MySqlDataAdapter da = new MySqlDataAdapter("select * from imgpic", conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "a");
        this.GridView1.DataSource = ds.Tables["a"].DefaultView;
        this.GridView1.DataKeyNames = new string[] { "id" };
        this.GridView1.DataBind();
    }
      protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {
        string sid = this.GridView1.DataKeys[e.NewSelectedIndex].Value.ToString();
        Session["id"] = sid;
        this.Label1.Text = sid;
        this.Image1.ImageUrl = "jpg2.aspx";
    }
}
//读取图片
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Drawing;
using System.Drawing.Imaging;
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.IO;
using System.Data.SqlClient;
using MySql.Data.MySqlClient;
public partial class Default2 : System.Web.UI.Page
{
    MySqlConnection conn = new MySqlConnection(System.Configuration.ConfigurationManager.AppSettings["conmy"]);
    protected void Page_Load(object sender, EventArgs e)
    {
      
        if (!this.Page.IsPostBack) 
        {
            this.show();  
        }
    }
    public void show() 
    {
        
            string ss = Request.QueryString["id"].ToString();
            string s3 = "select * from imgpic  where id=" + ss;
            MySqlCommand comm = new MySqlCommand(s3, conn);
            conn.Open();
            MySqlDataReader dr = comm.ExecuteReader(CommandBehavior.CloseConnection);
            while(dr.Read())
            {
                Response.Clear();
                Response.C;
                Response.BinaryWrite((byte[])dr["myimg"]);//读取
            }
            Response.End();
            conn.Close();
    }
}
//注意图片显示要在另一张页面中
//在你要显示的页面添加img 控件src="显示你图片的页面"; 

[bradring]

先写图片输入的接口，再在handler中写一个图片读的过程，最好用request.queryingstring,在页面中的img href写入相应的字串就可以了