Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔõÑù´ò¿ªÊý¾Ý¿âΪaccessµÄϵͳ£¿

ÓÃC#×öµÄϵͳ£¬Êý¾Ý¿âΪaccess2003£¬ÔõÑù´ò¿ªÏµÍ³£¿accessÊý¾Ý¿âÔõÑù²Ù×÷.mdbÎļþ£¿
Óësql server²Ù×÷Ò»ÑùÂð£¿ÊDz»ÊÇÒ²ÐèÒª¸½¼ÓÊý¾Ý¿â£¿

Çë¼òҪ˵Ã÷һϲ½Öè ллÁË
²¹³äһϣº
ÎÒÓõĿª·¢¹¤¾ßÊÇvs.net 2003

Ó¦¸ÃÓëSQLÀàËÆ,²»¹ýÁ¬½Ó×Ö·û´®ÓÐЩ²»Í¬

ÐèÒª½«.mdbÎļþ¸½¼Óµ½access ÖÐÂð£¿


ÒýÓÃ
ÐèÒª½«.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 ʹÓà ADODB Á¬½ÓAccess µÄÎÊÌâ

<?php

include("adodb/adodb.inc.php");

$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......

ACCESSµÄ×Ô¶¨Ò庯ÊýÔÚdelphiÀïÔõôÓÃÄØ...

ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()

¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...

Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!


(ÔÚA ......

¹ØÓÚaccessÊý¾Ý¿âÁ¬½Ó¾ø¶Ô·¾¶µÄÎÊÌâÇó½â

Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ


Microsoft O ......

¹ØÓÚDelphiÁ¬½ÓACCESSÊý¾Ý¿â²éѯÎÊÌâ

¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ