¹ØÓÚAccess×öÊý¾Ý¿âµÄʱºòÔõô¸ÄÎļþµÄÏà¶Ô·¾¶¡£
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\liaotian.mdb"); Õâ¸öÊǾø¶Ô·¾¶£¬ÎÒÏë°ÑÊý¾Ý¿âÎļþ·ÅÔÚÎÒµÄÏîÄ¿ÀïÃæµÄDataÎļþ¼ÐÀïÃæ£¬ÊÇÕâÑù¸ÄÂ𣿠OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Data/Chat.mdb"));
·½·¨µ¹ÊǶÔÁË£¬µ«Òª¼Çס³ÌÐòÒª·ÅÔÚºÏÊʵĵط½£¬dataÎļþ¼ÐÒªºÍ³ÌÐò·ÅÔÚÒ»Æð£¬»¹ÓУ¬ÄãµÄ·¾¶Ð´´íÁË£¬ÊÇ"\"¶ø²»ÊÇ"/",Â¥Ö÷Ôõô·¶ÕâÖֵͼ¶´íÎó£¿ ²»ºÃÒâ˼£¬¿´´íÁË£¬ÕâÊÇASP,ȷʵÊÇ¡°/¡±£¬ÎÒÒ»°ãϲ»¶ÓÃ&×Ö·û "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../DataBase/DBase.mdb")ÒýÓà ·½·¨µ¹ÊǶÔÁË£¬µ«Òª¼Çס³ÌÐòÒª·ÅÔÚºÏÊʵĵط½£¬dataÎļþ¼ÐÒªºÍ³ÌÐò·ÅÔÚÒ»Æð£¬»¹ÓУ¬ÄãµÄ·¾¶Ð´´íÁË£¬ÊÇ"\"¶ø²»ÊÇ"/",Â¥Ö÷Ôõô·¶ÕâÖֵͼ¶´íÎó£¿ lz string strDbPath = @"C:\aa.mdb";//Ò²¿ÉÄÜʹÓÃÎļþ¶Ô»°¿òÀ´²Ù×÷ string strSqlCnn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + strDbPath; OleDbConnection conn = new OleDbConnection(strSqlCnn); Ö±½ÓдµÄ£¬¿ÉÄÜÓÐ´í£¬Æä·½·¨Êǽ«Êý¾Ý¿â·¾¶È·¶¨ºóÔÙ½áºÏµ½Á¬½Ó×Ö·û´®ÀïÈ¥¡£ лÁË£¬·Ö¸ø´ó¼ÒÁË¡£
Ïà¹ØÎÊ´ð£º
±í½á¹¹£º ProductSeriesID ×Ô¶¯±àºÅ ProductSeriesName Îı¾ ProductSeriesRemark ±¸×¢ Ö´ÐÐǰ ProductSeriesID ProductSeriesName ProductSeriesRemark 2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ 3 ÎÙ¸ÖÉá ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÈçºÎ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༴òÓ¡?лл ÈçºÎÓÃVB±àд³ÌÐòʵÏÖ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༴òÓ¡? н¨µÄWordºÍÒÑÓеÄWordµÄ´úÂë¿Ï¶¨ÊDz»Ò»ÑùµÄ ÕâµãLZ»¹ÐèÒªÖ¸Ã÷ ......
m_PriceÊÇfloatÐÍ m_MonthÊÇctimeÐÍ ÆäËüÊÇcstringÐÍ ´íÎóÌáʾ£ºµ¯³ö´íÎó¶Ô»°¿ò£¬×××.exe£Ó¦ÓóÌÐò´íÎ󣬡¡¡¡¡¡¸ÃÄÚ´æ²»ÄÜΪ"read" ¸ßÊÖ¼±¾È¡«¡«¡«¡«µ½µ×Ó¦¸ÃÈçºÎд ......
ÎÒÓÐÁ½¸öaccessÊý¾Ý¿â£¬¼ÙÉè:a1.mdb£¬a2.mdb ËüÃǶ¼ÓÐÒ»ÕŽṹһÑùµÄ±íproduct,ÎÒÏë°Ña2.mdbÀïÃæµÄproductµ¼Èëµ½a1.mdbµÄproductÀïÃæÈ¥£¬ÈçºÎʵÏÖ¿ìµã£¿Íû¸ßÊÖµãÏ¡£ ÒýÓà Óõ¼Èëµ¼³ö²»ÐÐ?? ......