Q:对SQL server数据库里取image类型怎么取???
A:把aspx的html元素去掉,然后页面中调用以下函数。这个页面返回的就是图片
private void DownloadImage(string FileID)
...{
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection())
...{
conn.ConnectionString = ".....";
conn.Open();
using(System.Data.SqlClient.SqlCommand command=conn.CreateCommand())
...{
command.CommandText=string.Format("select ImageSize,Image from tablexxx where id='{0}'", FileID);
System.Data.SqlClient.SqlDataReader reader=command.ExecuteReader();
try
...{
if(reader.Read())
...{
int size=reader.GetInt32(0);
byte[] buffer=new byte[size];
reader.GetBytes(1,0,buffer,0,size);
this.Response.BinaryWrite(buffer);
}
}
catch(Exception ex)
...{
this.Response.Write(ex.Message);
}
finally
...{
reader.Close();
}
}
conn.Close();
}
}
本文作者:jinjazz 来源:http://blog.csdn.net/jinjazz/
CIO之家 www.ciozj.com 微信公众号:imciow