Óа취ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔ²Ù×÷sqliteÊý¾Ý¿âÂð£¿
visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆձ鶼ÊÇÕâÑùÂð£¿ËÓнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..
1¥ȷÈÏ¿ÉÒÔÔÚÄ£ÄâÆ÷É϶ÁдsqliteÊý¾Ý¿â£¿ÎÒÕâÀïÔõô²»¿ÉÒÔ¡¡£¨wm5µÄÄ£ÄâÆ÷£©£¬Èç¹û·½±ã£¬ÄܸøÏÂÏà¹Ø´úÂë»ò¸æÖªsqliteµÄ°æ±¾Âð£¿
ÎÒÔÚÂÛ̳ÀïËѵ½1¸ö05ÄêµÄÌû×Ó£¬Í¬ÑùµÄÎÊÌ⣬»Ø¸´Õß˵sqliteÎÞ·¨ÔËÐÐÔÚÄ£ÄâÆ÷ÉÏ¡£
ÎÒÓõľÍÊÇSQlite3 £¬Ã»²â¹ýWM5,·´ÕýÔÚWM6.0µÄÄ£ÄâÆ÷ÉÏÊÇ¿ÉÒÔÓõġ£
ÓпÉÄܵͰ汾µÄWM²»Ö§³Ö..
¿ÉÒԵģ¬ÔÚWM6.0 Professionalƽ̨¿ÉÒÔÁ¬½ÓSQLiteÊý¾Ý¿â
DLL°æ±¾ÊÇ1.0.64.0
Äã³öÏÖµÄÎÊÌâÊÇʲô£¿
¿ÉÒÔupdate£¬²»ÄÜselect
·¾¶ÔÚ%CSIDL_PROGRAM_FILES%ÏÂ
»òÕß´ó¼ÒÄÜÍƼö¸öwmÏÂÄÜÓõÄsqlite·â×°Âð£¿Ô´´ºÃÓõÄÒ²³É£¬Ö±½ÓÌù´úÂë»òemail me
ÒѾ¸ã¶¨£¬Ò»¸öÊèºöµ¼Öµģ¬¸Ðл»Ø¸´¡£
Ïà¹ØÎÊ´ð£º
string ConStr="data source=C:\ceshi.db;verson=3;password=123456";
SQLiteConnection MyConnection = new SQLiteConnection(ConStr);
try
{ ......
ÎÒÏëÔÚpdaÉÏÓÃSQLiteÊý¾Ý¿â£¬ÎÒ³ÌÐòÊÇqtдµÄ£¬µ«ÊÇÎÒÓ¦¸ÃÔõÑù½«SQLiteÒÆÖ²µ½winceƽ̨ÉÏÄØ£¬ÎÒÏÖÔÚÓÐÁËSQLite.dllºÍSQLite.lib£¬Ö®ºóÎÒ½»²æ±àÒëÉú³ÉÁË.exeÎļþ£¬ÎªÊ²Ã´ÔÚÄ£ÄâÆ÷Éϲ»ÄÜÔËÐÐÄØ£¿
ÆÚ´ýןßÊֻشð£¬Ð»Ð» ......
ÎÒ°²×°ÁËÒ»¸ösqlite developer,Ò»¸ö¿ÉÊÓ»¯µÄ¹¤¾ß¡£
½Ó×Å£¬ÎÒÓÖ°²×°ÁËSQLite.NET,²¢ÔÚVSÀïÃæÌí¼ÓºÃÁËdll¡£
ÏÖÔÚ£¬ÎÒÔÚsqlite developerÀï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬¿âÖаüº¬ÎÒ×Ô¼º¶¨ÒåµÄÒ»ÕÅ±í¡£
ÎÊÌ⣺ÈçºÎÊ¹Ó ......
¹ØÓÚjuliandayº¯ÊýµÄÎÊÌ⣬ÎÒÏÖÔÚ±íAÖÐÒ»¸ö×Ö¶Îbʱ¼äÀàÐÍ£¬ÈçºÎbΪ½ñÌìµÄÊý¾Ý£¿Ð»Ð»
select * from ±íÃû where datediff(d,getdate(),×Ö¶Îb)=0 ÕâÑùÄã¿´Ðв»£¿
ÎÒÓõÄÊÇsqliteÊý¾Ý¿â£¬Ëü²»Ö§³ÖdatediffµÄ¡ ......
¸Õѧsqlite£¬´´½¨Á˸ö±í£¬Í˳ösqliteÓÖÖØдò¿ªºó£¬²éѯ˵ûÓÐÕâ¸ö±í¡£ÔõôÑù²ÅÄܱ£´æÕâ¸ö±íÄØ£¬windowsÏÂ
Ö±½ÓÔËÐÐsqlite3.exe,È»ºó¾Í¾ÍÖ±½Ócreate table TestÁË
Í˳ösqlite3.exe ÖØдò¿ª£¬select¾ÍÌáʾûÓÐÕâ ......