WINFORM ´ÓORACLEÊý¾Ý¿âÖÐ,¶ÁÈ¡¶àÕÅͼƬ.
WINFORM ´ÓORACLEÊý¾Ý¿âÖÐ,¶ÁÈ¡¶àÕÅͼƬ.
¶ÁÒ»ÕÅ,ÊÇûÎÊÌâÁË,µ«¶àÕžͲ»¶®...ÔÎ!!!
ÀýÈç:ÔÚAtextbox,BtextboxÊäÈë²éѯÌõ¼þ,È»ºó²éѯµ½Êý¾Ý¿âÓжàÌõ¼Ç¼,ÔÙ·µ»ØpictureboxÏÔʾ.
×¢:´«½ø¿âÀïµÄͼƬ,ÊÇÒÔ¶þ½øÖÆÁ÷·½Ê½µÄ.
µÚÒ»ÖÖ£º¿ÉÒÔ½¨Á¢¶à¸ö×ֶΡ£
µÚ¶þÖÖ£ºÑ»·Ã¿ÕÅͼƬ£¨¶þ½øÖÆ£©£¬Ã¿¸öͼƬÓÃÌØÊâµÄ·ûºÅ·Ö¸î¿ªÀ´¡£¶ÁÈ¡µÄʱºòÔÙÒÔÌØÊâµÄ·ûºÅÀ´·Ö¸î
²»Ì«¶®,¿É·ñ˵˵´úÂëʵÀý;
ÿÕÅͼƬÉèÒ»¸öΨһ×Ö¶Îѽ
»ñÈ¡Êý¾Ýdatareader,ÔÙ±éÀúÑ»·ÏÔʾ
Winform¶¼Í£Ö¹¿ª·¢ÁË,»¹ÔÚÓÃѽ
×îºÃÓÃ΢ÈíµÄÊý¾Ý¿â,²»È»ÓÐÂé·³
дÈëͼƬʱÐèÒªÓòÎÊýÀýÈ磺
string cmdStr="insert into pictures(id,pictureName,picture) value(:id,:pictureName,:picture)";
OracleParameter[]param=
{
new OracleParameter(":id",DBType.number),
new OracleParameter(":pictureName",DBType.NVarch),
new OracleParameter(":picture",DBType.Blob)
}
param[0].value=1;
param[1].value="pictOne";
param[2].value=File.ReadAllBytes("c:\aa.jpg");
cmd.ExecuteNonQuery();
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......