SQLiteÊý¾Ý¿âÊʺϹ«Ë¾×öÍøÕ¾ÓÃÂð£¿
֮ǰ ¹«Ë¾×öÍøÕ¾Ê¹ÓõÄÊÇasp+access£¬ÏÖÔÚÒ²ÔÚʹÓÃsql server 2005 + asp.net £¬Ç°Õ߿϶¨Òª»»´ú£¬ºóÕßsql serverÌ«ÅÓ´óÁË£¬ËùÒÔÏë»»×öÆäËûµÄÊý¾Ý¿â£¬Ñ¡Ãâ·Ñ¿ªÔ´µÄÀàÐÍ£¬Ö»ÒªÂú×ãÆÕͨÆóÒµÐû´«ÐÍÍøÕ¾£¬ÏÖÔÚ ¿´µ½ÁËSQLite£¬ÇëÎÊËüÊʺÏÎÒÃǹ«Ë¾Âð£¿ÓÐûÓиüºÏÊʵģ¬MySQL¸÷·½ÃæÊʺÏÂð£¿Ð»Ð»¡£×îºÃÏêϸµã¡£
ºÏÊÊ
Ãâ·ÑµÄ¿ÉÒÔÑ¡SQL 2005 Express£¬¿ªÔ´µÄÆäʵûÓÐʲô±ØÒª£¬ÄãÓÖ²»ÊÇÒªÔÚÉÏÃæ½¨Á¢Ð©Ê²Ã´
ËüÓëSql Server ExpressÓï·¨ÉÏÇø±ð´óÂð£¿
¹Ø¼üÊÇSql server expressÌ«³ÔÄÚ´æÁË£¬ÎÒÃǹ«Ë¾ÉÏһ̨·þÎñÆ÷Óм¸°Ù¸öaspµÄÍøÕ¾°¡£¬ÅÜsql serverÅܲ»ÆðÀ´¡£
¿ÉÒÔʹÓÃ
µ«Óï·¨ÓëSQL SERVER»¹ÊÇÓв»Í¬µÄ
ACCESSÓëSQLiteÏà±È½ÏÄØ£¿
MySql²»ÊǺÜÊìϤ£¬ËüºÃÏñÊÇ»ùÓÚÒýÇæµÄ°É£¬²»Êǵ¥ÎļþµÄ¡£ÊÇÕâÑùµÄ°É£¿
Ïà¹ØÎÊ´ð£º
µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:
ºÅÂë(num) ÁªÏµÈË (relationname)
10086 ÒÆ ......
ÔõôÈÃsqliteÖ§³ÖÖÐÎÄ,˽â¾öÁ˾͸øËû100·Ö
ÄѵÀSQLITE²»Ö§³ÖÖÐÎÄÂ𣿣¿£¿£¿£¿£¿£¿£¿
¶ÁÈ¡³öÀ´Ê±ÂÒÂë
ÕâÑùÊÔÊÔ
C# code:
using System.Data;
using System.Data.SQLite;
//...
using (SQLiteConnec ......
ÇóVB6.0Á¬½ÓSqliteÊý¾Ý¿â¼°²éѯ´úÂ룬½â˵ԽÏêϸԽºÃ£¬ÒòΪÎÒ»¹Ã»ÓÐÓùýSQLite£¬Ð»Ð»£¡
Éϴζ¼²»¸øÎÒ·Ö¡£¡£
×¢²ásqltp30.dllÕâ¸öActiveX DLL
ÓÃÀïÃæµÄSQLiteDBÀཨÁ¢¡¢Á¬½ÓÊý¾Ý¿âÎļþ£¬¾ÍÏñADODBÀïµÄConnecti ......
visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆÕ±é¶¼ÊÇÕâÑùÂð£¿ËÓнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..
ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......
delphiÁ¬½ÓSqlite Ôöɾ¸Ä²éÀý×Ó
Êý¾Ý¿âÒѾÁ¬Í¨ÁË, ²åÈë»á±¨´í£¬no query specified
with dm.ASQLite3Query1 do
begin
dm.ASQLite3Query1.Close;
dm.ASQLite3 ......