DocketId like '%"+name+"%' or SupplierName like '%"+name+"%' ÕâÑùдÁË£¬µ±nameÓÐֵʱ×ÜÊÇ˵¡°Êý¾Ý¿â´íÎó£¬ÖÁÉÙÓÐÒ»¸öֵΪ¸³Öµ¡£¡± ÎÒÏëÍê³ÉÒÔÉÏ´úÂëµÄ¹¦ÄÜ£¬Çë¸ßÊÖÖ¸µã£¡£¡
ACCESS·¢´í°æÁË,°ï¶¥.
ACCESSÖ»Äܰﶥ..
{{-- ......
±¾È˽ð±Ò²»¹»£¬ÎÞ·¨ÏÂÔØÂÛ̳Àï´óϺÃǵÄʾÀý¡£Çó½Ì¸÷λÈÈÐÄÅóÓÑ£¬ÄÜ·ñ¸øÎÒ·¢¸öÈçÌâʾÀý£¬ÓÊÏätbmq@163.com,»ò¼ÓQQ277362112¡£²»Ê¢¸Ð¼¤~£¡
°Ù¶ÈһϰÉ
Ëæ×ÅÊÖ»ú¡¢Ð¡ÁéͨµÈÒƶ¯µç»°µÄÈ«ÃæÆÕ¼°£¬Ô½À´Ô½¶àµÄ¿Í»§Ï£Íû£º
ÔÚ¼ÆËã»úÉÏÄܹ»ÊµÏÖ¶ÌÐŵÄÊÕ·¢Ö§³Ö£»
ÔÚÆóÊÂÒµµ¥Î»°ì¹«ÏµÍ³»òÒµÎñÁ÷³ÌÖÐǶÈë¶ÌÐÅ֪ͨ»ò±¨¾¯µÈ¹¦ÄÜ£»
Ô ......
ÎÒÔÚÆóÒµ¹ÜÀíÆ÷Öн«sqlserver µÄÒ»¸öÊý¾Ý¿âµ¼³öΪaccess£¬ÒªÓû§ÃûºÍÃÜÂë,
ÎÒÊäÈëÁËsqlÊý¾Ý¿âµÄ²»ÐÐ
accessĬÈϵÄadminÓû§ÃûÒ³²»ÐС£
Ôõô°ì£¿
µÇ¼Êý¾Ý¿âµÄÃû×ÖºÍÃÜÂë,²»Í¬·þÎñÆ÷,ÏȽ¨Á¢Á´½Ó·þÎñÆ÷
SQL code:
Transact-SQLÓï¾ä½øÐе¼Èëµ¼³ö£º
1.ÔÚSQL SERVERÀï²éѯaccessÊý¾Ý:
-- =========================== ......
±íÒ»£º
ÎïÁÏ ÈÕÆÚ ²úÁ¿ µ¥Î»
a 2009-4-1 2001 ¸ö
a 2009-7-2 250 ¸ö
a 2009-5-15 350 ¸ö
a 2009-12-12 258 ̨
b 2009-4-1 2001 ¸ö
b 2009-7-2 250 ¸ö
b 2009-5-15 350 ¸ö
b ......
accessÊý¾Ý¿â c# vs2008
protected void tongji1(object sender, EventArgs e)
{
string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\\dbps.mdb";
string str = "UPDATE table1 SET number =number + 1 where id = 1 ";
&nbs ......
asp.net+access·¢²¼ÍøÕ¾£¬web.configÖеÄConnectiongString¸ÃÔõôдÄØ£¬
ÎÒÊÇÕâÑùдµÄ£º
<connectionStrings>
<add connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\hsz\DB\hzs.mdb" name="hzsConnectionString"/>
</connectionStrings>
......