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

¹ØÓÚ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];


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


Ïà¹ØÎÊ´ð£º

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

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

SQLiteÓа취͸¹ýÍøÂçÁ¬½ÓÂð?

ĿǰÔÚ¹«Ë¾µÄlinux pcÉÏÓÐÒ»¸öSQLite server, ÎÒÏëÓÃÔÚͬ¸öÇø網µ×ϵÄwin pcÈ¥Á¬½ÓSQLite serverÓÃASP進ÐвÙ×÷, ÇëÎÊÓа취°ìµ½Âð? »¹ÊÇSQLite serverÎÞ·¨Ö§³ÖÍøÂçÁ¬½Ó....ÕÒÁËÒ»¸öÏÂÎç


剛 ......

ÓÖÀ´ÎÊ´ó´óÃÇÁË£¬»¹ÊǹØÓÚsqliteµÄÎÊÌâ

ÎÒÏÖÔÚÓÐÁ½¸ö±í
µÚÒ»¸ö±íΪ
id          title      content   
1          34234        234234
......

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



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