Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ʹÓ÷ÉÐÅÐéÄâ.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
{{----


Ïà¹ØÎÊ´ð£º

sqlite ¸ßÊÖ½øÀ´°¡

СµÜ Ūµã¶«Î÷¿ÉÊǵ÷Óà sqlite3_prepare Õâ¸öº¯Êý select ¾ÍºÃʹ Ö»Òª ¸Ä±äÊý¾Ý¿â µÄ¾Í²»ÐÐ ±ÈÈçinsert Ö®ÀàµÄ Ë­À´°ï¸öæ°¡ ÇëÎÊÕâÊÇʲôԭÒò °¡ Óà c ȥʵÏÖµÄ
ÄãÓõÄʲô¹¤¾ß°¡?
°ÑÄã×Ô¼ºµÄ´úÂë·¢ ......

SQLiteÈ¡ÕûÊýº¯ÊýÊÇÄĸö£¿

¸üÐÂÓï¾äÖУº
UPDATE sc SET AA=INT(BB)
ÎÒÏëÈÃAAµÃµ½BBµÄÕûÊýÖµ¡£¿ÉÊÇÔËÐб¨´í¡£
²»ÖªµÀSQLiteÏ ȡÕûÊý²¿·ÖµÄº¯ÊýÊÇÄĸö£¿£¨ËÄÉáÎåÈëµÄº¯ÊýÓÖÊÇÄĸö£¿£©¡£
Èç¹ûÖªµÀ»¹ÓÐÆäËûº¯ÊýÇëÒ»²¢¸æÖª£¬Ð»Ð»¡£

ROUND
......

SQLiteÖÐÎÄÂÒÂëÎÊÌâ

ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......

¹ØÓÚsqliteÖ´ÐÐʱ¼äµÄÒÉÎÊ£¿

Êý¾Ý¿âÖÐÓÐÒ»¸öusers±í¡£
create table users(name text, number text);
Ñ­»·²åÈëÒ»°ÙÌõ£¬²»Ê¹ÓÃÊÂÎñµÄ»°£¬ÔÚÎҵĻúÆ÷ÉÏÐèÒª6s¡£ 
¶øÔÚÎÒÅóÓѵĻúÆ÷ÉÏÕâÑùµÄ²Ù×÷»¨·Ñ²»µ½1s¡£ 
¿ÉÄÜÊÇÄÄ·½ÃæµÄÔ­Òòµ¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ