command.CommandText = "select pImage from mytable where id=3";
.
SqlDataReader myReader = mySqlCommand.ExecuteReader();
if (myReader.Read())
{
Response.ContentType = "image/jpeg";
try
{//id存在,照片不为空
Response.BinaryWrite((byte[])myReader["pImage"]);
Response.End();
}
catch(InvalidCastException ex)//捕捉异常:学号存在,但无照片
{
//id存在,照片为空
.
}
}
else
{
//id不存在
.
}


浙公网安备 33010602011771号