Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>

SQLITEÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>
SQLITEϲ»ºÃÓà
Ìáʾ: 
sqlite error 
no such function: stuff 
Ôõô½â¾ö?
SQL code:
--------------------------------------------- ......

sqlite ÎÞ·¨¸ù¾ÝGuid ²éѯÊý¾Ý

GUID£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7

SELECT fldGuid, fldName, fldUserGuid from table
Äܲéѯ fldUserGuid Ϊ£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7 µÄÊý¾ÝÒ»Ìõ

SELECT fldGuid, fldN ......

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

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

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

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

sqlite Îȶ¨,²¢·¢ÔõôÑù - .NET¼¼Êõ / ASP.NET

ÏÖÔÚÏë×öÒ»¸ö½øÏú´æ,¿ÉÄÜ»áÓÐ20ÈËͬʱһÆðÓÃ
²»ÖªµÀµ½ÊÇÑ¡Ôñ sqlite »¹ÊÇ access
´ó¼Ò¸ø¸øÒâ¼û°É
»¹ÊÇÓÃaccess°É£¬ÒòΪÄã¿Ï¶¨ÊÇÓÃ.net¿ª·¢£¬³öÁËʲôÎÊÌâµÄ»°ºÃ½â¾öһЩ¡£
Èç¹ûÓÃsqlite×ÊÁÏÏà¶Ô±È½ÏÉÙ¡£
²»¹ýÌý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ