¹ØÓÚ¶ÁÈ¡Êý¾Ý¿âsqlserver imageÀàÐÍ
Response.Clear();
Response.ContentType = "image/jpeg";
string idCard = Request.QueryString["id"];
if (!string.IsNullOrEmpty(idCard))
{
PersonalInfoManager manager = new PersonalInfoManager();
PersonalInfo info = manager.SelectPersonalInfoByIdCard(idCard);
if(info.Photo!=null&&info.Photo.Length>0)
Response.OutputStream.Write(info.Photo,0, info.Photo.Length);
}
Response.End();
¾¹ýµ÷ÊÔ²éѯ³öÀ´ÓÐÊý¾Ý£¬ÇÒ´æµ½Êý¾Ý¿âµÄͼƬΪjpgÀàÐ͵쬵«ÊǾÍÊÇÔÚÒ³ÃæÉÏÏÔʾ²»³öÀ´£¬Ôõô»ØÊ£¿£¿
ÆäʵÕâ¾ÍÊÇÑéÖ¤ÂëͼƬµÄÏÔʾÔÀí
ÕâÑùÒ²¿´²»¼û¹þ
ûÈËÖªµÀÂ𣿣¿£¿£¿£¿£¿£¿£¿
{{--
Ïà¹ØÎÊ´ð£º
ÊÇÕâÑùµÄ£¬ÎÒÓÃÊÇODBCÊý¾ÝÔ´Á¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â£¬ÏÖÔÚÎÒ¾õµÃºÜÂé·³£¬ÒòΪҪΪÿÈç»úÌí¼Ó¶ÔÓ¦µÄÊý¾ÝÔ´£¬Ïë°ÑËû¸Ä³ÉADO·½·¨À´·ÃÎÊ·þÎñÆ÷µÄÊý¾Ý¿âÄÜʵÏÖÂð£¿ÒªÔõôд¡£
±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2£¬¿Í»§ ......
sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð?
´ó¼Ò˵Ïêϸһµã
²»Ã÷°×~~~
Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â
sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹ÔÊý¾Ý¿â
Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑ ......
´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......