Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
{{----


Ïà¹ØÎÊ´ð£º

Çó¸ßÊÖÖ¸µã£¬Ò»¸öPDA³ÌÐò£¬sqliteÊý¾Ý¿âÁ¬½Ó²»ÉÏ£¬¼±

string ConStr="data source=C:\ceshi.db;verson=3;password=123456";
  SQLiteConnection MyConnection = new SQLiteConnection(ConStr);
  try
  { ......

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

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

ROUND
......

Win7ÏÂIIS·ÃÎÊSqliteÊý¾Ý¿â±¨´í

ÎÒÖªµÀ´ó¼Ò¶¼ËµÊÇ64λϵͳϲ»ÄÜÓÃ32λµÄsyste.sqlite.dll¡£Õâ¸öÎÒÒѾ­»»ÁË
VS2008ÖÐÔËÐж¼Ã»ÎÊÌ⣨ͬһϵͳÏ£©
Ò»·Åµ½IISÖоͱ¨´í£º
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔظ ......

delphi ÔõôÑùʹÓÃsqliteÊý¾Ý¿â£¿

ÊÖÍ·ÓÐÒ»¸öСCASE£¬ÒªÓõ½Êý¾Ý¿â£¬Ïë²ÉÓÃSQLite¡£
ÓÐÓùýµÄÅóÓÑÂð£¿
ÒªÔõô°²×°sqlite·þÎñ£¿»¹ÊDz»ÐèÒª°²×°£¿
ÓÃʲôÈí¼þÀ´¹ÜÀíSqliteÊý¾Ý¿â£¿ÈçÌí¼Ó±í£¬Ð´´æ´¢¹ý³ÌµÈ¡£
delphiÖÐÔõôÑùÁ¬½Óµ½sqliteÊý¾Ý¿â£¿ÓÃʲ ......

Çë½ÌÒ»¸ö¹ØÓÚSqliteÊý¾Ý¿âµÄÎÊÌâ

¹ØÓÚjuliandayº¯ÊýµÄÎÊÌ⣬ÎÒÏÖÔÚ±íAÖÐÒ»¸ö×Ö¶Îbʱ¼äÀàÐÍ£¬ÈçºÎbΪ½ñÌìµÄÊý¾Ý£¿Ð»Ð»

select * from ±íÃû where datediff(d,getdate(),×Ö¶Îb)=0 ÕâÑùÄã¿´Ðв»£¿

ÎÒÓõÄÊÇsqliteÊý¾Ý¿â£¬Ëü²»Ö§³ÖdatediffµÄ¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ