·ÀÖ¹ACCESSÊý¾Ý¿â±»ÏÂÔصļ¸ÖÖ·½·¨
×ò
ÌìºÍanimatorÊÔÑéÁËһϣ¬°Ñdata.mdbÎļþ¸ÄÃûΪdata.aspÎļþºó·ÅÔÚwwwrootĿ¼ÀȻºóÔÚIEÖÐÊäÈëdata.asp·¾¶
ºó£¬·¢ÏÖIEÏÔʾһƬ¿Õ°×£¬ÓÒ¼ü->²ì¿´Ô´Îļþ£¬Ìø³ö¼Çʱ¾£¬½«ÄÚÈÝÁí´æΪ.mdbÎļþ£¬ÓÃACCESS´ò¿ª£¬·¢ÏÖÐèÒªÃÜÂ룬Ҳ¾ÍÊÇ˵ÖÁÉÙÎļþÍ·±»
ÆÆ»µ¡£
È»ºóÓÃFlashgetÊÔÑéÏÂÔØdata.aspÎļþ£¬²¢Áí´æΪdata.mdbÎÄ
¼þ£¬·¢ÏÖÓÃACCESS´ò¿ªÍêºÃÎÞË𣡿´À´£¬ºÃһЩ±à³ÌÈËÔ±ÔÚ¿ª·¢µÄʱºò¶¼ÈÏΪ£¬¸ÄÁËmdbºó׺Ϊasp¾ÍÄÜ·ÀÏÂÔصĸÅÄÊÇ´íµÄ£¡ºǫ́Êý¾Ý¿â±»ÏÂÔضÔÓÚ
Ò»¸öasp+accessµÄÍøÕ¾À´ËµÎÞÒÉÊÇÒ»³¡²Ò¾øÈËå¾µÄÔÖÄÑ¡£½ñÌìÕÒÁ˸÷·½µÄÎÄÕ£¬¹éÄÉÒ»ÏÂÓÐÒÔÏÂ9ÖÖ°ì·¨·ÀÖ¹Êý¾Ý¿â±»ÏÂÔØ(»¶Ó²¹³ä)¡£
1.·¢»ÓÄãµÄÏëÏóÁ¦ÐÞ¸ÄÊý¾Ý¿âÎļþÃû
²»ÓÃ˵£¬ÕâÊÇ×î×î͵ÀÁµÄ·½·¨£¬µ«ÊÇÈô¹¥»÷Õßͨ¹ýµÚÈý·½Í¾¾¶»ñµÃÁËÊý¾Ý¿âµÄ·¾¶£¬¾ÍÍæÍê
ÁË¡£±ÈÈç˵¹¥»÷Õß±¾À´Ö»ÄÜÄõ½listȨ£¬½á¹ûÒâÍâ¿´µ½ÁËÊý¾Ý¿â·¾¶£¬¾Í¿ÉÒÔ¹ÚÃáÌûʵذÑÊý¾Ý¿âÏÂÔØ»ØÈ¥Ñо¿ÁË¡£ÁíÍ⣬Êý¾ÝÎļþͨ³£´óС¶¼±È½Ï´ó£¬ÆðÔÙÒþ
±ÎµÄÎļþÃû¶¼Â÷²»ÁËÈË¡£¹Ê±£ÃÜÐÔΪ×îµÍ¡£
2.Êý¾Ý¿âÃûºó׺¸ÄΪASA¡¢ASPµÈ
´Ë·¨ÐëÅäºÏһЩҪ½øÐÐһЩÉèÖ㬷ñÔò¾Í»á³öÏÖ±¾ÎÄ¿ªÍ·µÄÄÇÖÖÇé¿ö¡£
(1)¶þ½øÖÆ×Ö¶ÎÌí¼Ó¡£
(2)ÔÚÕâ¸öÎļþÖмÓÈ룬IIS¾Í»á°´ASPÓï·¨À´½âÎö£¬È»ºó¾Í»á±¨¸æ500´íÎó£¬×ÔÈ»
²»ÄÜÏÂÔØÁË¡£¿ÉÊÇÈç¹ûÖ»ÊǼòµ¥µÄÔÚÊý¾Ý¿âµÄÎı¾»òÕß±¸×¢×ֶμÓÈë<%ÊÇûÓõģ¬ÒòΪACCESS»á¶ÔÆäÖеÄÄÚÈݽøÐд¦Àí£¬ÔÚÊý¾Ý¿âÀïËû»á
ÒÔ<%µÄÐÎʽ´æÔÚ£¬ÎÞЧ£¡ÕýÈ·µÄ·½·¨Êǽ«<%´æÈëOLE¶ÔÏó×Ö¶ÎÀÕâÑùÎÒÃǵÄÄ¿µÄ¾ÍÄÜ´ïµ½ÁË¡£
²Ù×÷·½·¨£º
Ê×ÏÈ£¬ÓÃnotepadн¨Ò»¸öÄÚÈÝΪ<%µÄÎı¾Îļþ£¬Ëæ±ãÆð¸öÃû×Ö´æµµ¡£
½Ó×Å£¬ÓÃAccess´ò¿ªÄúµÄÊý¾Ý¿âÎļþ£¬Ð½¨Ò»¸ö±í£¬Ëæ±ãÆð¸öÃû×Ö£¬ÔÚ±íÖÐÌí¼ÓÒ»¸öOLE¶ÔÏóµÄ×ֶΣ¬È»ºóÌí¼ÓÒ»¸ö¼Ç¼£¬²åÈë֮ǰ½¨Á¢µÄÎı¾Îļþ£¬Èç¹û²Ù×÷ÕýÈ·µÄ»°£¬Ó¦¸Ã¿ÉÒÔ¿´µ½Ò»¸öеÄÃûΪ"Êý¾Ý°ü£¢µÄ¼Ç¼¡£¼´¿É¡£
3.Êý¾Ý¿âÃûÇ°¼Ó"#"
Ö»ÐèÒª°ÑÊý¾Ý¿âÎļþÇ°Ãû¼ÓÉÏ#¡¢È»ºóÐÞ¸ÄÊý¾Ý¿âÁ¬½ÓÎļþ£¨Èçconn.asp£©ÖеÄÊý¾Ý
¿âµØÖ·¡£ÔÀíÊÇÏÂÔصÄʱºòÖ»ÄÜʶ±ð#ºÅÇ°ÃûµÄ²¿·Ö£¬¶ÔÓÚºóÃæµÄ×Ô¶¯È¥µô£¬±ÈÈçÄãÒªÏÂÔØ£º[url]http://www.pcdigest.com
/date/#123.mdb[/url](¼ÙÉè´æÔڵĻ°£©¡£ÎÞÂÛÊÇIE»¹ÊÇFLASHGETµÈϵ½µÄ¶¼ÊÇ[url]http:
//www.test.com/date/index.htm[/url](index.asp¡¢default.jspµÈÄãÔÚIISÉèÖõÄÊ×Ò³Îĵµ)¡£
ÁíÍâÔÚÊý¾Ý¿âÎļþÃûÖб£ÁôһЩ¿Õ¸ñÒ²Æðµ½ÀàËÆ×÷Óã¬ÓÉÓÚHTTPÐÒé¶ÔµØÖ·½âÎöµ
Ïà¹ØÎĵµ£º
public void ExportExcel(DataTable dtData, string filename)
{
System.Web.UI.WebControls.DataGrid dgExport = null;
// µ±Ç°¶Ô»°
Sy ......
½ñÌìÓÃOleDbÁ¬½ÓAccessʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£¿ÉÊÇÎÒµÄÁ¬½Ó×Ö·û´®ÖÐÃ÷Ã÷д×Ålocal.mdb¡£µ¥²½¸ú×Ùµ÷ÊÔ·¢ÏÖConnectionÖеÄÁ¬½Ó×Ö·û´®Ò²ÊÇ”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=local.mdb;”£¬¸ù±¾Ã»ÓÐdbo.mdbµÄÊ¡£ºóÀ´²é¹ýÅŲ鷢ÏÖÊÇschemaµÄÎÊÌâ¡£SQL ServerÖÐÓÐschemaµÄ¸ÅÄîËùÒÔÎÒÃÇÒ»°ã¶¼Ï°¹ß ......
תÔصØÖ·£ºhttp://hi.baidu.com/mbaba/blog/item/39dc8b58d41191dc9c8204c8.html
ºÜ¶àÅóÓÑËäÈ»°²×°ºÃÁËmysqlµ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâƪÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð©MYSQLµÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡ ......
1¡¢ÎÊÌâÃèÊö£ºÓÃVBA°ÑÊý¾Ý´ÓExcelµ¼Èëµ½Access£¨ÏµÍ³°æ±¾ºÅ£ºMicrosoft Windows XP Professional °æ±¾ 2002 Service Pack 3£»Office Access°æ±¾ºÅ£º2002/XP£©¡£
´úÂëÃèÊö£ºInsert Into [±íÃû]([×Ö¶Î1],[×Ö¶Î2]) " & _
&n ......
¼ÙÉèNews±íÖÐÓÐÒ»¸öÊôÐÔPassed£¬Êý¾ÝÀàÐÍÊÇ“ÊÇ/·ñ“
1,¶Á²Ù×÷£ºstring str="select * from News where Passed=True";(access)¶Á“ÊÇ“²Ù×÷¡£
string str="select * from News where Passed=False";(access)¶Á“·ñ“²Ù×÷¡£
2,д²Ù×÷£º
string str="Delete from News wher ......