Çë½ÌʹÓÃTree¿Ø¼þºÍSQLiteÊý¾Ý¿âµÄÎÊÌâ
ÎÒÏëÒª½«sqliteÊý¾Ý¿âÖеÄÊý¾Ý£¬ÒÔÊ÷¿Ø¼þµÄÐÎʽ¶Á³ö£¬²¢ÇÒÏÔʾÔÚ¶Ô»°¿òÉÏÃæ£¬²»ÖªµÀÔõô×ö£¬À´Çë½Ìһϡ£
ps£º¿´µ½ÓÐʹÓÃÊ÷¿Ø¼þºÍaccessµÄ£¬ÀïÃæÓÐÊý¾Ý¿âÒýÇæÀ´Á¬½ÓÊý¾Ý¿âºÍ³ÌÐò£¬ÎÒ²»ÖªµÀSQLiteÈçºÎÓë³ÌÐòÁ¬½ÓÆðÀ´
SQLiteÊÇ·ñ¿ÉÒÔÓÃADOÁ¬½Ó
¼ÈÈ»ÒѾ¿´µ½Á¬ACCESSµÄ£¬ÄÇôӦ¸ÃÉÔ×÷¸Ä¶¯¾Í¿ÉÒÔÁ˰ɡ£
Õâ¸ö¸úʹÓÃÄĸöÊý¾Ý¿âû¹ØÏµ°É?
¹Ø¼üÊÇÄã×Ô¼ºµÄ±í½á¹¹Éè¼ÆÒªºÏÀí
Ïà¹ØÎÊ´ð£º
C# code:
System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db");
try
{
conn.Open();
}
......
ÎÒÓÃsqliteadmin½¨ÁËÒ»¸öÊý¾Ý¿âtest.sdb,¿ÉÊÇÔõôҲ´ò²»¿ªÌáʾÈçÏ´íÎó£ºFile opened that is not a database file
file is encrypted or is not a database¡£
ÎÒµÄÁ¬½Ó×Ö·û´®ÈçÏÂÂ¥ÉϵĿɲ»¿ÉÒÔ°ïÎÒ¿´¿´
S ......
sqlite ²éѯijһÊý¾ÝËùÔÚµÄÐÐÊý£º
ÆäÖÐÊý¾Ý±íÖÐûÓÐרÃűêʶÌõÊýµÄË÷ÒýÖµ£¬ÎÒÃǸù¾ÝÆäËûһЩ×ֶβéÕÒµ½Á˸ÃÊý¾Ý£¬ÏÖÔÚÐèÒª·µ»Ø¸ÃÊý¾ÝËùÔÚµÄÐÐÊý¡£
ÆäÖÐsqlite manager ÖÐÓÐÒ»¸örowid£¬µ«ÊÇÕâ¸ö²¢ÎÞ·¨· ......
SqlServerÖÐÕâÑùͳ¼Æ:
select name from sysobjects where xtype='U'
ÒªÖªµÀ×ÜÊýµÄ»°¾Í¼òµ¥ÁË£º
select count(*) from sysobjects where xtype='U'
OracleÖÐÕâÑù²éѯ£º
Sele ......
sqliteÖÐÓÐûÓжÔÓÚÊý¾Ý¿â´óС½øÐйÜÀíµÄ½Ó¿Ú£¿±ÈÈ磬´´½¨Êý¾Ý¿âµÄʱºòÖ¸¶¨Êý¾Ý¿â´óС£¬¶ÔÊý¾Ý¿â½øÐвÙ×÷ºó²ì¿´¸ÃÊý¾Ý¿âÊ£ÓàµÄ¿ÉʹÓõĿռä´óСµÈ¡£×î½ü¿´ÁËÒ»ÏÂsqliteµÄÏà¹Ø½Ó¿Ú£¬ÍøÉÏÒ²ËÑË÷ÁËÏ£¬Ã»ÓÐÕÒµ½ÓÐÓõÄ×Ê ......