ʹÓ÷ÉÐÅÐéÄâ.net»·¾³£¬ÔÚʹÓÃSQLiteʱΪʲô±¨´íÄØ
C# code: System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db"); try { conn.Open(); } catch(Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { conn.Close(); } ÒÔÉÏ´úÂëÔÚ.net»·¾³ÏÂÔËÐÐûÓÐÎÊÌ⣬µ«ÊÇÔÚ·ÉÐÅÐéÄâ.net»·¾³Ï ¾Í±¨´í µ«ÊÇÎÒÆäËûµÄformÔÚ·ÉÐÅ»·¾³Ï²»±¨´í ·ÉÐÅÒ²ÊÇʹÓÃsqlite£¬°´Àí˵ËûµÄÐéÄâ»·¾³Ó¦¸ÃÖ§³Ösqlite°¡ System.Data.SQLite.dll ÎÒÒ²·Åµ½ÐéÄâĿ¼ÁË ÄÇλ´ó¸çÖªµÀÔÒò°¡
×Ö·û´®ÓдíÎó Ó¦¸ÃÊÇ C# code: conn.ConnectionString = "Data Source=" + Application.StartupPath.ToString() + "\\acs.db"; ÈçºÎʹÓ÷ÉÐŵÄÐéÄâ»·¾³°¡,ÊDz»ÊǾÍÄÜÍÑÀë.net¿ò¼ÜÁË?ÒýÓà ÈçºÎʹÓ÷ÉÐŵÄÐéÄâ»·¾³°¡,ÊDz»ÊǾÍÄÜÍÑÀë.net¿ò¼ÜÁË? ×ܵÄ˵À´Æäʵ²»Ë㣬ÍÑÀ룡£¡ System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db"); Õâ¸ö¶Ôô£¿ºÃÆæ¹ÖµÄÖµ ÊÔÊÔ Ôڲ˵¥ÀïÒýÓÃÒ»´ÎSystem.Data.SQLite.dl C# code {{----
Ïà¹ØÎÊ´ð£º
ÎÒÖªµÀ´ó¼Ò¶¼ËµÊÇ64λϵͳϲ»ÄÜÓÃ32λµÄsyste.sqlite.dll¡£Õâ¸öÎÒÒѾ»»ÁË VS2008ÖÐÔËÐж¼Ã»ÎÊÌ⣨ͬһϵͳÏ£© Ò»·Åµ½IISÖоͱ¨´í£º δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔØ¸ ......
ÒªÔÚlinuxÉÏʹÓÃsqliteÊDz»ÊÇÒªÏȱàÒë°²×°£¿Ôõô°²×°£¿ c#+sqlite+linuxµÄÏà¹ØÓ¦ÓÃÓÐûÓÐһЩÏà¹Ø×ÊÁÏ£¿ linux ÉÏÄÜÔËÐУ㣡¡? Äã¿ÉÒÔÏÂÔØ±àÒëºÃµÄ£¬Ò²¿ÉÒÔÏÂÔØÔ´´úÂëÔÙ×Ô¼º±àÒë http://www.sqlite.org/downl ......
Êý¾Ý¿âÖÐÓÐÒ»¸öusers±í¡£ create table users(name text, number text); Ñ»·²åÈëÒ»°ÙÌõ£¬²»Ê¹ÓÃÊÂÎñµÄ»°£¬ÔÚÎҵĻúÆ÷ÉÏÐèÒª6s¡£ ¶øÔÚÎÒÅóÓѵĻúÆ÷ÉÏÕâÑùµÄ²Ù×÷»¨·Ñ²»µ½1s¡£ ¿ÉÄÜÊÇÄÄ·½ÃæµÄÔÒòµ¼ ......
c# + sqlite ³ö´í£¡£¡£¡ File opened that is not a database file file is encrypted or is not a database ºÍÒÔǰһÑùµÄд£¬ÔõôÕâ´Î¾ÍÊDz»Ðа¡£¡£¡£¡ ÎÒ¿ì²»ÐÐÁË£¬´ó¼Ò°ï°ïÎÒ°¡£¡£¡£¡ ¼û¹ýһƪÎÄÕÂÊÇ˵Õâ¸ö
......
¸Õѧsqlite£¬´´½¨Á˸ö±í£¬Í˳ösqliteÓÖÖØÐ´ò¿ªºó£¬²éѯ˵ûÓÐÕâ¸ö±í¡£ÔõôÑù²ÅÄܱ£´æÕâ¸ö±íÄØ£¬windowsÏ ֱ½ÓÔËÐÐsqlite3.exe,È»ºó¾Í¾ÍÖ±½Ócreate table TestÁË Í˳ösqlite3.exe ÖØÐ´ò¿ª£¬select¾ÍÌáʾûÓÐÕâ ......