ÎÄÕ£¬Í¼Æ¬ÈçºÎ´æ´¢µ½SQLSERVERÖÐ
ͼƬÔÚSQLSERVERÖд洢µÄÊÇ·¾¶
¶ÔÂð£¿
ÒªÊDz»Êǵϰ£¬ÄÇÊÇÔõô´æµÄ£¿
»¹ÓУ¬ÎÒÒªÏë´æ´¢Ò»ÆªÎÄÕ£¨4£¬5ǧ×Ö£©
ÄǸÃÈçºÎ´æ´¢ÄØ£¿¡¢
ͼƬÔÚSQLSERVERÖд洢µÄÊÇ·¾¶
¶ÔÂð£¿
ÒªÊDz»Êǵϰ£¬ÄÇÊÇÔõô´æµÄ£¿ //image Õâ¸öÊý¾ÝÀàÐÍ£¬½«Í¼¶Á³É¶þ½øÖÆÁ÷
»¹ÓУ¬ÎÒÒªÏë´æ´¢Ò»ÆªÎÄÕ£¨4£¬5ǧ×Ö£©
ÄǸÃÈçºÎ´æ´¢ÄØ£¿¡¢//text
ͼƬÔÚSQLSERVERÖд洢µÄÊÇ·¾¶¶ÔÂ𣿠һ°ã¶¼ÊÇ´æÂ·¾¶¡£
ÒªÊDz»Êǵϰ£¬ÄÇÊÇÔõô´æµÄ£¿ ½«Í¼¶Á³É¶þ½øÖÆÁ÷´æÈëÊý¾Ý¿â¡£imageÊý¾ÝÀàÐÍ¡£
»¹ÓУ¬ÎÒÒªÏë´æ´¢Ò»ÆªÎÄÕ£¨4£¬5ǧ×Ö£© ÄǸÃÈçºÎ´æ´¢ÄØ£¿ Ò»Ñù´æ´¢£¬textÊý¾ÝÀàÐÍ
Ò»°ãÔÚÊý¾Ý¿âÖд洢ͼƬ·¾¶
´æ´¢Í¼Æ¬ÒÔ¶þ½øÖÆÁ÷·½Ê½
ÎÄÕÂÓà text ÀàÐÍÍêÈ«¿ÉÒԸ㶨
ͼÏñ´æ´¢µÄÊǶþ½øÖÆÊý¾ÝÁ÷£¡
Ò»°ãͼƬ´æÂ·¾¶
ÎÄÕÂÄÚÈÝÒ»°ã¶¼ÓÃtext
ͼƬ¿ÉÒÔ´æÂ·¾¶£¬Ò²¿ÉÒÔ´æ¶þ½øÖÆÁ÷¡£¡£¡£¡£×îºÃµÄ×ö·¨µ±È»ÊÇ ´æ ·¾¶ÁË£¬ÎÞÂÛ´æÈ¡¶¼±È½Ï·½±ã¡£¡£¡£
ÖÁÓÚÎÄÕÂÂ¿ÉÒÔÖ±½Ó´æÔÚ textÊý¾ÝÀàÐÍ µÄ×Ö¶ÎÀïÃæ£¬Ò²¿ÉÒÔ·ÅÔÚXML»òÕß txtÎļþÀïÃæ£¬È»ºó½øÐÐÎļþ¶Áд£¬µ±Ì¸Ç°ÕßÒª¼òµ¥ºÜ¶à£¬¾ÍÒ»¸ö×ֶξͺÃÁË£¬ºóÕߵϰ²Ù×÷±È½ÏÂé·³£¬µ«³ÌÐòЧÂÊÒª±ÈǰÕ߸ߡ£¡£¡£
ͼƬÔÚSQLSERVERÖд洢µÄÊÇ·¾¶ ¶ÔÂð£¿
===¶Ô
ÒªÊDz»Êǵϰ£¬ÄÇÊÇÔõô´æµÄ£¿
===¿ÉÒÔ°ÑͼƬ±äΪ¶þ½øÖÆÁ÷ ´æ £¬Êý¾Ý¿â×Ö¶Î ÀàÐÍΪ image
»¹ÓУ¬ÎÒÒªÏë´æ´¢Ò»ÆªÎÄÕ£¨4£¬5ǧ×Ö£© ÄǸÃÈçºÎ´æ´¢ÄØ£¿¡¢
=====-ÎÄÕÂÒ»°ã¶¼ÊÇ Êý¾Ý¿â×Ö¶Î ÀàÐÍΪ text£¬ ntext
Ïà¹ØÎÊ´ð£º
ÊÇÕâÑùµÄ£¬ÎÒÓÃÊÇODBCÊý¾ÝÔ´Á¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â£¬ÏÖÔÚÎÒ¾õµÃºÜÂé·³£¬ÒòΪҪΪÿÈç»úÌí¼Ó¶ÔÓ¦µÄÊý¾ÝÔ´£¬Ïë°ÑËû¸Ä³ÉADO·½·¨À´·ÃÎÊ·þÎñÆ÷µÄÊý¾Ý¿âÄÜʵÏÖÂð£¿ÒªÔõôд¡£
±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2£¬¿Í»§ ......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£
ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......
asp.net²éѯSqlServer2005ÖÐtextÀàÐÍÊý¾Ý³£³£¶ªÊ§£¬Ìí¼ÓÊý¾Ýµ½textÀàÐÍÖп´Ò³ÃæÉÏ¿ÉÒÔ£¬ÓиöÒ»Á½Ì죬¾Í¿ÉÄÜ»á³öÏÖtext
Êý¾Ý´æµÄÊý¾ÝȱÉÙÒ»²¿·Ö£¬ÎªÊ²Ã´°¡£¡Çë´ó¼Ò°ï°ïæ°¡£¡
Óöþ½øÖÆ´æ·ÅËãÁË
²»Ã÷°×£¬ÄÜ×Ðϸ ......
ÓÐһ̨Êý¾Ý¿â·þÎñÆ÷£¬¿Í»§¶ËʹÓÃADO.NETÁ¬½Ósql£¬Ê¹ÓÃExecuteScalarÖ´ÐÐSQL INSERTÓï¾ä£¬È»ºó¿Í»§¶Ëˢв»Äܲéѯµ½ÐÂINSERTµÄÊý¾Ý£¬¹ý10Ãë×óÓÒ²ÅÄܲ鵽ÐÂÊý¾Ý
ʲôÔÒò
Äã×öÁË»º´æÂð£¿
û×ö»º´æ
Ôõô»áÄØ£¡ ......