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

Çë½ÌsqliteÊý¾Ý¿âÖÐÎÄÂÒÂëµÄÎÊÌâ

¿ª·¢ÓïÑÔ£ºevc
Êý¾Ý¿â£ºSQLite
˵Ã÷£ºÓÐÁ½¸ö½çÃæ
½çÃæÒ»¸öÊÇÓÃÀ´½¨Á¢Êý¾Ý¿â£¬²¢ÇÒ½øÐÐÊý¾Ý¹ÜÀí¹¦ÄÜ£¬°üÀ¨ctrlist¿Ø¼þÏÔʾÊý¾Ý¿âÄÚÈÝ£¬Ôö¼Ó£¬É¾³ý£¬Ð޸ĵȹ¦ÄÜ£»
½çÃæ¶þ£¬Êǵ÷ÓÃÊý¾Ý¿â£¬½øÐвéѯ£¬ÏÔʾ½á¹ûÏÔʾÔÚEDIT¿Ø¼þÖС£

1£©ÔÚÄ£ÄâÆ÷ÖУ¬´´½¨Êý¾Ý¿â£¬½øÐвåÈëÊý¾Ý£¬¿ÉÒÔÔÚctrlist¿Ø¼þÖÐÕý³£ÏÔʾ£¬Ìí¼Ó£¬É¾³ý£¬¶¼¿ÉÒÔʹÓ㬵«ÊǽçÃæ¶þµÄ³ÌÐòʹÓÃÊý¾Ý¿âµÄʱºò£¬²»Äܳɹ¦£¬ÎÒÊÇʹÓÃSQLite Expert Personal´ò¿ª½¨Á¢µÄÊý¾Ý¿âµÄʱºò£¬·¢ÏÖÊý¾Ý¿â¶¼ÊÇÂÒÂ룬¡£

2£©Èç¹ûʹÓÃSQLite Expert Personal½¨Á¢Êý¾Ý¿â£¬½çÃæ¶þµÄ³ÌÐò¿ÉÒÔÕýȷʹÓÃÊý¾Ý¿â£¬µ«ÊÇÔÚ½çÃæÒ»ctrlistÖУ¬ÏÔʾÂÒÂ룬ÎÞ·¨¶ÔÊý¾Ý½øÐÐÐ޸ġ¢É¾³ý¡¢Ìí¼ÓµÈ²Ù×÷¡£

Çë½Ì£¬Õâ¸öÎÊÌâÔõÑù½â¾öÄØ£¿
ÓÐһЩ½øÕ¹£¬ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éѯÊý¾Ý¿â£¬ÏÔʾ¿Ø¼þÉÏ£¬³öÏÖÁËÖÐÎÄÂÒÂëµÄÎÊÌ⣬¼ÌÐøÇë½Ì¡«


ÒýÓÃ
list control ¿Ø¼þ ÖйÀ¼ÆÐèÒª´¦ÀíÒ»ÏÂ×Ö·û¼¯¡£
SQLiteÖеĺº×ÖÐèÒªÓÃUTF×Ö·û¼¯¡£

ÇëÎÊÒªÔõÑù´¦ÀíÄØ £¿ÕâÁ½ÌìÒ»Ö±Ôڲ飬ûÓÐÕÒµ½ºÃµÄ½â¾ö°ì·¨

ÒýÓÃ
list control ¿Ø¼þ ÖйÀ¼ÆÐèÒª´¦ÀíÒ»ÏÂ×Ö·û¼¯¡£
SQLiteÖеĺº×ÖÐèÒªÓÃUTF×Ö·û¼¯¡£

list control  ÓÃʲô×Ö·û¼¯ÄØ£¿

ÒýÓÃ
list control ¿Ø¼þ ÖйÀ¼ÆÐèÒª´¦ÀíÒ»ÏÂ×Ö·û¼¯¡£
SQLiteÖеĺº×ÖÐèÒªÓÃUTF×Ö·û¼¯¡£


ÎÒÈ·¶¨ÁË´íÎóµÄµØ·½£¬¾ÍÊÇÔÚ¶ÁÊý¾Ý¿âÊý¾Ý£¨UTF-8£©ÏÔʾÔÚlist control¿Ø¼þÊÇ£¬


Ïà¹ØÎÊ´ð£º

Çó¸ßÊÖÖ¸µã£¬Ò»¸öPDA³ÌÐò£¬sqliteÊý¾Ý¿âÁ¬½Ó²»ÉÏ£¬¼±

string ConStr="data source=C:\ceshi.db;verson=3;password=123456";
  SQLiteConnection MyConnection = new SQLiteConnection(ConStr);
  try
  { ......

Çë½Ì£ºVCÖеÄTree¿Ø¼þÓëSQLiteÊý¾Ý±íµÄʹÓÃÎÊÌâ

ÎÒÒª°ÑÊý¾Ý±íÖеÄÊý¾Ý£¬ÒÔÊ÷µÄÐÎʽÏÔʾÔÚ¶Ô»°¿òÖС£
±ÈÈ磺
Ö»ÒªÊý¾Ý±íÖÐÓÐ3¸ö×ֶΡ¢id¡¢parentid¡¢name
ÇëÎÊÎÒÈçºÎдһЩ´úÂ뽫Êý¾Ý±íÖеÄÄÚÈÝÌîµ½Ê÷¿Ø¼þÖÐÈ¥ 

ÒýÓÃ
Ò»°ãÊÇÓõݹéµÄ·½·¨À´ÊµÏ ......

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

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


剛 ......

sqlite ×Ö¶ÎĬÈÏÖµµÈÓÚidÖµ

sqlite ÖÐ
CREATE TABLE table1 (
id integer primary key autoincrement,
name text default '',
[index] integer default ROWID
)

ÓÐûÓÐÀàËÆµÄ¹¦ÄÜ£¬Èà index µÄֵĬÈϵÈÓÚid£¬ ......

C# Á¬½Ó Sqlite ÊÂÎñµÄÎÊÌâ

// ´ò¿ªÊý¾Ý¿â
SQLiteConnection dconn = new System.Data.SQLite.SQLiteConnection();
dconn.ConnectionString = @"Data Source=D:\db.sdb";
dconn.Open();
SQLiteCommand dcmd = dconn.Crea ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ