AccessÖеÄÊÇ/·ñ
Select a.ID,a.Name,(Select IIF(Count(*)>0,true,false) from a where a.ID=1) As IsOK from a where a.ID=1 ¼ìË÷³öÀ´ºó£¬°ÑIsOK×Ö¶Îת»»²»³ÉbooleanÀàÐ͵ģ¬ÌáʾSystem.Int16²»ÄÜת»»³ÉSystem.Boolean ÇëÎÊÈçºÎ½â¾ö£¬Ð»Ð»
true:-1 false:0 Select a.ID,a.Name,(Select IIF(Count(*)>0,-1,0) from a where a.ID=1) As IsOK from a where a.ID=1 ûÓа취£¬Õâ¸öOLEDBÀàÖеÄÎÊÌ⣬ACCESSͨ¹ýoleconnection »Ø¸øÒ»¸öintÊý×Ö ÄãÖ»ÄÜ×Ô¼ºÔÚC#ÖнøÐÐת»»ÁË¡£ÒýÓà ûÓа취£¬Õâ¸öOLEDBÀàÖеÄÎÊÌ⣬ACCESSͨ¹ýoleconnection »Ø¸øÒ»¸öintÊý×Ö ÄãÖ»ÄÜ×Ô¼ºÔÚC#ÖнøÐÐת»»ÁË¡£ ¶ÔÓÚ±íÖÐij¸ö×Ö¶ÎÊÇ ÊÇ·ñ ÀàÐ͵ģ¬ÊÇ¿ÉÒÔת»»µÄ£¬Õâ¸ö¡¡ÒýÓà true:-1 false:0 Select a.ID,a.Name,(Select IIF(Count(*)>0,-1,0) from a where a.ID=1) As IsOK from a where a.ID=1 °Ñtrue¸Ä³É-1¡¡±¨³öÒ»ÑùµÄ´íÎó ÄãÊÇÔÚÓïÑÔ»·¾³ÖÐÔËÐÐSQLÓï¾ä£¬´ò¿ª¼Ç¼¼¯£¿ Select a.ID,a.Name,(Select IIF(Count(*)>0,true,false) from a where a.ID=1) As IsOK from a where a.ID=1 Õâ¸öÓï¾äÏëʵÏֵŦÄÜÊÇʲô£¿ËƺõÂß¼ÉÏºÜÆæ¹Ö£¬Èç¹ûAÖÐÓÐid=1µÄ¼Ç¼£¬×ÔÈ»ÄãÓ¦¸Ã·µ»Ø isok = true,Èç¹ûûÓзûºÏÌõ¼þµÄ¼Ç¼£¬ÄãµÄÕâ¸öÓï¾äÁ¬Ò»Ìõ¼Ç¼¶¼²»»á·µ»Ø¡£ ÄãµÄÓï¾äÂß¼ÉϵÈЧÓÚ select id,name,true from a where id=1 ½øÐÐÊ
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿ <%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ËüµÄ¶¨ÒåÊÇÕâÑùµÄ _CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode); ´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿ ´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\" cat = New ADOX.Catalog cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......
ÈçºÎ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༴òÓ¡?лл ÈçºÎÓÃVB±àд³ÌÐòʵÏÖ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༴òÓ¡? н¨µÄWordºÍÒÑÓеÄWordµÄ´úÂë¿Ï¶¨ÊDz»Ò»ÑùµÄ ÕâµãLZ»¹ÐèÒªÖ¸Ã÷ ......
ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿ Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ 2009-07-04 02:16:37 110.110 ......