Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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

½øÐÐÊ


Ïà¹ØÎÊ´ð£º

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý

accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í  ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......

¹ØÓÚaccessÊý¾Ý¿âÁ¬½Ó¾ø¶Ô·¾¶µÄÎÊÌâÇó½â

Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ


Microsoft O ......

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

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

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


н¨µÄWordºÍÒÑÓеÄWordµÄ´úÂë¿Ï¶¨ÊDz»Ò»ÑùµÄ
ÕâµãLZ»¹ÐèÒªÖ¸Ã÷
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ