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»ÊÇÄã´«²ÎµÄʱº
Ïà¹ØÎÊ´ð£º
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿ ¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
ÎÒ´´½¨ÁËÒ»¸öÎïÆ·ä¯ÀÀÒ³Ãæ£ºbookview.aspx£¬ÆäÖÐÔÚÒ³ÃæµÄ×ó²àÁгöÎïÆ·µÄ·ÖÀࣺ·ÖÀà1£¬Á¬½Óµ½Ò³Ãæbookview.aspx£¿id=1£¬ÆäËûÒÀ´ÎÀàÍÆ£¬µ±Ò³ÃæµÚÒ»´Î¼ÓÔØµÄʱºòÉèÖÃidµÄĬÈÏֵΪ1£¬ÔËÐгÌÐò·¢ÏÖÒ³ÃæÒ»Ö±³öÓÚÖØÐÂ¼Ó ......
C# code: SqlConnection conn = CsDB.sqlcon(); SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
ÎÒÅóÓѵÄÒ»¸öASP.NETÒýÓÃÁËajax¼¼Êõ£¬binĿ¼ÏÂÃæÒ²ÓÐajaxpro.dll£¬ÎªÊ²Ã´·þÎñÆ÷²»ÐèÒª°²×°ajax²å¼þÒ²¿ÉÒÔÔËÐÐÄØ£¬ÕÕÀí˵Ӧ¸ÃÒª°²×°ASPAJAXExtSetup.msi ÓÐ ajaxpro.dll¾Í¿ÉÒÔÁË ²»Í¬µÄaajx×é¼þ AjaxPro¾ÍÊÇ¿ò¼ ......