asp.netÖжÁÈ¡AccessÁ¬½Ó×Ö·û´®ÎÊÌâ
ÎÒ¿´µ½ÓÐÁ½ÖÖ·½Ê½£º µÚÒ»ÖÖ ÔÚweb.configÖÐÌí¼Ó£º <connectionStrings> <add name="JiDiweb" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|JiDiweb.mdb" /> </connectionStrings> È»ºóÔÚDBHelper.csÀàÖжÁÈ¡ string connectionString = ConfigurationManager.ConnectionStrings["JiDiweb"].ConnectionString; µÚ¶þÖÖ ÔÚweb.configÖÐÌí¼Ó£º <appSettings> <add key="AccessConn" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/> </appSettings> È»ºóÔÚDBHelper.csÀàÖжÁÈ¡ string connectionString =ConfigurationManager.AppSettings["AccessConn"] + Server.MapPath("/App_Data/JiDiweb.db"); ÎÒ¿´ÁËÕâÁ½ÖÖ·½·¨µÚ¶þÖÖÄØ£¬±ØÐë°Ñdbhelper.csÀà·ÅÔÚApp_codeÎļþ¼ÐÖС£·ñÔò»áÌáʾserver.mappathûÓÐÓ¦ÓÃÃüÃû¿Õ¼ä¡£ ÏÖÔÚÎÒµÄÏîÄ¿ÊDzÉÓÃÈý²ã¼Ü¹¹¡£ÎÒÔÚDAL²ãÖн¨ÁËDBHelperÀà¡£²¢ÓÃÁ˵ÚÒ»ÖÖÁ¬½Ó·½·¨£¬ËùÒÔÎÒÏëÎÊÏÂÁ½ÖÖ·½·¨ÓÐÊ²Ã´Çø±ðÂ𣿸üIISµÃÐéÄâĿ¼´îÉϹØÏµÂð?Íü¸ßÊÖÌáʾÏ¡£Ð»Ð»£¡
½¨Àà¿â²»»áĬÈÏÌí¼ÓSystem.ConfigurationµÄÒýÓÃÒýÓà ½¨Àà¿â²»»áĬÈÏÌí¼ÓSystem.WebµÄÒýÓà ¿ÉÒÔÔÚÌí¼ÓÒýÓúóʹÓà System.Web.HttpContext.Current.Server.MapPath()ÕÒµ½
Ïà¹ØÎÊ´ð£º
select top 12 * from Product where [id] not in (select top 12 [id] from Product) ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
ÎÊÌ⣱ ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´ ¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í ¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý select ²¿ÃÅ,ÐÕÃû from tb ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ <folder state="unchecked" label="È«²¿"> ¡¡¡¡<folder state="unchecked" isBra ......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......
ÎÒÓÃ.net¿ª·¢wapÍøÕ¾ 1£¬ÎÒ´Ó¹¤¾ßÏäÀïÍÏÁËÁ½¸ölink£¬ÕâÁ½¸ölink»áÏÔʾÔÚÁ½ÐУ¬Èç¹ûÈÃÕâÁ½¸ölink´¦ÓÚͬһÐС£ 2£¬ÈçºÎÏÔʾÁ½¸ö¿Ø¼þÖ®¼äµÄ¿Õ¸ñÎÊÌâ¡£ ¸úwapÓйØÂ𣿲»Ì«Ã÷°× ÓÑÇé°ï¶¥¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£ ¾Í ......