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²»ÊǺÜÊìϤ£¬ËüºÃÏñÊÇ»ùÓÚÒýÇæµÄ°É£¬²»Êǵ¥ÎļþµÄ¡£ÊÇÕâÑùµÄ°É£¿
Ïà¹ØÎÊ´ð£º
ÕâÊÇÎҲ鵽µÄ×ÊÁÏ
http://www.cppprog.com/2009/0108/43.html ÒѾ´æ½øÍ¼Æ¬ÁË£¬ÏÖÔÚ×öµ½ÕâÒ»²½ÁË£¬
¡°ÕâʱÊý¾Ý¿âµ±ÖÐÒѾÓÐÁËÒ»Ìõ°üº¬BLOB×ֶεÄÊý¾Ý¡£½ÓÏÂÀ´ÎÒÃÇÒª¶ÁÈ¡ÕâÌõÊý¾Ý£º 1. //ѡȡ¸ÃÌõ ......
BC Éú³ÉµÄSqlite DLL Ö»ÓÐ7K £¬ÊDz»ÄÜÓõÄÎļþ£¬ÎªÊ²Ã´»áÕâÑù£¿£¿
±àÒë¹ý³Ì£¿¿ÉÄÜij¸öÔ¤´¦Àí¿ª¹ØÃ»ÉèÖúã¬Ã»Óе¼³öº¯Êý¡£
ÓÐÒ»¸ösqlite3.def ÎļþÎÒ°ÑËüÍϵ½¹¤³ÌÀïÒ»Æð±àÒ룬ÕâÑùÐв»£¿ÒªÔõÑùÉèÖã¬ÎÒ¶ÔBC ²»Êì ......
ÔÚ SQL SERVER ÖеÄÓï¾ä ÊÇ£º
SELECT
(ROW_NUMBER() OVER (ORDER BY Name) - 1) / 4 + 1 AS TitleRow,
(ROW_NUMBER() OVER (ORDER BY Name) - 1) % 4 + 1 AS Title ......
żÏ뱸·ÝÊý¾Ý±í£¬Ð´ÁËÒ»¸öÅú´¦Àí£¬ÓÐÏֳɵÄÊý¾Ý¿â¡£µ«ÊÇÅú´¦Àíдµ½Ò»°ë²»»áÁË£¬»¹Çë°ïæ¿´¿´£¬ÔõôÍùÏ¡£¡£¡£
@echo off
echo ÕýÔÚϵͳÊý¾Ý¿â±¸·Ý£¬ÇëÉÔ ......
×îºÃÊDz»ÐèÒªÁíÍâ°²×°Çý¶¯»ò×é¼þµÄ·½Ê½¡£
ʹÓÃSQLiteµÄAPI, ËüÌṩÁËdll ÐÎʽµÄAPI
ÄѵÀCBÌṩµÄÊý¾Ý×é¼þ²»Ö§³Ö£¿
2010ÊÇÖ§³ÖµÄ¹Ø¼üÊÇÇý¶¯ÒªÑ¡¶Ô£¬ºÃÏñÊÇoffice 11ʲôµÄ
ÒýÓÃ
ÄѵÀCBÌṩµÄÊý¾Ý×é¼ ......