Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

Êý¾Ý¿âÄÜ·ñͬʱ´ò¿ª¶à¸ö¼Ç¼¼¯£¨Access£©

m_pRemRecordset.CreateInstance(__uuidof(Recordset));
try
{
m_pRemRecordset->Open("SELECT * from RemindList",// ²éѯRemindList±íÖÐËùÓÐ×Ö¶Î
theApp.m_pConnection.GetInterfacePtr(),// »ñÈ¡¿â½Ó¿âµÄIDispatchÖ¸Õë
adOpenDynamic,
adLockOptimistic,
adCmdText);
} ......

ÈçºÎÅúÁ¿µÄµ¼³öcsvÊý¾Ýµ½Access±íÖÐ

csvµÄÊý¾Ý´ó¸ÅÔÚ100Íò£¬¿ìËÙ½«Êý¾Ýµ¼³öÖÁAccess±íÖÐ
csvÇ°Ãæ²åÈëÒ»¸ö¿ÕÁУ¬
ctrl+A µ½ AccessÖÐ ctrl+v.

Êǵ¼È뻹Êǵ¼³ö£¿ÈçÊǵ¼È룬 ÓÃACCESS±¾ÉíµÄµ¼Èë²»ÐУ¿

µ¼ÈëÖÁAccessÖÐ
2,ÍîAC221*,2006-05-15 11:24:00,ʩҢ·,1303,NULL
2,¸ÓE792*5,2005-02-03 10:49:00,°ËÒ»´óµÀ,7006,NULL


ÄãÓÃÎļþ-> ......

sqlite£¬updateµÄÎÊÌâ

ÎÒÏë×öÒ»¸ösqliteµÄ¼à¿ØÈí¼þ£¬ÊµÊ±ÖªµÀÓû§¶ÔÊý¾Ý±í¶¼×öÁËÄÄЩ²Ù×÷¡£

ÔÚÓû§update Ò»¸öÓû§Êý¾Ý±íֵʱ£¬ÎÒÈçºÎ¿ÉÒÔµÃÖªÓû§updateµÄÄĸö×ֶεÄÖµ£¿ÎÒ±¾À´¸øÓû§±íÌí¼Ó´¥·¢Æ÷À´ÊµÏֵ쬵«´¥·¢Æ÷ºÃÏñÖ»Äܵõ½Óû§updateµÄÕâÌõÊý¾ÝµÄrowid£¬µ«ÎÒÏëµÃÖªÓû§updateÊý¾Ý±íÖÐijһÁеÄ×Ö¶ÎÃûºÍ¾ÉÖµ£¬Õâ¸öÔõôÀ´ÊµÏÖ£¿ÄÄλ¸ß ......

sqlServer like

ǰÖÃlikeÈçºÎʹÓÃ
      ±ÈÈ磬¡®1,2¡¯   like   ¡®1,2,3¡¯ÔõôƥÅä
      ÊDz»ÊÇ¡®%1,2%¡¯like¡®1,2,3¡¯
charindex(',' + '1,2' + ',' , ',' + '1,2,3' + ',') > 0

ÊÇÕâÑù£¬µ«ÊDz»ÖªµÀÄãÏë¸Éʲô¡£

chari ......

Delphi´°Ìåµ½µ×ÈçºÎ²ÅÄÜÒþ²Ø£¿

ÔÚÍøÉÏËÑÁ˺ܶ෽·¨£¬¸Ð¾õ¶¼²»ºÃÓá£
ÓÐ˵ÓÃForm1.HideµÄ£¬µ«ÊÇÎÒ·¢ÏÖÕâ¸ö¸ù±¾Ã»Óá£
ÓÐ˵ÓÃshowwindow(application.handle,sw_hide);  µÄ£¬Ò²²»ÐС£
ÓÐ˵
ÔÚ¹¤³ÌÎļþµÄ 
  Application.Run£» 
  Ç°Ãæ¼ÓÉÏ 
  Application.ShowMainForm:=False;  µÄ£ ......

delphiÖÐΪºÎ»á³öÏÖÈç´Ë´íÎó

¸÷λ´óÀÐ:
СµÜÔÚ×öÒ»¸ö¿â´æµÄС³ÌÐòÓöµ½ÎÊÌâ,Çë°ïæ,³ÌÐò˼·ÊÇ:ÉÌÆ··Ö¶þÖÖ1:ÀàÉÌÆ·2:×éºÏÉÌÆ·(½«µ¥ÀàÉÌÆ·ºÏ³ÉÒ»·ÝÏúÊÛ).¶þÕßÔÚÇø·ÖÔÚǰÕßµÄ'Àà±ð'(×Ö¶ÎÃûdalei)ÉÌÆ·ÐÔÖÊ,ºóÕßµÄ'Àà±ð'Ϊ'×éºÏ',×éºÏÉÌÆ·ÓÐ×Ô¼ºµÄÉÌÆ·Ãû²¢ÉèÁ¢×¨ÃÅÊý¾Ý¿â(zh),ËüÓÐ×éºÏÉÌÆ·Ãû(zsp_name),×éºÏÉÌÆ·Öеĵ¥¸öÉÌÆ·Ãû(d ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [2570] [2571] [2572] [2573] 2574 [2575] [2576] [2577] [2578] [2579]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ