.net+access ²éѯǰ5Ìõ¼Ç¼ Ϊʲôtop²»ÉúЧ
.net+access ²éѯǰ5Ìõ¼Ç¼ Ϊʲôtop²»ÉúЧ ×ÜÊDzéѯËùÓмǼ ¼±¡£¡£¡£
ÄãµÄÓï¾äÊÇʲô£¿ .
select top 10 * from goodsinfo where G_type=1 order by Registry_time desc
ÎÒ¿ÉÄÜû˵Çå³þ
select top 10 * from goodsinfo where G_type=1 order by Registry_time desc
±íÀïÓÐ20Ìõ¼Ç¼ ÎÒÏëÈ¡³öǰ10Ìõ¼Ç¼ ²»ÖªµÀaccessÊDz»ÊDz»Ö§³Ötop£¿
ŶŶ »ÐÈ»´óÎò ÎÒÊÔÊÔ ³É¹¦½áÌùлл
лл¹ûÈ»Èç´Ë ¸ø·Ö½áÌù
Ïà¹ØÎÊ´ð£º
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......