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µ¥¶ÀÁ¬½Ó µ¥¶ÀÁ¬½ÓµÃ°ÑÊý¾ÝÈ¡³öÀ´ÔÙдÈë°É£¬ÄÜÖ±½Ó¿
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID 1,Name1....test1,1,99 1,Name1....test1,3,99 1,Name2....test2,1,101 1,Name2....test2,3,101 1,Name3....test3,2,101 1,Name1....test1,4,101 ÏëÒªµÄ½á¹ûÊÇ: 1,Na ......
ÎÒÓÃ.net¿ª·¢wapÍøÕ¾ 1£¬ÎÒ´Ó¹¤¾ßÏäÀïÍÏÁËÁ½¸ölink£¬ÕâÁ½¸ölink»áÏÔʾÔÚÁ½ÐУ¬Èç¹ûÈÃÕâÁ½¸ölink´¦ÓÚͬһÐС£ 2£¬ÈçºÎÏÔʾÁ½¸ö¿Ø¼þÖ®¼äµÄ¿Õ¸ñÎÊÌâ¡£ ¸úwapÓйØÂ𣿲»Ì«Ã÷°× ÓÑÇé°ï¶¥¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£ ¾Í ......
ÐèÇóÈçÏ£º ѧԺ academy£¨aid,aname£© °à¼¶ class£¨cid,cname,aid£© ѧÉú stu(sid,sname,aid,cid) סËÞÇø region(rid,rname) ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯ ËÞÉá dorm(did,rid,bid£¬bedn ......
sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿ PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿ Response.Redirect("test.jpg") ÒýÓà Response.Redirect( ......