¹ØÓÚAccess Êý¾Ý¿â - .NET¼¼Êõ / C#
ÎÒÏëдһ¸öµ¥»úͳ¼Æ¹¤×÷Á¿µÄ³ÌÐò£¬µ«Ö§³Ö¶àÕÊ»§Ê¹ÓÃ,·½±ãÐ޸ġ¢²éѯ¡¢Í³¼Æ¡£ËùÒÔÏëÓõ½Access,ÒªÔõô×ö±È½ÏºÃ£¬ÎÒ»¹Ã»ÓÐ×ö¹ý¹ØÓÚÊý¾Ý¿â·½ÃæµÄ³ÌÐò¡£Çë´ó¼Ò¸øÎÒÒ»¸ö˼·°¡!Ö÷ÒªÊÇÊý¾Ý¿âÕâÒ»¿é.
Ê×ÏÈÒª×öºÃÐèÇóµÄ·ÖÎö
¾ÍÊÇÄãҪʵÏÖʲôÑùµÄ¹¦ÄÜ
Òª¶ÔʲôÊý¾Ý½øÐвÙ×÷
¸ù¾ÝÊý¾Ý½¨Á¢ÄãµÄ±í
¶àÓû§£¬¿ØÖÆÔÚÓ¦Óòã
Êý¾Ý¿âÀïÃæ¿ÉÒÔ½¨Á¢Óû§±í£¬²¢¸½¼ÓÓû§È¨ÏÞ±í£¬¶Ôÿ¸öÓû§È¨ÏÞ½øÐÐÉèÖÃ
ÔÚ´úÂëÀïÃæÔò¸ù¾ÝÕâЩȨÏÞ¶Ô²Ù×÷½çÃæ½øÐÐÏÞÖÆ¡£
½¨Á¢¸öoledbÊý¾Ý¿âÁ´½Ó£¬°ÑÊý¾Ý¿â¶Áµ½datasetÀïÖ±½ÓÁ´½Ó¾Í¿ÉÒÔÁË¡£
È¥www.51aspx.com ϸöÏîÄ¿²Î¿¼Ò»Ï °É ºÜ¼òµ¥¡£
public class DataBaseAccess
{
//ÓÃÓÚÁ¬½ÓaccessÊý¾Ý¿â
protected OleDbConnection Connection;
private string connString;
/// <summary>
/// ¹¹Ô캯Êý »ñÈ¡Á¬½Ó×Ö·û´®
/// </summary>
public DataBaseAccess()
{
//ÅäÖÃÎļþÁ¬½Ó×Ö·û´®È¡µÃ
string str = ConfigurationManager.AppSettings["dbAccessConn"].ToString();
this.connString = str;
this.Connection = new OleDbConnection(this.connString);
}
}
ÅäÖÃÎļþÀïдdbAccessConnµÄÁ´½Ó×Ö·û´®
Ïà¹ØÎÊ´ð£º
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼Åжϵȶ¼ÐèÒªwinform»ù´¡
C#ÓïÑÔ
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹
Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......
ʹÓÃACCESS×î´óµÄÒþ»¼¾ÍÊDz»°²È«¡£½ñÌì¶ÔACCESSÊý¾Ý¿âÉèÖÃÁËÒ»¸öÃÜÂ룬±ØÐëʹÓÃÃÜÂë²ÅÄÜ´ò¿ª£¬µ«ÊÇÔÚ³ÌÐòÖÐÈ´ÎÞ·¨Á¬½ÓÊý¾Ý¿âÁË¡£´ó¼ÒÖªµÀʹÓÃÓû§ÃûºÍÃÜÂ룬ÈçºÎÁ¬½ÓACCESSÊý¾Ý¿â£¿Ã²ËÆACCESSµÄÓû§Ãû»¹²»ÖªµÀ£¿Ö»Öª ......
¡°¾²Ì¬·½·¨ºÍ¾²Ì¬±äÁ¿´´½¨ºóʼÖÕʹÓÃͬһ¿éÄڴ棬¶øʹÓÃʵÀýµÄ·½Ê½»á´´½¨¶à¸öÄÚ´æ."
Õâ¾ä»°¶ÔÂð£¿
ÔÚ¶àÏ̺߳ÍÒì²½³ÌÐòÖ´ÐÐʱ£¬Ê¹Óþ²Ì¬·½·¨»á³öÏÖÒì³£Âð£¿
ÀàµÄ¶à¸öʵÀý,Æä´úÂëÔÚÄÚ´æÖÐÒ²Ö»ÊÇÒ»·Ý,ÿ¸öʵÀ ......
ÈçºÎ½«Ò»¸öListBoxÖеÄÊý¾Ý´æÔÚÊý¾Ý¿âÖеÄÒ»¸ö×Ö¶ÎÏÂÃ棬²¢ÇÒÿÌõ¼Ç¼µÄ×Ö·û´®¸öÊý²»Ò»¶¨ ÒÔ¼°ÈçºÎ´ÓÊý¾Ý¿âÖжÁÈ¡¸ÃListBoxÖеÄËùÓмǼ
C/C++ code:
//´æÈëÊý¾Ý¿â
void __fastcall TForm1::Button5Click(TO ......