Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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µ¥¶ÀÁ¬½Ó

µ¥¶ÀÁ¬½ÓµÃ°ÑÊý¾ÝÈ¡³öÀ´ÔÙдÈë°É£¬ÄÜÖ±½Ó¿


Ïà¹ØÎÊ´ð£º

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

accessÊý¾Ý¿âÁ¬½Ó - Web ¿ª·¢ / ASP

ÎÒÁ¬½ÓaccessÊý¾Ý¿â£¬ÒÔǰһֱºÜºÃ£¬×î½üÈ´×ÜÊdzö´í£¨Êý¾Ý¿âÁ¬½Ó³ö´í!£¡£©£¬´úÂëÈçÏ£º
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&" ......

asp.net ÏÂÔØ - .NET¼¼Êõ / ASP.NET

sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿
PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿
Response.Redirect("test.jpg")

ÒýÓÃ
Response.Redirect( ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ