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

accessÖÐlikeд·¨

sqlÓï¾äÊÇÕâÑùдµÃ 
string sql = "select * from shophistory where username(stringÀàÐÍ)¡¡like '%"+ name +"%' ";
½á¹ûÔËÐб¨´í£º(²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ  ˵ºó°ë¶ÎÓдíÎó like '%"+ name +"%' ";

²é¹ýÍøÉÏ×ÊÁÏ ËµÊÇÓÃ* #»ò ?¶¼ÐÐ £¬µ«ÔÚvs2005ÖÐ ÈçÓõÄÊÇOleDbDataAdapter »¹ÊÇÓðٷֺţ¿²»ÖªµÀ¸ÃÈçºÎÐ޸ģ¿ÔÚÏߵȼ±£¡£¡
ÁíÍâÔÙÎÊÒ»ÏÂaccessÖÐ Îı¾ºÍ±¸×¢ 2¸öÊÇ·ñ¶¼ÄÜÓÃlikeÄ£ºý²éѯ£¿ÈçÊÇÓï·¨ÊÇ·ñ¾ÍÊÇÓëÎÒÉÏÃæÐ´µÄÒ»Ñù£¿

*

ºý²éѯÓëbetween and
AccessÓë SqlServer  ,Oracle  ²»Í¬µÄµØ·½
Select * from ±í where  ×Ö¶Î1  like '*aa*'      aaÊÇÄãÊäÈëµÄ×Ö·û  *ÊDZØÐëÊäÈëµÄ¸ñʽ
Select * from ±í where  ×Ö¶Î2  between #3#  and  #33#      ×Ö¶Î2  ÔÚ3ºÍ33Ö®¼ä  #ÊDZØÐëÊäÈëµÄ¸ñʽ

select * from ±íÃû where ×Ö¶ÎÃû like '*abc*'


C# code:

//ʹÓòÎÊý
sql = "SELECT * from tt where aa like '%'+@t1+'%'";



ÒýÓÃ
ºý²éѯÓëbetween and
AccessÓë SqlServer  ,Oracle  ²»Í¬µÄµØ·½
Select * from ±í where  ×Ö¶Î1  like '*aa*'      aaÊÇÄãÊäÈëµÄ×Ö·û  *ÊDZØÐëÊäÈëµÄ¸ñʽ
Select * from ±í where  ×Ö¶Î2  between #3#  and  #33#


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

¼ÓÌõ¼þµÄVB excelµ¼ÈëACCESS Êý¾Ý¿â

ÔÚTEXT1.TEXT  ÖжÁÈ¡EXCELµÄ·¾¶
Ñ¡Ôñcombo1.textÖеÄÊý¾Ý±íÃû³Æ
µã»÷µ¼Èëºó Èç¹û×ֶκÍÊý¾Ý¿âµÄÒ»Ñù ¾ÍÖ´Ðе¼Èë ·ñÔòÌáʾ³ö´íÐÅÏ¢


¸÷λ´ó¸ç°ï°ïСµÜ  ÒªÔõôдÕâ¸öÖ´ÐгÌÐò  ÏÖÔÚ ......

VB Óë Access ʵÏÖ°à×é¡¢ÈÕ¡¢Ô¡¢Ä걨±íÎÊÌâ

±¾È˳õ´Î½Ó´¥£¡±È½ÏÄ£ºý£¡Ï£Íû´ó¼Ò¿ÉÒ԰ѶÔMicrosoft Office AccessµÄ±í²Ù×÷³£ÓÃÃüÁî ¸æÖ®£¡
»¹ÓÐÎÒÏëʵÏÖ°à×é¡¢ÈÕ¡¢Ô¡¢Ä걨Microsoft Office AccessÀïµÄ±íµ¥Ôõô´¦Àí£¿

ÊÇÀûÓò»Í¬µÄ±í·Ö±ð¼Ç¼Сʱ°à×éÈ ......

ACCESSÖн¨Á¢Çл»±íµ¥Ê±Óöµ½ÎÊÌâ ÔÚÏßµÈ

ACCESSÖн¨Á¢Çл»±íµ¥,
µã»÷ ¹¤¾ß/×ÊÁϿ⹫ÓóÌʽ/Çл»±íµ¥¹ÜÀíÔ± ºó
Ìáʾ£ºMicrosoft office accessÎÞ·¨½¨Á¢visual basicÄ£×飡
µ½µ×ÊdzöÁËʲ÷áÎÊÌâÄØ£¿
µÚÒ»´ÎÕâÑù½¨Á¢Çл»±íµ¥ÊÇ¿ÉÒԵ쬵«ÊÇÓÉÓÚÓÐ ......

Çë¸øÒ»¸öACCESS¶àÌõ¼þ²éѯµÄÀý×Ó

Çë¸øÒ»¸öACCESS¶àÌõ¼þ²éѯµÄÀý×Ó,×Ö¶Î:ÐÕÃû,µç»°,¹«Ë¾,µØÖ·Îª²éѯÌõ¼þ,Ö»Òª²»Îª¿Õ,¾Í×÷Ϊ²éѯÌõ¼þ.
ÄãÏÈ給這個Щ×Ö¶Î設ÖÃ變Á¿並賦³õÖµ為:%,
ÔÙÔÚ²é詢 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ