accessÁ¬½Ó×Ö·û´®ÎÊÌâ
¿É²»¿ÉÒÔ°ÑaccessÁ¬½Ó×Ö·û´®Ð´½øÒ»¸öÀàÖУ¬È»ºóÒªÓõÄʱºòµ÷ÓÃ
¾ÍÏñSQLÄÇÑùÑù£º
using System.Data.SqlClient;
public class DBHelper
{
public DBHelper()
{
}
public static SqlConnction Create()
{return new SqlConnection("server=.;uid=sa;pwd=;database=xxx.mdf");}
}
µ÷ÓõÄʱºòÖ±½ÓSqlConnetion conn=DBhelper.Create();
Èç¹ûÊÇACCESSµÄ»°ÔõôҲ£¬ÎÒÏñÕâÑùÊÔ¹ý£¬Ìáʾ¡°ÉÏÏÂÎÄÖв»´æÔÚserver¡±accessÏà¶Ô·¾¶ÓÃServer.MaPpath()
¿ÉÄܵģ¬ÄãÒ²¿ÉÒÔÓö¯ÈíµÄ´úÂëÉú³ÉÆ÷À´ÊµÏÖ¡£×Ô¶¯Éú³É¡£
private string _strConn;
private string strConnection
{
get {
if( _strConn==null )
_strConn ="Provider=Microsoft.Jet.OleDb.4.0; data source=" + Server.MapPath(".")+"\\dbWebIS.mdb";
return _strConn;
}
}
connectionstring.com
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......
ÇëÎÊÓÐÈËÖªµÀÈçºÎÔÚkernel mode ÏÂд64 bit driver, ¿ÉÒÔ½«IO bitmap ´ò¿ª£¬
32bit¿ÉÒÔÓÃKe386SetIoAccessMapºÍKe386IoSetAccessProcess£¬
Çë問64 bit driverÓÐÀàËÆµÄfunctionaÂð?
ûŪ¹ý¡£
GoogleµÄ£ºhtt ......