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

СÃÃÇë½Ì¸÷λǰ±²AccessÀï»òÕßÓï¾äÓ¦¸ÃÔõôд£¡

AccessÀïÎÒÏë×öÒ»¸ö»òÕßµÄSQLÓï¾ä£¬Ó¦¸ÃÔõôд
ÎÒд¸ö´ó¸ÅÒâ˼µÄÓï¾ä¡£

select * from ttbaom where passed='true' and progaram = '»áÔ±' or progaram = '·Ç»áÔ±' or progaram='°æÖ÷' and
company like '*ÕÅÈý*'

´ó¸ÅÕâ¸öÒâ˼°É£¡Çë¸÷λǰ±²À´Ö¸Õý¡£
Ìù¼Ç¼¼°ÒªÇó½á¹û³öÀ´¿´¿´

Õâ¾Í°ÑËùÓеļǼ¶¼ÏÔʾ³öÀ´ÁË£¡

¼Ç¼ÊÇÕâÑùµÄ£¡
id passed progaram company
1  true  »áÔ±      ÕÅÈý
2  true  »áÔ±      ÀîËÄ
3  true  ·Ç»áÔ±    ÍõÎå
4  true  °æÖ÷      ÀîÁù


ûÓÐǰ±²Ö¸½ÌÂð£¿

4Â¥µÄ´úÂëÓ¦¸Ã¿ÉÒÔÁË


Ïà¹ØÎÊ´ð£º

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

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

¸ßÈ˽ø £¡£¡access Êý¾Ý¿âÎÊÌâ~~

±í½á¹¹£º
ProductSeriesID ×Ô¶¯±àºÅ
ProductSeriesName Îı¾
ProductSeriesRemark ±¸×¢

Ö´ÐÐǰ
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉá ......

DbgridÁ¬½ÓaccessÍ϶¯¹ö¶¯ÌõËÀ»ú£¿

DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿

ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿

Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£

ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......

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

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