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

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

½øÐÐÊ


Ïà¹ØÎÊ´ð£º

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

_access ÇëÎÊÕâ¸öº¯ÊýÊǸÉÂïÓõģ¿

ËüµÄ¶¨ÒåÊÇÕâÑùµÄ


_CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode);



´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿

´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......

vb.net ´´½¨accessÊý¾Ý±íʵÏÖÒ»Êý¾Ý¿â¶à¸öÊý¾Ý±í£¿

Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......

ÈçºÎ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖÐ?

ÈçºÎ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༭´òÓ¡?лл
ÈçºÎÓÃVB±àд³ÌÐòʵÏÖ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༭´òÓ¡?


н¨µÄWordºÍÒÑÓеÄWordµÄ´úÂë¿Ï¶¨ÊDz»Ò»ÑùµÄ
ÕâµãLZ»¹ÐèÒªÖ¸Ã÷
......

ÈçºÎÉ趨access logÖеÄauthenticated username?

ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿

Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ
2009-07-04 02:16:37 110.110 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ