.net²Ù×÷access³ö´í´ó¼Ò°ï¿´Ò»ÏÂ
ÎÒÓõÄÊǶ¯ÍøµÄÁ¬½Ó¿â µÚÒ»´Î´ò¿ªÃ»ÎÊÌâ µ«Êǵ±¶àˢм¸´Îºó³ö´í
C# code:
δָ¶¨µÄ´íÎó
˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆÚ¼ä£¬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£
Òì³£ÏêϸÐÅÏ¢: System.Exception: δָ¶¨µÄ´íÎó
Ô´´íÎó:
ÐÐ 286: catch (System.Data.OleDb.OleDbException ex)
ÐÐ 287: {
ÐÐ 288: throw new Exception(ex.Message);
ÐÐ 289: }
ÐÐ 290: finally
²éÁËһЩ×ÊÁÏ˵ÊÇû¹Ø±Õ µ«ÊÇÎÒ¶¼¼ÓÉÏ
finally
{
connection.Close();
}
ÁËÎÊÌ⻹ÊÇû½â¾ö ´ó¼Ò°ïÎÒ¿´¿´Ð»Ð»ÁË
ÎļþÐÍÊý¾Ý¿â¾³£»á³öÏÖÕâÖÖÎÊÌ⣬¿ÉÄÜÊÇÊý¾Ý¿âÎļþ·ÃÎʶÁдȨÏÞµÄÎÊÌâ
ÊÇ·ñÊý¾ÝËø¶¨µ¼ÖµÄ
using (OleDbConnection conn = new Ol}eDbConnection(""))
{
conn.Close();
}
Ò»°ãÊÇDataReadûÓйرգ¡
Äã¿´¿´£¡
ÕâÊǶ¯ÍøµÄÔÂë
C# code:
public static int ExecuteSql(string SQLString)
{
using (OleDbConnection connectio
Ïà¹ØÎÊ´ð£º
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ
Microsoft O ......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......