ÔõÑù´ò¿ªÊý¾Ý¿âΪaccessµÄϵͳ£¿
ÓÃC#×öµÄϵͳ£¬Êý¾Ý¿âΪaccess2003£¬ÔõÑù´ò¿ªÏµÍ³£¿accessÊý¾Ý¿âÔõÑù²Ù×÷.mdbÎļþ£¿
Óësql server²Ù×÷Ò»ÑùÂð£¿ÊDz»ÊÇÒ²ÐèÒª¸½¼ÓÊý¾Ý¿â£¿
Çë¼òҪ˵Ã÷һϲ½Öè ллÁË
²¹³äһϣº
ÎÒÓõĿª·¢¹¤¾ßÊÇvs.net 2003
Ó¦¸ÃÓëSQLÀàËÆ,²»¹ýÁ¬½Ó×Ö·û´®ÓÐЩ²»Í¬
ÐèÒª½«.mdbÎļþ¸½¼Óµ½access ÖÐÂð£¿
Äã²»¸½¼ÓÔõô֪µÀÁ¬½ÓÄĸöÊý¾Ý¿âѽ?
ÇëÎÊ£¬ÔõÑù½«.mdbÎļþ¸½¼Óµ½accessÊý¾Ý¿âÖУ¿
Âé·³ÁË
ACCESSÓï·¨²»¶®Å¶,
C# code:
1.C#Á¬½ÓAccess
³ÌÐò´úÂ룺
using System.Data;
using System.Data.OleDb;
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"DataSource=C:\BegASPNET\Northwind.mdb";
OleDbConnection objConnection=new OleDbConnection(strConnection);
objConnection.Open();
objConnection.Close();
½âÊÍ£º
Á¬½ÓAccessÊý¾Ý¿âÐèÒªµ¼Èë¶îÍâµÄÃüÃû¿Õ¼ä£¬ËùÒÔÓÐÁË×îÇ°ÃæµÄÁ½ÌõusingÃüÁÕâÊDZز»¿ÉÉÙµÄ!
strConnectionÕâ¸ö±äÁ¿Àï´æ·ÅµÄÊÇÁ¬½ÓÊý¾Ý¿âËùÐèÒªµÄÁ¬½Ó×Ö·û´®£¬ËûÖ¸¶¨ÁËҪʹÓõÄÊý¾ÝÌṩÕߺÍҪʹÓõÄÊý¾ÝÔ´¡£
¡°Provider=Microsoft.Jet.OleDb.4.0;¡±ÊÇÖ¸Êý¾ÝÌṩÕߣ¬ÕâÀïʹÓõÄÊÇMicrosoft JetÒýÇæ£¬Ò²¾ÍÊÇAccessÖеÄÊý¾ÝÒýÇæ£¬asp.net¾ÍÊÇ¿¿Õâ¸öºÍAccessµÄÊý¾Ý¿âÁ¬½ÓµÄ¡£
¡°Data Source=C:\BegASPNET\Northwind.mdb¡±ÊÇ
Ïà¹ØÎÊ´ð£º
<?php
include("adodb/adodb.inc.php");
$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
(ÔÚA ......
Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ
Microsoft O ......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......