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

¡°/¡±Ó¦ÓóÌÐòÖеķþÎñÆ÷´íÎó ÎÒÓõÄÊÇAccessÊý¾Ý¿â

¡°/¡±Ó¦ÓóÌÐòÖеķþÎñÆ÷´íÎó¡£
--------------------------------------------------------------------------------

δָ¶¨µÄ´íÎó 
˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆÚ¼ä£¬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£ 

Òì³£ÏêϸÐÅÏ¢: System.Data.OleDb.OleDbException: δָ¶¨µÄ´íÎó

Ô´´íÎó: 


ÐÐ 41: public void BindDataLit1()
ÐÐ 42: {
ÐÐ 43: DataList1.DataSource = Funcing.SQL.Access_PT.SelectDataTablePT("select top 6 * from [Notice] order by [id] desc");
ÐÐ 44: DataList1.DataBind();
ÐÐ 45: }
 

Ô´Îļþ: e:\web\2009\7\2\20090702043-pfaijguh7t\Index.aspx.cs ÐÐ: 43 

¶ÑÕ»¸ú×Ù: 


[OleDbException (0x80004005): δָ¶¨µÄ´íÎó]
  System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +1152785
  System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +53
  System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
  System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
  System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConn


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

VCÖÐ odbc·ÃÎÊaccessÄÚ´æÔö³¤

vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......

linux²»ÄÜ·ÃÎÊaccess - Java / Java EE

rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬Ë­ÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿

AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿

Java code:

static String DBDRIVER = "sun.jd ......

C#´«µÝ²ÎÊýµ½ACCESSÖеIJéѯ - .NET¼¼Êõ / C#

ACCESSÖвéѯÈçÏ£º
  PARAMETERS letter Text ( 255 );
  SELECT ¡­¡­¡­¡­ from table1 WHERE letter = letter
ÎÒ¿´µ½¹ý´«µÝÁ½¸ö²ÎÊý£¨Ê±¼ä£©µÄÀý×Ó¡£ÒòΪСµÜÊǰ®ºÃ£¬²»ÊÇרҵ³ÌÐòÔ±£¬ËùÒÔ²»ÖªµÀÔõ ......

ACCESSÈ¥³ýÖØ¸´Öµ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ