AccessÎÊÌâ - .NET¼¼Êõ / ASP.NET
ÓÃAccessÊý¾Ý¿â×öµÄÍøÕ¾£¬connectionString д³É¡°Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\SeaHorse\\Web\AccessDB\\seaHorse.mdbPersist Security Info=True" ¾ÖÓòÍø·¢²¼Ã»ÓÐÎÊÌ⣬ÇëÎÊ·¢²¼µ½Internetʱ»á²»»áÓÐÎÊÌ⣬¸ÃÔõôд°¡£¿
¿Ï¶¨»áÓÐÎÊÌ⣬³ý·ÇÔÚ·þÎñÆ÷ÉÏÊý¾Ý¿âµÄ·¾¶Ò²ÊÇ F:\\SeaHorse\\Web\AccessDB\\seaHorse.mdb
µ±È»»áÓÐÎÊÌâ ·¾¶ÒªÓÃÏà¶Ô·¾¶ »ñÈ¡·þÎñÆ÷¶Ë·¾¶²Å¿ÉÒÔ
Â¥Ö÷·¢²¼µ½Êý¾Ý¿â×¨Çø²ÅÊÇ
¸Ä
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("AccessDB\\seaHorse.mdb");
3Â¥ÄǸöÃÀŮͷÏñµÄǰ±²£¬web.ConfigÔõôÒýÈëServer.MapPath£¿»¹ÓУ¬Á´½Ó´®¿ÉÒÔÄÇÑùдµÄÂð£¿ÎҸijÉÄãµÄÄÇÖÖ¸ñʽ£¬ËüÓï·¨ÓдíÎó¡
°ÑseaHorse.mdb·ÅÔÚApp_DataÖÐ
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|\\seaHorse.mdb");
Data Source=|DataDirectory|\Êý¾Ý¿â.mdb
ÔÚÏîÄ¿Àï¼ÓÒ»¸öApp_DataÎļþ¼Ð£¬°ÑÊý¾Ý¿â·Å½øÈ¥
web.configÖеÄд·¨ÈçÏ£º
<appSettings>
<add key="SQLConnString" value="provider=microsoft.jet.oledb.4.0;data source="/>
<add key="dbPath" value="~AccessDB/seaHorse.mdb"/>
</appSettings>
string connectionString = System.Configuration.ConfigurationManager.AppSettings["SQLConnString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]) ;
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÁ½¸ödropdownlist¶¼°óºÃÁËÖµ£¬ÏëÑ¡ÖÐÒ»¸ödropdownlistÖеÄÖµ£¬È»ºóÔÚÁíÒ»¸ödropdownlistÖÐÑ¡ÖÐÏàÓ¦µÄÒ»Ïî¡£
²»ÊÇ´Óа󶨵ڶþ¸ödropdownlist£¬ÊÇÔÚÒѾ°óºÃµÄÖµµ±ÖÐÑ¡ÖÐÒ»¸ö¡£
ÎÒÏëÓÃjsд
ÇóÖú
Äã¿ÉÒÔ°Ñdrop ......
´úÂëÈçÏ Çë¸ßÊÖ Ö¸µãÏ лл
ajax_http.js
-------------
function getXMLHTTP() {
var xmlhttp;
if (window.ActiveXObject) {
//IE
try {
......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵
3Q´ó¼Ò
htmlÒ³Ãæ.
Õâ¸ö,¼ÈÈ»Ö÷Ò ......