Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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#asp.netÉú³É ExcelµÄÎÊÌâ

ÍøÉÏ¿´Á˺ܶ࣬ºÃÏñÕâÑùµ÷ÓúܺãºExcel.Application();
µ«ÊÇÐèÒªÒýÈëʲôÃüÃû¿Õ¼ä»òÕßdll²ÅÄÜÔËÐÐExcelÕâ¸öÀàÄØ£¿

Excel.dll

Excel.dllÔÚExcel°²×°³ÌÐòÏ£¬
using Microsoft.Office.Interop.Excel;
......

ACCESSÊý¾Ý¿âÓëVB¿ª·¢µÄÈí¼þ½øÐл¥Á¬ÍøÁ¬½Ó

±¾À´ÎÒÊÇÓÃACCESS+VB½¨Á¢Ò»¸öÈí¼þ£¨¾ÖÓòÍø£©£¬ÏÖÔÚÓÉÓڰ칫µØµãÓб䶯£¬Ïà»»³ÉINTERNATµÄ£¬ÓÐûÓа취½â¾ö£¬

ÏóÕâÑùµÄÇé¿ö£¬Èç¹ûÊǹãÓòÍø£¬×îºÃ¸Ä³É£ºB\SµÄ
Èç¹ûÊǾÖÓòÍøµÄ£¬×îºÃ¸Ä³É£ºC\SµÄ
http://downlo ......

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

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

VB.NET code:

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

¶¯Ì¬´´½¨accessÊý¾Ý¿âµÄÎÊÌâ2

´´½¨µÄ¹ý³ÌÖгöÏÖdatabase login¶Ô»°¿ò£¬ÇëÎÊÔõôÑù²»ÈøöԻ°¿ò³öÏÖ£¿ÁíÍâÈçºÎ¶¨ÒåÈÕÆÚÐÍÊý¾ÝΪ¶ÌÈÕÆÚÐÍ£¿ºÃÏñÖ»Äܶ¨ÒåΪDatetime¡£

Ô´ÂëÈçÏ£º
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½ ......

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

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