Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

C#µ÷Óà C DLLÎÊÌ⣬¶®µÄÀ´ÇÀ·ÖÁË

//C ½Ó¿Ú
extern "C"
{
  TESSDLL_API int __cdecl GetTessText(const char *imagefile, char *text);  
}
//ÎÒÔÚC#ÖÐÉùÃ÷
//µ÷ÓÃC DLL Öеĺ¯Êý
[DllImport("OCRapi.dll&quo ......

access¹ýÂËÎÊÌ⣬ÓÐÇë´óÏÀÃÇ

sqlÓï¾ä£º
SELECT  top 12  Forum.ID,Forum.topic,Reforum.id,Reforum.username,Reforum.posttime,Reforum.postip,Forum.username from Forum INNER JOIN Reforum ON Forum.ID = Reforum.topicid wher ......

Çë½ÌaccessÊý¾Ý¿â¶¯Ì¬Éú³ÉµÄÎÊÌâ

//**********************************
//³ÌÐò¹¦ÄÜ£º´´½¨AccessÊý¾Ý¿âºÍÊý¾Ý±í
//**********************************
unit Unit1;

interface

uses
  Windows, Messages, SysUtils, ......

AccessÁ¬½ÓÓï¾ä²éѯ½á¹ûÓësql2005²»Ò»ÖÂ

SQL code:

select count(1) from HouseList a left join MemberList b on
(a.OperationName=b.UName and a.Eid=1 and a.houselc='2')

ÒÔÉÏÕâÌõÓï¾äÔÚsql2005ÖвéѯµÃµ½760Ìõ¼Ç¼,·ÅÔÚaccessÖвéѯֻÓÐ14Ì ......

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

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