¹ØÓÚ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];
»¹Êǵÿ¿×Ô¼º°¡£¡£¡£¡£¡£¡
{{
Ïà¹ØÎÊ´ð£º
SQLITEÏÂÈçºÎɾ³ýÄÚÈÝÖеĵÚÒ»¸ö<br>
SQLITEϲ»ºÃÓÃ
Ìáʾ:
sqlite error
no such function: stuff
Ôõô½â¾ö?
SQL code:
--------------------------------------------- ......
sqlliteÀïÃæÓÐʲô·½·¨°Ñintת»»ÎªÊ®Áù½øÖÆ´æ´¢µÄÄØ?
ÀýÈç,strftime('%s', 'now') µÃµ½1263777947,µ±Ç°µÄÃëÊý,ÎÒÏë´æ´¢ÎªËüµÄÊ®Áù½øÖƱíʾ"4B53B89B"
лл..
ÆäʵÎÒÊÇÏëstrftime ......
¿ª·¢ÓïÑÔ£ºevc
Êý¾Ý¿â£ºSQLite
˵Ã÷£ºÓÐÁ½¸ö½çÃæ
½çÃæÒ»¸öÊÇÓÃÀ´½¨Á¢Êý¾Ý¿â£¬²¢ÇÒ½øÐÐÊý¾Ý¹ÜÀí¹¦ÄÜ£¬°üÀ¨ctrlist¿Ø¼þÏÔʾÊý¾Ý¿âÄÚÈÝ£¬Ôö¼Ó£¬É¾³ý£¬Ð޸ĵȹ¦ÄÜ£»
½çÃæ¶þ£¬Êǵ÷ÓÃÊý¾Ý¿â£¬½øÐвéѯ£¬ÏÔʾ½á ......
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......