asp.net 问题

Question

 OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\a336\App_Data\Images.mdb");
        OleDbCommand cmd = con.CreateCommand();
        //可能SQL需要个查询条件(Where   id=?),不过这里按上面的代码来写:)   
        cmd.CommandText = "Select   filename,filetype,filedata   From   [photo]";
        con.Open();
        OleDbDataReader dr = cmd.ExecuteReader();
        string filename;
        string filetype;
        byte[] filedata;        if (dr.HasRows)
        {
            if (dr.Read())
            {
                //filename = dr["filename"].ToString();
                //filetype = dr["filetype"].ToString();
                filedata = (byte[])dr["filedata"];
                //Response.ClearHeaders();
                //Response.ClearContent();
                //Response.ContentType = filetype;
                Response.AppendHeader("Content-Disposition", "inline;filename=" + HttpUtility.UrlEncode("filename"));
                Response.BinaryWrite(filedata);
                Response.Buffer = true;
                Response.End();
                           }
            else
            {
                Response.Write("数据库中没有该记录");
            }
        }
我这段代码怎么只能显示一个图片啊 我数据库中有3个 我想全部一次读出来怎么办啊 哪位高手帮帮忙

Answer 1

if (dr.Read()) 
=>while(dr.read())

Answer 2

这是.ashx吗？while(dr.Read())是对，不过最终读出来的肯定是最后一张图片。