Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

asp.net²éѯSqlServerÖÐtextÀàÐÍÊý¾Ý¶ªÊ§

asp.net²éѯSqlServer2005ÖÐtextÀàÐÍÊý¾Ý³£³£¶ªÊ§£¬Ìí¼ÓÊý¾Ýµ½textÀàÐÍÖп´Ò³ÃæÉÏ¿ÉÒÔ£¬ÓиöÒ»Á½Ì죬¾Í¿ÉÄÜ»á³öÏÖtext
Êý¾Ý´æµÄÊý¾ÝȱÉÙÒ»²¿·Ö£¬ÎªÊ²Ã´°¡£¡Çë´ó¼Ò°ï°ïæ°¡£¡
Óöþ½øÖÆ´æ·ÅËãÁË

²»Ã÷°×£¬ÄÜ×Ðϸ˵˵Â


¶¥

´æÊý¾ÝµÄʱºò ÊDz»ÊÇÓõIJÎÊý£¬textÀàÐͲ»ÒªÖ¸¶¨´óС¡£

UP
²»Îȶ¨¾Í²»Ì«ºÃ½â¾öÁË

ÉÙÒ»²¿·Ö£¬ÊDz»ÊÇÄã´«²ÎµÄʱºòÖ¸¶¨Á˳¤¶È£¬¶øÄãµÄÄÚÈݳ¬³öÁ˳¤¶ÈÄØ

ûÓжԴ洢µÄÊý¾ÝŪ´óС£¬ÎÒÏÖÔÚÏëµÄÊDz»ÊÇÒòΪÊý¾Ý¿âÖеÄÊý¾Ý´æµÄ¶àÁË£¬Êý¾Ý¿â»á×Ô¶¯½ØÈ¡£¬¾ÍÏñÎÒ´Ó°Ù¶ÈÉÏ¿´µÄ£¬ÊDz»ÊÇÓ¦¸ÃtextÀàÐ͵ÄÊý¾Ý³¬¹ý¶àÉÙk£¬Êý¾Ý¿â¾Í×Ô¶¯¸ø½ØÈ¡ÁË£¬µ÷µ½Êʵ±´óС·¶Î§£¬²Å»á³öÏÖÎÒÏÖÔÚµÄÎÊÌâ°¡£¡

»¹ÒªËµµÄÒ»µã¾ÍÊÇ£¬ÎÒͬÑùµÄ³ÌÐò¶¼ÊǸøÎÄÕ±íµÄcontent×ֶζ¨ÒåµÄtextµÄÀàÐÍ£¬ÄǸöÍøÕ¾ÉϾÍûÓÐʲôÎÊÌ⣬ÄǸöÍøÕ¾¾ÍÊDZÈÎÒÏÖÔÚµÄÍøÕ¾µÄÊý¾ÝÁ¿´óºÃ¶à£¬²¢ÇÒ£¬Ã¿Ìì·ÃÎÊÁ¿Ò²ÊÇͬÑùÒª´ó¡£ÎÒÏÖÔÚ¾ÍÊǾõµÃ¿ÉÄÜtextÀàÐÍ£¬ÎÒÒªÉèÖÃʲô¶«Î÷£¬Ö»ÊDz»ÖªµÀÉèÖÃʲô£¿Çë¸ßÊÖÖ¸µã°¡£¡¼°¼°¼°¼°¼°¼°¼°¼°¼°¼°¼°
¼°

Õâ¸öÒª×Ðϸ²é¿´ text ÀàÐ͵Ĵ洢·½Ê½ºÍ´óСÏÞÖÆ,È»ºóºÍÄã´æ·ÅµÄÎı¾±È¶Ô,±ÈÈçÄãµÄÎı¾Öг¤¶È¶àÉÙ,ÊÇ·ñ°üº¬Òì³£×Ö·û,×îºó²Å¿É³õ²½µÃ³ö½áÂÛ,ͬʱµÃÓÃÆäËû·½·¨×¥¸öʵÀýÑо¿


**ϵͳÉè¼ÆÕß,¸ßÊÖµÄÀÖÔ°,»¶Ó­À´QQȺ: 102271374 Ò¼µÀÉè¼Æ**

¼ÌÐø¶¥Ò»ÏÂ

sql 2005 ½«³¬¹ý 8,000 ¸ö×Ö·ûµÄ×Ö·û´®ºÍ´óÓÚ 8,000 ×ֽڵĶþ½øÖÆÊý¾Ý´æ´¢ÎªÃûΪ text ºÍ image µÄÌØÊâÊý¾ÝÀàÐÍ¡£ºÜÓпÉÄܵ±Ç°ÊäÈë×Ö·û´®³¤¶È´óÓÚÁËÕâÒªÇó¡£
¸öÈ˽¨Ò飬Èç¹û²»ÊÇ´æ´¢Êý¾Ý¿éµÄ»°£¬¿ÉÒÔÊÔÊÔvarchar,»òÕßnvarchar

¶¥

ÒýÓÃ
ÉÙÒ»²¿·Ö£¬ÊDz»ÊÇÄã´«²ÎµÄʱº


Ïà¹ØÎÊ´ð£º

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

Çóc#²Ù×÷sqlserverÊý¾Ý¿âÎÊÌâ

ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......

ASP.netÖÐʹÓÃJQUERY²å¼þÎÊÌ⣡

asp.net ajaxÖÐupdatepanelÀïÃæµÄ¿Ø¼þÀïÃæÓиöbuttonºÍÈô¸Étextbox
ÎÒµã»÷buttonÑéÖ¤ÐÅÏ¢³öÏÖ£¬µ«ÊǾÍÊÇÎÞ·¨À¹½ØÎÒbuttonºóÃæÔËÐеÄʼþ£¡
ÑéÖ¤µÄ´úÂëÊÇJSÑéÖ¤»¹ÊÇ.netÖеÄÑéÖ¤¿Ø¼þ£¬»òÊǰ´Å¥Ê¼þÖеĺǫ́ÑéÖ¤£¿
......

asp.netºǫ́µ÷ÓÃjsÎÊÌâ - .NET¼¼Êõ / ASP.NET

±¾ÈËĿǰÓöµ½Ò»¸öÄÑÌ⣬Çë¸÷λ¸ßÊÖ¡¢´óÏÀ°ï°ïæ¡£
ÎÒµ¥»÷Ò»¸ö°´Å¥Ê±Òª°ÑgridviewÖеÄÊý¾ÝÒ»¸öÒ»¸öµÄÈ¡³ö²¢°Ñ¶ÔÓ¦²ÎÊý´«µÝ¸øÇ°Ì¨µÄjs¡£
ÎÒÊÔÁ˼¸ÖÖºǫ́µ÷ǰ̨µÄ·½Ê½¶¼Ã»Óгɹ¦£¬ËùÒÔÇë´óÏÀÃǰï°ïСµÜ¡£
лл¡£
²» ......

asp.netµ¼³öEXCELÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

C# code:

SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ