Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
  { ......

SQLiteÈ¡ÕûÊýº¯ÊýÊÇÄĸö£¿

¸üÐÂÓï¾äÖУº
UPDATE sc SET AA=INT(BB)
ÎÒÏëÈÃAAµÃµ½BBµÄÕûÊýÖµ¡£¿ÉÊÇÔËÐб¨´í¡£
²»ÖªµÀSQLiteÏ ȡÕûÊý²¿·ÖµÄº¯ÊýÊÇÄĸö£¿£¨ËÄÉáÎåÈëµÄº¯ÊýÓÖÊÇÄĸö£¿£©¡£
Èç¹ûÖªµÀ»¹ÓÐÆäËûº¯ÊýÇëÒ»²¢¸æÖª£¬Ð»Ð»¡£

ROUND
......

windowsץȡlinuxÉÏsqlite db問題

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

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ºÅ