ʹÓôøÓû§ÃûºÍÃÜÂëµÄACCESSÁ¬½Ó·½Ê½ - .NET¼¼Êõ / C#
ʹÓÃACCESS×î´óµÄÒþ»¼¾ÍÊDz»°²È«¡£½ñÌì¶ÔACCESSÊý¾Ý¿âÉèÖÃÁËÒ»¸öÃÜÂ룬±ØÐëʹÓÃÃÜÂë²ÅÄÜ´ò¿ª£¬µ«ÊÇÔÚ³ÌÐòÖÐÈ´ÎÞ·¨Á¬½ÓÊý¾Ý¿âÁË¡£´ó¼ÒÖªµÀʹÓÃÓû§ÃûºÍÃÜÂ룬ÈçºÎÁ¬½ÓACCESSÊý¾Ý¿â£¿Ã²ËÆACCESSµÄÓû§Ãû»¹²»ÖªµÀ£¿Ö»ÖªµÀÊǹÜÀíÔ±¡£
Á¬½Ó¼ÓÃÜAccessÊý¾Ý¿âµÄ×Ö·û´®ÉèÖ÷½·¨
AccessÊý¾Ý¿âÔÚһЩСµÄϵͳ³ÌÐòÖо³£Óõ½£¬ÎªÁ˸øÊý¾Ý¿âÖеÄÐÅÏ¢Ôö¼ÓһЩ°²È«ÐÔ£¬×î¼òµ¥µÄ·½·¨¾ÍÊǸøAccessÎļþ¼ÓÉÏÃÜÂ루µ±È»Ò²¿ÉÒÔ ½«Êý¾Ý¿âÖеÄÊý¾Ý½øÐмÓÃܺóÔÚ´æ·Åµ½ÎļþÀïÀ´±£»¤Êý¾Ý£¬Ö»²»¹ýÕâÖÖ·½·¨ÐèÒªÔÚ³ÌÐòÖп¼ÂǼÓÃܺͽâÃܵÄÎÊÌ⣩£¬ÄÇÕë¶ÔÓÐÃÜÂëµÄÎļþͨ¹ýÊý¾Ý¿âÁ¬½Ó×Ö·û´®À´½ø ÐÐÁ¬½Ó·ÃÎÊÄØ£¿ÏÂÃæÊÇÎÒÔÚÍøÂçÉÏÕÒµ½µÄһЩ½â¾ö·½°¸¡£ÊÕ¼¯ÆðÀ´ÒÔ±¸ºóÓá£
accessÊý¾Ý¿â¼ÓÃÜ·Ö3ÖÖ
ÒÔÏÂÒÔaccess xpΪÀý
1¡¢¹¤¾ß -> °²È«-> ¼ÓÃÜ/½âÃÜÊý¾Ý¿â£¬´ò¿ªÊ±ÎÞÐèÈκθü¸Ä
2¡¢¹¤¾ß -> °²È«-> ÉèÖÃÊý¾Ý¿âÃÜÂ룬´ò¿ªÃÜÂëΪ 1 ´ò¿ªÊ±ÐèҪʹÓÃ
C# code:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=1"
Ò²¿ÉÒÔÓÃ
C# code:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb;User ID='admin';Password=;Jet OLEDB:Database Password='1'"
3¡¢¹¤¾ß -> °²È«-> Óû§×éÓëȨÏÞ .... £¬Óû§ÃûΪ admin ÃÜÂëΪ rr Óû§×éÎļþΪ c:\system.mdw£
Ïà¹ØÎÊ´ð£º
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
ÄÚÈÝÈçÌâ¡£¡£ÔÚC#Àï¸ÄÈçºÎдÄØ£¿
±¾À´Ë¼Â·ÊÇÏȱȶԽڵãÃû³Æ£¬ÈçÊǵĻ°¾Í±£´æҪɾ³ý½ÚµãµÄϱê·ÅÔÚÊý×éÀȻºóÑ»·É¾³ý£¬µ«·¢ÏÖ¡£¡£µ±ÎÒɾ³ýµÚÒ»¸öºó£¬ËùÓнڵãϱêÊýÁ¿¶¼·¢Éú¸Ä±ä¡£¡£
¾Í²»ÄÜÔÙ°´ÕÕ֮ǰ¼Í¼µÄ½Úµã ......
ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼Åжϵȶ¼ÐèÒªwinform»ù´¡
C#ÓïÑÔ
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹
Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......
xmlÎļþ¸ñʽÈçÏÂ
XML code:
<?xml version="1.0" encoding="GB2312" ?>
<allproducts version="1.0">
<products>
<product name="prodId&quo ......