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

vs2005c#Á¬½ÓaccessÊý¾Ý¿âÌáʾÊý¾Ý¿âÕÒ²»µ½

´úÂëÈçÏ£º
OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_Data/liuyanban.mdb");

        //²éѯÊý¾Ý¿â
        OleDbDataAdapter adapter = new OleDbDataAdapter("select *  from liuyanban.mdb order by name desc", conn);
        //ÉùÃ÷DataSet¶ÔÏó
        DataSet ds = new DataSet();
        //Ìî³äDataSet
        adapter.Fill(ds);//Ìáʾ³ö´íµÄµØ·½¡£
´íÎóÌáʾ£º
      ÕÒ²»µ½Îļþ 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\liuyanban.mdb'¡£
ÎÒµÄÍøÕ¾´æ·Å·¾¶D:\WebSite2
×¢£ºÎÒ²»ÏëʹÓÃAcessDataSource¿Ø¼þÀ´°ï¶¥Êý¾Ý£¬Ó¦ÍâÕâÑù²»·½±ãѧϰ¡£

°ÑÕâ¸ö·¾¶´òÓ¡³öÀ´£ºServer.MapPath( "~/App_Data/liuyanban.mdb ")
¿´¿´Â·¾¶¶Ô²»£¿


Server.MapPath("~/App_Data/liuyanban.mdb");
accessÊý¾Ý¿âûÓÐÏà¶Ô·¾¶

ÄãÔÚµ÷ÊÔ״̬°É¡£·¢²¼µ½iisÖоͺÃÁË¡£

ÒýÓÃ
°ÑÕâ¸ö·¾¶´òÓ¡³öÀ´£ºServer.MapPath( "~/App_Data/liuyanban.mdb ")
¿´¿´Â·¾¶¶Ô²»£¿


´òÓ¡³öµÄ·¾¶Ã»´í°¡¡£D:\WebSite2\App_Data\liuyanban.mdb

ÒýÓÃ
ÄãÔÚµ÷ÊÔ״̬°É¡£·¢²¼µ½i


Ïà¹ØÎÊ´ð£º

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

php ʹÓà ADODB Á¬½ÓAccess µÄÎÊÌâ

<?php

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

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

access µ¼Èë access ת»»ÎÞЧ!ÔÚÏßµÈ!

´ÓÀàÐÍ"DBNULL" µ½ÀàÐÍ¡°Double¡±µÄת»»ÎÞЧ£¨Êý¾Ý¿âÖжÔÓ¦µÄ a3 »òa5 ûÓÐÊý¾ÝÊÇΪ¿Õ£©
,ÇëÎÊÎÒÔõô´¦Àí£¡

VB.NET code:

Dim a1 As String = Nothing
Dim a2 As S ......

ÇóC#¸ßЧ²Ù×÷ACCESSÊý¾Ý¿âµÄ˼·»òÕß´úÂë

´ó¸ÅÇé¿ö£º
C#дµÄwinformÓ¦ÓóÌÐò£¬ÒªÇó³ÌÐòÕûÌìÔËÐС£Êý¾Ý±íºÍÊý¾ÝÁ¿²¢²»´ó£¬±í×î¶à15¸ö£¬ÐÂÔöÊý¾ÝÿÈÕ×î¶à1000Ìõ£¬¶øÇÒ±íÖÐÖ»±£Áôµ±ÌìÊý¾Ý¡£
ÐèҪעÒâµÄÊdzÌÐò¶Ô±íµÄ²éѯºÍÐ޸ķdz£Æµ·±£¬¶øÇÒÊǶà¸öÏß³ÌÍ¬Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ