VS2008Á¬½ÓAccess³öÏÖδָ¶¨´íÎó,ÈçºÎ½â¾ö
ÎÒÔÚVS2008ÖеķþÎñÆ÷×ÊÔ´¹ÜÀíÆ÷ÖÐÌí¼ÓÒ»¸öAccessÊý¾Ý¿âÎļþµÄÁ¬½Ó
ÔÚ"Ìí¼ÓÁ¬½Ó"´°¿ÚÖ¸¶¨ÍêÊý¾Ý¿âÎļþºó,µã²âÊÔÁ¬½Ó»òÈ·¶¨,¾Íµ¯³ö"δָ¶¨µÄ´íÎó",
(ÒªÇóÓÃAccessÊý¾Ý¿â,±¾È˶ԴËÊý¾Ý¿â²»Ì«ÊìϤ,ÒÔǰÊÇÓÃsqlserverµÄ)
ÉÏÍø²é½â¾ö·½·¨,δ¹û....
ÓÚÊǵ½ÕâÀïÀ´Çë½ÌÏÂ,(²»ÖªµÀÓÐûÓз¢´í°æ¿é),Ï£Íû¸ßÈËÖ¸µãÏÂÏÂ,лл
(Õâ¸ö¸»Îı¾¿òµÄ·¢Í¼¹¦Äܲ»Ì«»á,ËùÒÔͼ·¢²»ÉÏÀ´,Çë¼ûÁÂ)
up
Á¬½Ó×Ö·û´®ÊÇ·ñûÓÐÎÊÌ⣬
sqlÓï¾äÊÇ·ñûÓÐÎÊÌ⣬
ÄѵÀÄãµÄAccessÊý¾ÝÔ´¿ÉÄÜ»µÁË~
Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Documents and Settings\Administrator\×ÀÃæ\data.mdb"
ÔÚweb.configÉèÖÃÁ½¸öÁ´½Ó
C# code:
<add name="access1" connectionString="Provider=Microsoft.Jet.OleDb.4.0;Data Source="/>
<add name="access2" connectionString="~/App_Data/#Address.mdb"/>
Á´½Ó×Ö·û´®
C# code:
/// <summary>
/// Á¬½ÓÊý¾Ý¿â×Ö·û´®
/// </summary>
private static string connectionString = ConfigurationManager.ConnectionStrings["access1"].ConnectionString.ToString() + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["access2"].Co
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......