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

Çë½ÌʹÓÃTree¿Ø¼þºÍSQLiteÊý¾Ý¿âµÄÎÊÌâ

ÎÒÏëÒª½«sqliteÊý¾Ý¿âÖеÄÊý¾Ý£¬ÒÔÊ÷¿Ø¼þµÄÐÎʽ¶Á³ö£¬²¢ÇÒÏÔʾÔÚ¶Ô»°¿òÉÏÃæ£¬²»ÖªµÀÔõô×ö£¬À´Çë½Ìһϡ£
ps£º¿´µ½ÓÐʹÓÃÊ÷¿Ø¼þºÍaccessµÄ£¬ÀïÃæÓÐÊý¾Ý¿âÒýÇæÀ´Á¬½ÓÊý¾Ý¿âºÍ³ÌÐò£¬ÎÒ²»ÖªµÀSQLiteÈçºÎÓë³ÌÐòÁ¬½ÓÆðÀ´
SQLiteÊÇ·ñ¿ÉÒÔÓÃADOÁ¬½Ó
¼ÈÈ»ÒѾ­¿´µ½Á¬ACCESSµÄ£¬ÄÇôӦ¸ÃÉÔ×÷¸Ä¶¯¾Í¿ÉÒÔÁ˰ɡ£

Õâ¸ö¸úʹÓÃÄĸöÊý¾Ý¿âû¹ØÏµ°É?
¹Ø¼üÊÇÄã×Ô¼ºµÄ±í½á¹¹Éè¼ÆÒªºÏÀí


Ïà¹ØÎÊ´ð£º

ʹÓ÷ÉÐÅÐéÄâ.net»·¾³£¬ÔÚʹÓÃSQLiteʱΪʲô±¨´íÄØ

C# code:

System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db");
try
{
conn.Open();
}
......

ÈçºÎö¾ÙsqliteÖеÄËùÓÐ±í¼°Æä×ֶΣ¿£¿

ÎÒÓÐÒ»·ÝsqliteÊý¾Ý¿âÎļþ£¬µ«²»ÖªµÀÀïÃæµÄ±íÃû£¬ÈçºÎö¾Ù³öËùÓеıíÃûÒÔ¼°Æä×Ö¶ÎÃû£¿£¿

¹Ø¼üÊÇsqliteµÄsqlÓï¾äÈçºÎд£¿ÎÒÊÔÁËһЩsqlÓï¾ä²»ÐУ¬ÌØÀ´ÇóÖú¡£

×Ö¶ÎÃû¡¡ÔòÎÞ·¨Ïó±íÃûÒ»Ñù´ÓÊý¾Ý¿âϵͳ±íÖÐÖ±½Ó ......

c#Á¬½ÓSqliteÊý¾Ý¿âÎÊÌâ

ÎÒÓÃsqliteadmin½¨ÁËÒ»¸öÊý¾Ý¿âtest.sdb,¿ÉÊÇÔõôҲ´ò²»¿ªÌáʾÈçÏ´íÎó£ºFile opened that is not a database file
file is encrypted or is not a database¡£

ÎÒµÄÁ¬½Ó×Ö·û´®ÈçÏÂÂ¥ÉϵĿɲ»¿ÉÒÔ°ïÎÒ¿´¿´
S ......

sqlite£¬updateµÄÎÊÌâ

ÎÒÏë×öÒ»¸ösqliteµÄ¼à¿ØÈí¼þ£¬ÊµÊ±ÖªµÀÓû§¶ÔÊý¾Ý±í¶¼×öÁËÄÄЩ²Ù×÷¡£

ÔÚÓû§update Ò»¸öÓû§Êý¾Ý±íֵʱ£¬ÎÒÈçºÎ¿ÉÒÔµÃÖªÓû§updateµÄÄĸö×ֶεÄÖµ£¿ÎÒ±¾À´¸øÓû§±íÌí¼Ó´¥·¢Æ÷À´ÊµÏֵ쬵«´¥·¢Æ÷ºÃÏñÖ»Äܵõ½Ó ......

sqliteÔÚvs2005ÖеÄʹÓñ¨´í

ÔÚvs2005ÖÐÒýÓÃÁËusing System.Data.SQLite;
¶¨ÒåÁËÒ»¸öÁ¬Êý¾Ý¿âÁ¬½Ó±äÁ¿public SQLiteConnection dBConn;
¾Í±¨ÏÂÃæÕâ¸ö´íÎóÁË.
The type 'System.Data.Common.DbConnection' is defined in an ass ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ