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"]) ;
Ïà¹ØÎÊ´ð£º
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
asp.netÅúÁ¿ÉÏ´«Í¼Æ¬×îºÃÓÐÔ´Â룬ÔÚÏߵȣ¡£¡£¡£¡£¡£¡£¡
Ô´ÂëºÜ³¤µÄ¡£
²Î¿¼
C# code:
HttpFileCollection files = HttpContext.Current.Request.Files;
if (files.Count <= 1)
{
......
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 ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵
3Q´ó¼Ò
htmlÒ³Ãæ.
Õâ¸ö,¼ÈÈ»Ö÷Ò ......
ÀàËÆÌÔ±¦Ò³ÃæÉϵÄ
http://www.taobao.com/
×îºÃÓÐÔ´Âë »òÕß˵µÄÏêϸµã лл ~
ʲô½Ð¶¯Ì¬¹ã¸æ£¿
²»Ã÷°×
µ¯³öÒ»¸ö¿ò£¿
ÀûÓÃJsÎļþ°É£¬°Ñ¹ã¸æÉú³Éjs
aspx:
<%@ Page Language="C#" AutoEventWi ......