ÈçºÎ½«±äÁ¿ÖеÄÊý¾Ý´æ´¢µ½SQLiteÊý¾Ý¿âÖÐ
mdb.execDML(L"insert into faultcode values('stu.szNumber', 'stu.szName','stu.szReason', 'stu.szStep')");
ÎÒÏë°Ñ½á¹¹Ìå±äÁ¿stu.szNumberÖеÄÄÚÈÝ´æ´¢µ½Êý¾Ý¿âÖУ¬ÎÒµÄinsert into Óï¾äÓÐÎÊÌ⣬¿ÉÊÇÎÒ²»ÖªµÀÔõôÐ޸ģ¿
¸ßÊÖÖ¸µãÖ¸µã
лл ½â¾öÁË ~~~
Ïà¹ØÎÊ´ð£º
¸üÐÂÓï¾äÖУº
UPDATE sc SET AA=INT(BB)
ÎÒÏëÈÃAAµÃµ½BBµÄÕûÊýÖµ¡£¿ÉÊÇÔËÐб¨´í¡£
²»ÖªµÀSQLiteÏ ȡÕûÊý²¿·ÖµÄº¯ÊýÊÇÄĸö£¿£¨ËÄÉáÎåÈëµÄº¯ÊýÓÖÊÇÄĸö£¿£©¡£
Èç¹ûÖªµÀ»¹ÓÐÆäËûº¯ÊýÇëÒ»²¢¸æÖª£¬Ð»Ð»¡£
ROUND
......
ÒªÔÚlinuxÉÏʹÓÃsqliteÊDz»ÊÇÒªÏȱàÒë°²×°£¿Ôõô°²×°£¿
c#+sqlite+linuxµÄÏà¹ØÓ¦ÓÃÓÐûÓÐһЩÏà¹Ø×ÊÁÏ£¿
linux ÉÏÄÜÔËÐУ㣡¡?
Äã¿ÉÒÔÏÂÔØ±àÒëºÃµÄ£¬Ò²¿ÉÒÔÏÂÔØÔ´´úÂëÔÙ×Ô¼º±àÒë
http://www.sqlite.org/downl ......
¹ØÓÚjuliandayº¯ÊýµÄÎÊÌ⣬ÎÒÏÖÔÚ±íAÖÐÒ»¸ö×Ö¶Îbʱ¼äÀàÐÍ£¬ÈçºÎbΪ½ñÌìµÄÊý¾Ý£¿Ð»Ð»
select * from ±íÃû where datediff(d,getdate(),×Ö¶Îb)=0 ÕâÑùÄã¿´Ðв»£¿
ÎÒÓõÄÊÇsqliteÊý¾Ý¿â£¬Ëü²»Ö§³ÖdatediffµÄ¡ ......
±ÈÈ磺
1¡¢Á¬½ÓÊý¾Ý¿â£»
2¡¢½¨±í£¬insert ¡¢update,delete,selectÈçºÎд£¿
ÊDz»ÊÇÒªÏÂÔØ ADO.NET 2.0 ÒýÇæ£¿
sqliteʹÓÃÊÖ²á
ллqshurufa£¬ÎÒÏëÖªµÀÈçºÎͨ¹ývb.netʵÏÖ£¬¾ÍÊÇÓï¾äզд£¿
Dim Conn As New ......
ÇëÎʸ÷λ´ó¸ç,ËÓÐÉú³É·ÃÎÊsqliteÊý¾Ý¿âµÄ´úÂëÉú³ÉÆ÷,·üÍû´ó¼Ò°ïæ...
СµÜ¼±ÓÃ
wuyq11
(ÈËÉúÈçÃÎ) ÄúºÃ,wuyq11
UcfarDBAÊÇÔõôʹÓõÄ,СµÜ¿´µ½ÀïÃæÖ»ÓÐcstÎļþ,Ó¦¸ÃÊÇÄ£°å,ÕâЩģ°åÒªÔõÃ´Ê ......