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"]) ;
Ïà¹ØÎÊ´ð£º
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£
js ......
C# code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Runtime.InteropServices;
nam ......
asp ·Ò³ÔõôʵÏÖ£¿
·ÖÒ³¿ÉʹÓ÷ÖÒ³¿Ø¼þÈçaspnetpager
ûÕÒµ½´Ë¿Ø¼þ£¡£¡£¡£¡£¡
µÚÈý·½×é¼þ ÐèÒªÔÚÍøÉÏÈ¥ÏÂÔØ http://www.webdiyer.com/Controls/AspNetPager/Downloads
²»Óÿؼþ Ôõô×ö°¡£¡
hehe
²» ......