public static Model.Resource GetResourcePhotoByID(Guid ID)
{
SqlParameter[] pars = new SqlParameter[1];
pars[0] = new SqlParameter("@ID", ID);
string strSql = "select Photo from T_Resource where ID=@ID";
SqlDataReader dr = SqlHelper.ExcuteSQL_SqlDataReader(strSql, pars);
Model.Resource orc = new Model.Resource();
while (dr.Read())
{ orc.Photo = (byte[])(dr["Photo"]);
}
return orc;
}数据库在局域网中其他机器上 目前的读法效率很低100KB左右的图片显示到PictureBox上都要几秒钟本机速度还好请问下用GetBytes是不是能提升效率?我参照MSDN,使用GetBytes读不到数据。
GetBytes(0,0,orc.Photo,0,1024)
SqlDataReader reader=cmd.ExecuteReader();
if(reader.Read())
{
MemoryStream ms=new MemoryStream((byte[])reader["Photo"]);
Image image=Image.FromStream(ms,true);
picturebox1.Image=image;
} reader.Close();
conn.Close();