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

accessµÄ´«²ÎÄ£ºý²éѯ - .NET¼¼Êõ / ASP.NET

string sql = "select * from [order] where @type like '%@keyword%'";
  OleDbParameter[] paras = new OleDbParameter[]
  {
  new OleDbParameter("@type",type),
  new OleDbParameter("@keyword",keyword)
  };

ÕâÑù²é²»³öÊý¾Ý ËÑË÷Ò»·¬ÕÒµ½Ò»¸ö½â¾ö·½·¨ ¼´½«'%@keyword%' ¸ÄΪ '%'+@keyword+'%' ÒÀÈ»²é²»³öÊý¾Ý- -£¡ ÓÚÊǽ«@type¸Ä³ÉÆ´½ÓµÄ¡£¡£¡£¾Í¿ÉÒԲ鵽Êý¾ÝÁË£¬ÎªÊ²Ã´£¿ ²»ÄÜͬʱ´«Á½¸ö²ÎÊýÂ𣿠 

ĿǰÓõÄÓÐЧд·¨

string sql = "select * from [order] where "+type+" like '%'+@keyword+'%'";
  OleDbParameter[] paras = new OleDbParameter[]
  {
  new OleDbParameter("@keyword",keyword)
  };
string sql = "select * from [order] where "+type+" like '%@keyword%'";
ÕâÑù¾ÍÐÐÁËϵͳ»á×Ô¶¯ÅжÏ@µÄ

C# code:
string sql = "select * from [order] where "+type+" like '%@keyword%'";
ÕâÑù¾ÍÐÐÁËϵͳ»á×Ô¶¯ÅжÏ@µÄ

¾ÍÊÇÕâÑù.

²»ÐÐµÄ ÏÖÔÚÊý¾Ý¿âÊÇACCESSµÄ£¡ ²»ÊÇSQL SERVER ¡£

ÏÖÔÚÓиöÏë·¨£¬ÔÚÍøÉÏÕÒ˵ACCESSÊDz»Ö§³Ö¶àÓï¾äÖ´ÐкÍ×¢Ê͵ģ¬ÄÇÊDz»ÊǾͲ»ÅÂ×¢ÈëÁË¡£¡££¿


Æ´½Ó²Å¿ÉÒÔ


hehe~`````


Ïà¹ØÎÊ´ð£º

ÔÚasp.netÀïÃæ½Å±¾³ö´í - .NET¼¼Êõ / ASP.NET

function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;

var div1=document.getElementById("divPwd");

if (pwd.value=="")
{
......

¹ØÓÚACCESSºÍMSSQLµÄÎÊÌâ - Web ¿ª·¢ / ASP

ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......

¹ØÓÚASP.NETÉú³É¾²Ì¬Ò³Ãæ - .NET¼¼Êõ / ASP.NET

ÊÇÕâÑù×ӵģ¬ÎÒÏÖÔÚ×öÁËÒ»¸öÍøÖ·µ¼º½µÄÍøÕ¾£¬Ê×ҳȫÊÇÍøÃûºÍÁ´½Ó£¬ÀàËÆhao123µÄÊ×Ò³£¬µ«ÊÇÓлáÔ±µÇ¼£¬»áÔ±µÇ¼ºó¿ÉÒÔÊ×´ÎÍøÕ¾£¬»áÔ±µÇ¼ºó»áÏÔʾÊղصÄÍøÕ¾³öÀ´£¬ÒòΪÊ×ҳͷ²¿Ï»áÓÐÒ»¸öÎÒµÄÊղصÄÀ¸Ä¿...ÏÖÔÚÿ´ò¿ ......

asp.netÈçºÎÖØÆôÍøÕ¾? - .NET¼¼Êõ / ASP.NET

ÎÒÓõÄÊÇGodaddyµÄ·þÎñ,ʹÓÃ
C# code:
HttpRuntime.UnloadAppDomain();
À´ÖØÆô³ÌÐò»áÅ׳öÒì³£,Ó¦¸ÃÊÇȨÏÞ²»¹»,Çë½Ì´ó¼Ò»¹ÓÐûÓÐÆäËûµÄ°ì·¨?
using System.ServiceProcess;
  public void ResetAsp ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ