Çë½Ì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 ÓÃʲô×Ö·û¼¯ÄØ£¿
ÎÒÈ·¶¨ÁË´íÎóµÄµØ·½£¬¾ÍÊÇÔÚ¶ÁÊý¾Ý¿âÊý¾Ý£¨UTF-8£©ÏÔʾÔÚlist control¿Ø¼þÊÇ£¬
Ïà¹ØÎÊ´ð£º
string ConStr="data source=C:\ceshi.db;verson=3;password=123456";
SQLiteConnection MyConnection = new SQLiteConnection(ConStr);
try
{ ......
¸üÐÂÓï¾äÖУº
UPDATE sc SET AA=INT(BB)
ÎÒÏëÈÃAAµÃµ½BBµÄÕûÊýÖµ¡£¿ÉÊÇÔËÐб¨´í¡£
²»ÖªµÀSQLiteÏ ȡÕûÊý²¿·ÖµÄº¯ÊýÊÇÄĸö£¿£¨ËÄÉáÎåÈëµÄº¯ÊýÓÖÊÇÄĸö£¿£©¡£
Èç¹ûÖªµÀ»¹ÓÐÆäËûº¯ÊýÇëÒ»²¢¸æÖª£¬Ð»Ð»¡£
ROUND
......
´ó¼ÒºÃ, ÉÏÀñ°ÝÓÐÀ´ÎÊ˵ÈçºÎ´ÓlinuxÉÏ·ÖÏí³ösqliteµÄdbÊý¾ÝÈÃwindows²Ù×÷, ºóÀ´Ò»Ö±ÎÞ·¨Ö±½Ó͸¹ýip·½Ê½Äõ½µµ°¸, Ïë˵¸ÄÓÃftp·½Ê½¶ÁµµÐ´Èëºó, ÔÙÉÏ´«»Ølinux server, ÏÖÔÚÓиöÎÊÌâµ±win pc¿ªÆôdbµµ°¸ºó, ºÃÏñ»áËø×¡Ë ......
// ´ò¿ªÊý¾Ý¿â
SQLiteConnection dconn = new System.Data.SQLite.SQLiteConnection();
dconn.ConnectionString = @"Data Source=D:\db.sdb";
dconn.Open();
SQLiteCommand dcmd = dconn.Crea ......