sqlµ¼accessµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET
´úÂëÕâôдµÄ string sqlCmd = "SELECT * INTO [;Data Source=D:\\2010-05-20.mdb,pwd=].main from RptMain WHERE RptCode in " + queryrms; int i = rmdc.ExecuteCommand(sqlCmd); È»ºóÌáʾ´íÎó Ö¸¶¨µÄ¼Ü¹¹Ãû³Æ "Data Source=D:\2010-05-20.mdb,pwd=" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ °ÑËùÓÐȨÏÞ¶¼½µµ½×îµÍÁË£¬ÓÃaccessÒ²ÄÜÕý³£´ò¿ª£¬Ò²Ã»ÓÐÃÜÂ룬ÒÔǰ×öÀàËÆµÄ¹¦ÄÜÕâôдҲû´í°¡ ²»ÖªµÀÊÇÕ¦»ØÊ°¡ »·¾³vs2008 office2007
Ö¸¶¨µÄ¼Ü¹¹Ãû³Æ ";Data Source=D:\Microsoft\Projects\RptOnline\common\2010-05-20.mdb;pwd=" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ ÊÔÁËһϣ¬Ò»ÑùŶÒýÓà ָ¶¨µÄ¼Ü¹¹Ãû³Æ ";Data Source=D:\Microsoft\Projects\RptOnline\common\2010-05-20.mdb;pwd=" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ ÊÔÁËһϣ¬Ò»ÑùŶ ¸ñʽ,ÊÔÏ SELECT * INTO [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\Êý¾ÝÎļþ.mdb;].main ... Ö¸¶¨µÄ¼Ü¹¹Ãû³Æ ";Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Microsoft\Projects\RptOnline\common\2010-05-20.mdb;" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ ¿ìÎÞÓïÁË£¬ºÍ»·¾³ÓйØÏµÃ´ ´úÂëдµÄÕæÄÑ¿´¡£¡£¡£ "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\sourcemachine\test\test.mdb"; ʹÓÃOldbConnectionµ¥¶ÀÁ¬½Ó ±ðÄÇÑùд¡£ ÄÇÀïÄÑ¿´ÁË£¬¾ÍÒ»¸öÖ±½ÓдÈ룬ºÎ±ØÓÃoledbµ¥¶ÀÁ¬½Ó µ¥¶ÀÁ¬½ÓµÃ°ÑÊý¾ÝÈ¡³öÀ´ÔÙдÈë°É£¬ÄÜÖ±½Ó¿
Ïà¹ØÎÊ´ð£º
ÎÒÓÃ.net¿ª·¢wapÍøÕ¾ 1£¬ÎÒ´Ó¹¤¾ßÏäÀïÍÏÁËÁ½¸ölink£¬ÕâÁ½¸ölink»áÏÔʾÔÚÁ½ÐУ¬Èç¹ûÈÃÕâÁ½¸ölink´¦ÓÚͬһÐС£ 2£¬ÈçºÎÏÔʾÁ½¸ö¿Ø¼þÖ®¼äµÄ¿Õ¸ñÎÊÌâ¡£ ¸úwapÓйØÂ𣿲»Ì«Ã÷°× ÓÑÇé°ï¶¥¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£ ¾Í ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£ ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£ ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£ ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......