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~`````
Ïà¹ØÎÊ´ð£º
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
ÊÇÕâÑù×ӵģ¬ÎÒÏÖÔÚ×öÁËÒ»¸öÍøÖ·µ¼º½µÄÍøÕ¾£¬Ê×ҳȫÊÇÍøÃûºÍÁ´½Ó£¬ÀàËÆhao123µÄÊ×Ò³£¬µ«ÊÇÓлáÔ±µÇ¼£¬»áÔ±µÇ¼ºó¿ÉÒÔÊ×´ÎÍøÕ¾£¬»áÔ±µÇ¼ºó»áÏÔʾÊղصÄÍøÕ¾³öÀ´£¬ÒòΪÊ×ҳͷ²¿Ï»áÓÐÒ»¸öÎÒµÄÊղصÄÀ¸Ä¿...ÏÖÔÚÿ´ò¿ ......
ÎÒÓõÄÊÇGodaddyµÄ·þÎñ,ʹÓÃ
C# code:
HttpRuntime.UnloadAppDomain();
À´ÖØÆô³ÌÐò»áÅ׳öÒì³£,Ó¦¸ÃÊÇȨÏÞ²»¹»,Çë½Ì´ó¼Ò»¹ÓÐûÓÐÆäËûµÄ°ì·¨?
using System.ServiceProcess;
public void ResetAsp ......