ʹÓ÷ÉÐÅÐéÄâ.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¿ò¼ÜÁË?
×ܵÄ˵À´Æäʵ²»Ë㣬ÍÑÀ룡£¡
System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db");
Õâ¸ö¶Ôô£¿ºÃÆæ¹ÖµÄÖµ
ÊÔÊÔ
Ôڲ˵¥ÀïÒýÓÃÒ»´ÎSystem.Data.SQLite.dl
C# code
{{----
Ïà¹ØÎÊ´ð£º
string ConStr="data source=C:\ceshi.db;verson=3;password=123456";
SQLiteConnection MyConnection = new SQLiteConnection(ConStr);
try
{ ......
¸üÐÂÓï¾äÖУº
UPDATE sc SET AA=INT(BB)
ÎÒÏëÈÃAAµÃµ½BBµÄÕûÊýÖµ¡£¿ÉÊÇÔËÐб¨´í¡£
²»ÖªµÀSQLiteÏ ȡÕûÊý²¿·ÖµÄº¯ÊýÊÇÄĸö£¿£¨ËÄÉáÎåÈëµÄº¯ÊýÓÖÊÇÄĸö£¿£©¡£
Èç¹ûÖªµÀ»¹ÓÐÆäËûº¯ÊýÇëÒ»²¢¸æÖª£¬Ð»Ð»¡£
ROUND
......
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼ ......
ÊÖÍ·ÓÐÒ»¸öСCASE£¬ÒªÓõ½Êý¾Ý¿â£¬Ïë²ÉÓÃSQLite¡£
ÓÐÓùýµÄÅóÓÑÂð£¿
ÒªÔõô°²×°sqlite·þÎñ£¿»¹ÊDz»ÐèÒª°²×°£¿
ÓÃʲôÈí¼þÀ´¹ÜÀíSqliteÊý¾Ý¿â£¿ÈçÌí¼Ó±í£¬Ð´´æ´¢¹ý³ÌµÈ¡£
delphiÖÐÔõôÑùÁ¬½Óµ½sqliteÊý¾Ý¿â£¿ÓÃʲ ......
±ÈÈ磺
1¡¢Á¬½ÓÊý¾Ý¿â£»
2¡¢½¨±í£¬insert ¡¢update,delete,selectÈçºÎд£¿
ÊDz»ÊÇÒªÏÂÔØ ADO.NET 2.0 ÒýÇæ£¿
sqliteʹÓÃÊÖ²á
ллqshurufa£¬ÎÒÏëÖªµÀÈçºÎͨ¹ývb.netʵÏÖ£¬¾ÍÊÇÓï¾äզд£¿
Dim Conn As New ......