SQLiteÊý¾Ý¿âÊʺϹ«Ë¾×öÍøÕ¾ÓÃÂð£¿
֮ǰ ¹«Ë¾×öÍøÕ¾Ê¹ÓõÄÊÇasp+access£¬ÏÖÔÚÒ²ÔÚʹÓÃsql server 2005 + asp.net £¬Ç°Õ߿϶¨Òª»»´ú£¬ºóÕßsql serverÌ«ÅÓ´óÁË£¬ËùÒÔÏë»»×öÆäËûµÄÊý¾Ý¿â£¬Ñ¡Ãâ·Ñ¿ªÔ´µÄÀàÐÍ£¬Ö»ÒªÂú×ãÆÕͨÆóÒµÐû´«ÐÍÍøÕ¾£¬ÏÖÔÚ ¿´µ½ÁËSQLite£¬ÇëÎÊËüÊʺÏÎÒÃǹ«Ë¾Âð£¿ÓÐûÓиüºÏÊʵģ¬MySQL¸÷·½ÃæÊʺÏÂð£¿Ð»Ð»¡£×îºÃÏêϸµã¡£
ºÏÊÊ
Ãâ·ÑµÄ¿ÉÒÔÑ¡SQL 2005 Express£¬¿ªÔ´µÄÆäʵûÓÐʲô±ØÒª£¬ÄãÓÖ²»ÊÇÒªÔÚÉÏÃæ½¨Á¢Ð©Ê²Ã´
ËüÓëSql Server ExpressÓï·¨ÉÏÇø±ð´óÂð£¿
¹Ø¼üÊÇSql server expressÌ«³ÔÄÚ´æÁË£¬ÎÒÃǹ«Ë¾ÉÏһ̨·þÎñÆ÷Óм¸°Ù¸öaspµÄÍøÕ¾°¡£¬ÅÜsql serverÅܲ»ÆðÀ´¡£
¿ÉÒÔʹÓÃ
µ«Óï·¨ÓëSQL SERVER»¹ÊÇÓв»Í¬µÄ
ACCESSÓëSQLiteÏà±È½ÏÄØ£¿
MySql²»ÊǺÜÊìϤ£¬ËüºÃÏñÊÇ»ùÓÚÒýÇæµÄ°É£¬²»Êǵ¥ÎļþµÄ¡£ÊÇÕâÑùµÄ°É£¿
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚ¿ªÊ¼×öÒ»¸öÐÂÏîÄ¿,ÐèÒªÊÇÓÃEVC+SqliteµÄ»·¾³,µ«ÎÒûÓùýSqlite,Çë´ó¼Ò¸øµã½¨Òé,лл!!
sqlite ºÜ¼òµ¥£¬Ö±½Óµ½ËüµÄ¹ÙÍøÏÂÔØ sqlite3.exe ¾ÍÐÐÁË£¬ÆäËüʲô¶¼²»ÐèÒª¡£
È»ºó¾ÍÊÇÏÂÔØÄãÐèÒªµÄÇý¶¯¡£
µ±ÄúµÄ ......
C# code:
System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db");
try
{
conn.Open();
}
......
visual studioÏÂÔÚwmÄ£ÄâÆ÷À³ÌÐò²Ù×÷sqlite¶¼Ê§°Ü£¬µ«ÔÚÊÖ»úÉÏûÎÊÌ⣬´ó¼ÒÆÕ±é¶¼ÊÇÕâÑùÂð£¿ËÓнâ¾ö°ì·¨£¿±Ï¾¹ÔÚÄ£ÄâÆ÷Éϵ÷ÊÔЧÂʱȽϸߡ£
¶÷£¬²»»á°¡£¬PPCµÄÄ£ÄâÆ÷ÊÇ¿ÉÒԵİ¡..
ÒýÓÃ
¶÷£¬²»»á°¡£¬PPCµÄÄ ......
C# code:
public static bool UpdateFriendUrl(int id, string cnName, string jpName, string logoUrl, string site, int order)
{
string sql = "update FriendUrl set SiteNameCN=@SiteNameC ......
żÏ뱸·ÝÊý¾Ý±í£¬Ð´ÁËÒ»¸öÅú´¦Àí£¬ÓÐÏֳɵÄÊý¾Ý¿â¡£µ«ÊÇÅú´¦Àíдµ½Ò»°ë²»»áÁË£¬»¹Çë°ïæ¿´¿´£¬ÔõôÍùÏ¡£¡£¡£
@echo off
echo ÕýÔÚϵͳÊý¾Ý¿â±¸·Ý£¬ÇëÉÔ ......