Accessʱ²»Ê±Ã»·¨¹Ø±ÕÁ¬½Ó£¬¼±£¡
ÏîÄ¿ÓÃÁËAccessÊý¾Ý¿â£¬·¢ÉúÒ»¸ö·Ç³£Ææ¹ÖµÄÎÊÌ⣬Ã÷Ã÷ÒѾ°ÑaccessµÄÊý¾Ý¿âÁ¬½Óclose()ÁË£¬µ«ÊÇmdbÎļþ»¹ÊDZ»Ëø×¡£¬³ý·Ç¹Ø±ÕÕû¸ö½ø³Ì·ñÔòû·¨Êý¾Ý¿âÎļþÔÙҲû·¨É¾³ýÁË¡£¶øÇÒÕâÇé¿ö²»ÊÇÿ´Î¶¼³öÏÖ£¬Ê±²»Ê±À´Ò»Ï·dz£Í´¿à£¡
»¹Çë¸÷λ´óÏÀ°ïæ·ÖÎöÒ»ÏÂ
set connection=nothing ÊÔÊÔ
»òÕßÌùÒ»ÏÂÄãµÄ´úÂë¡£
³ÌÐòÊÇC#дµÄ£¬³õʼ»¯µÄʱºòÎÒ°ÑËùÓеÄÊý¾Ý¿âÁ¬½Ó³õʼ»¯ÁË£¬·Åµ½Õâ¸öDictionaryÀ
È»ºó¹Ø±ÕʱÊDZéÀúÕâ¸öDictinary¹Ø±ÕËùÓÐÁ¬½Ó¡£
public static void closeAllConnections() {
if (m_DbConnection == null) {
return;
}
foreach (OleDbConnection oleConn in m_DbConnection.Values) {
if (oleConn.State != ConnectionState.Closed) {
oleConn.Close();
}
}
}
¹Ø±ÕÒÔºóÈ¥²éoleConnµÄstateȷʵÊÇclose״̬°¡£¬µ«ÊÇÊý¾Ý¿âÎļþҲȷʵÊDZ»Ëø×¡×´Ì¬
Ö´ÐÐÁËʲô²Ù×÷»á³öÏÖÕâ¸öÎÊÌ⣿ÔÚACCESSÖе¼³ö±í£¨ÆäËü¸ñʽ£¬ÈçDBF£©£¬Èç¹û²»Í˳ö£¬»áÌáʾ±íÒѾ´ò¿ª¡£
»ØWWWWA£º¾ÍÊÇÆÕͨµÄÌíɾ¸Ä²é²Ù×÷£¬Ö÷ÒªÕâ¸ö¶«Î÷²»ÊÇÿ´Î¶¼³ö£¬Ê±
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......
m_PriceÊÇfloatÐÍ
m_MonthÊÇctimeÐÍ
ÆäËüÊÇcstringÐÍ
´íÎóÌáʾ£ºµ¯³ö´íÎó¶Ô»°¿ò£¬×××.exe£Ó¦ÓóÌÐò´íÎ󣬡¡¡¡¡¡¸ÃÄÚ´æ²»ÄÜΪ"read"
¸ßÊÖ¼±¾È¡«¡«¡«¡«µ½µ×Ó¦¸ÃÈçºÎд
......
ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿
Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ
2009-07-04 02:16:37 110.110 ......