ÓÐûÓкõĿªÔ´cmsϵͳ֧³ÖaccessÊý¾Ý¿â£¿
·þÎñÆ÷Ö§³ÖphpºÍaccess£¬mysqlÁíÍâÂò£¬ÓÐûÓкõãµÄ¿ªÔ´cmsϵͳÓÃaccessÊý¾Ý¿âµÄ£¿
»»aspÁË
¿ÉÒÔʹÓÃsqlite3
queryphp ¼òµ¥ MVC ORM¿ò¼Ü
---------------------------------------------
http://topic.csdn.net/u/20100310/11/62a60067-b3da-4dee-9d6a-f1baeb2f3f33.html
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
ÎÒÔÚaccessÖд´½¨Ò»¸ö±í..ÎÒÔõô»ñÈ¡ËûµÄ´´½¨Óï¾ä..
ÎÒÖ÷ÒªÊÇÏë»ñÈ¡ËûµÄ´´½¨Óï¾äÓÃÓÚCMSµÄ°²×° »òÕßÔÚsqlserverÖа²×°ÓÃÓÃ..
VB code:
CreateDatabase Method Example
This example uses CreateDatabase to ......