.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
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:
<?xml version="1.0" encoding="utf-8"? ......