Çó¸ßÊÖÖ¸µã£¬Ò»¸öPDA³ÌÐò£¬sqliteÊý¾Ý¿âÁ¬½Ó²»ÉÏ£¬¼±
string ConStr="data source=C:\ceshi.db;verson=3;password=123456"; SQLiteConnection MyConnection = new SQLiteConnection(ConStr); try { MyConnection.Open(); MessageBox.Show("OK"); using (SQLiteCommand SQLCom = new SQLiteCommand(MyConnection)) { string strSQL = @"SELECT num from ceshi;"; SQLCom.CommandText = strSQL; SQLiteDataReader SQLReader = SQLCom.ExecuteReader(); while (SQLReader.NextResult() != false) { this.label1.Text = SQLReader["num"].ToString(); } } MyConnection.Close(); } catch (Exception err) { throw err; }
·¾¶²»¶Ô°É¡£ string ConStr="data source=C:\ceshi.db;verson=3;password=123456"; PDAÉϲ»´æÔÚÀàËÆC£º\Õâ¶«¶«°É¡£ÒýÓà ·¾¶²»¶Ô°É¡£ string ConStr="data source=C:\ceshi.db;verson=3;password=123456&
Ïà¹ØÎÊ´ð£º
.netµÄ³ÌÐò£¬ÓõÄSystem.Data.SQLite DLL ¿âÊÇdb3µÄ£¬²éѯʱ×Ü˵no table ** ·¾¶Ò²ÊÇ¶ÔµÄ ¶øÄǸötableÊÇ´æÔÚµÄ ÔÚPCÉÏÄÜ¿´µ½ ÇëÎÊÕâ¸öÊÇÔõô»ØÊÂÄØ£¿ ÊÖ»úÉÏÎļþʱûÓÐÏà¶Ô·¾¶µÄ¸ÅÄîµÄ£¬ ±¨Ê²Ã ......
ÎÒÏÖÔÚÊÖÍ·ÓÐÕâôһ¸öÎÊÌ⣬ÎÒÏëÈÃÒ»¸ö²Ù×÷sqlite3µÄ³ÌÐòÔÚÒ»¸öARM°å×ÓÉÏÅÜÆðÀ´£¬°å×ÓÉϵÄosÊÇwince5.0¡£ ÎÒÊÇÕâô×öµÄ£¬ÎÒÏÈ´Ósqlite3Ö÷Ò³ÏÂÔØÔ´ÂëÏÂÀ´£¬ÓÐÕâô3¸öÎļþ£ºsqlite3.c¡¢sqlite3.h¡¢sqlite3ext.h £¬ ......
´ó¼ÒºÃ£º ×î½üÔÚwinceÏÂʹÓÃsqlite£¬µ«ÊÇÓÉÓÚ±íµÄÄÚÈÝÁ¿´ó£¬ËùÒÔ²éѯЧÂʺܵͣ¬²»ÖªµÀʲôÎÊÌâ¼°Ôõô½â¾ö¡£ ÎҵıíµÄ½á¹¹ÈçÏ£º name&nbs ......
ÔÚvs2005ÖÐÒýÓÃÁËusing System.Data.SQLite; ¶¨ÒåÁËÒ»¸öÁ¬Êý¾Ý¿âÁ¬½Ó±äÁ¿public SQLiteConnection dBConn; ¾Í±¨ÏÂÃæÕâ¸ö´íÎóÁË. The type 'System.Data.Common.DbConnection' is defined in an ass ......