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

.net·ÃÎÊSQLiteÎÊÌâ

ÎÒ°²×°ÁËÒ»¸ösqlite developer,Ò»¸ö¿ÉÊÓ»¯µÄ¹¤¾ß¡£
½Ó×Å£¬ÎÒÓÖ°²×°ÁËSQLite.NET,²¢ÔÚVSÀïÃæÌí¼ÓºÃÁËdll¡£
ÏÖÔÚ£¬ÎÒÔÚsqlite developerÀï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬¿âÖаüº¬ÎÒ×Ô¼º¶¨ÒåµÄÒ»ÕÅ±í¡£

ÎÊÌ⣺ÈçºÎʹÓÃVS²é¿´ÎÒÔÚsqlite developerÖд´½¨µÄ±í¡£
ºÜ¼±°¡£¬Ë­Äܽâ¾öһϣ¿

SQLiteConnection cnn = new SQLiteConnection();
            cnn.ConnectionString = @"Data Source=C:\Program Files\SharpPlus\SqliteDev\myFirstDB";
            cnn.Open();

            SQLiteCommand cmd = new SQLiteCommand();
            cmd.Connection = cnn;

            cmd.CommandText = "select * from maintable";
            SQLiteDataAdapter da = new SQLiteDataAdapter();
            da.SelectCommand = cmd;
            DataSet ds = new DataSet();
            da.Fill(ds);
            this.dataGridView1.DataSource = ds.Tables[0];


»¹Êǵÿ¿×Ô¼º°¡£¡£¡£¡£¡£¡


ÓеÄʱºòGoogleһϱÈÔÚÕâÀïµÈÒª¿ì£¬ºÇºÇ


Ëû˵̫³¤ÁË¡£¡£¡£¿¿£¬Ö»ÄÜ·ÖÁ½¶Î
C# code



Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlight


Ïà¹ØÎÊ´ð£º

ÊìϤSqliteµÄÇë½øÀ´£¡£¡£¡£¡£¡

´ó¼ÒºÃ£¡
  sqlite×Ö¶ÎΪfloatÐ͵ÄÖµÔõÑù·ÃÎÊ£¿
ÊÔ¹ýÓÃsqlite3_column_double£¬È··µ»ØµÄÊý¾Ý²»ÕýÈ·£»
ûÓùý,°ï¶¥.

Ò»Ñù°¡£¬·µ»ØÈ«ÊÇ string

ÄãµÄ´úÂëÊÇʲô£¿
double sqlite3_column_double(sqli ......

windowsץȡlinuxÉÏsqlite db問題

´ó¼ÒºÃ, ÉÏÀñ°ÝÓÐÀ´ÎÊ˵ÈçºÎ´ÓlinuxÉÏ·ÖÏí³ösqliteµÄdbÊý¾ÝÈÃwindows²Ù×÷, ºóÀ´Ò»Ö±ÎÞ·¨Ö±½Ó͸¹ýip·½Ê½Äõ½µµ°¸, Ïë˵¸ÄÓÃftp·½Ê½¶ÁµµÐ´Èëºó, ÔÙÉÏ´«»Ølinux server, ÏÖÔÚÓиöÎÊÌâµ±win pc¿ªÆôdbµµ°¸ºó, ºÃÏñ»áËø×¡Ë ......

ÔÚÏßµÈ,¹ØÓÚmysqlÓï¾äתsqliteÓï¾äµÄÎÊÌâ

SQL code:
SELECT a1.FileID AS FileID, SUM( a1.Count + a2.Count + a3.Count + a4.Count ) AS Count
from gmpTableWordList AS a1
INNER JOIN gmpTableWordList AS a2
INNER JOIN gmpTableWordList AS a3
IN ......

wince 5.0 ¿ª·¢sqliteÊý¾Ý¿âµÄÎÊÌâ



ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ