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
Ïà¹ØÎÊ´ð£º
ÍøÉÏ¿´Á˺ܶ࣬ºÃÏñÕâÑùµ÷ÓúܺãºExcel.Application(); µ«ÊÇÐèÒªÒýÈëʲôÃüÃû¿Õ¼ä»òÕßdll²ÅÄÜÔËÐÐExcelÕâ¸öÀàÄØ£¿ Excel.dll Excel.dllÔÚExcel°²×°³ÌÐòÏ£¬ using Microsoft.Office.Interop.Excel; ......
±¾À´ÎÒÊÇÓÃACCESS+VB½¨Á¢Ò»¸öÈí¼þ£¨¾ÖÓòÍø£©£¬ÏÖÔÚÓÉÓڰ칫µØµãÓб䶯£¬Ïà»»³ÉINTERNATµÄ£¬ÓÐûÓа취½â¾ö£¬ ÏóÕâÑùµÄÇé¿ö£¬Èç¹ûÊǹãÓòÍø£¬×îºÃ¸Ä³É£ºB\SµÄ Èç¹ûÊǾÖÓòÍøµÄ£¬×îºÃ¸Ä³É£ºC\SµÄ http://downlo ......
´ÓÀàÐÍ"DBNULL" µ½ÀàÐÍ¡°Double¡±µÄת»»ÎÞЧ£¨Êý¾Ý¿âÖжÔÓ¦µÄ a3 »òa5 ûÓÐÊý¾ÝÊÇΪ¿Õ£© ,ÇëÎÊÎÒÔõô´¦Àí£¡ VB.NET code: Dim a1 As String = Nothing Dim a2 As S ......
´´½¨µÄ¹ý³ÌÖгöÏÖdatabase login¶Ô»°¿ò£¬ÇëÎÊÔõôÑù²»ÈøöԻ°¿ò³öÏÖ£¿ÁíÍâÈçºÎ¶¨ÒåÈÕÆÚÐÍÊý¾ÝΪ¶ÌÈÕÆÚÐÍ£¿ºÃÏñÖ»Äܶ¨ÒåΪDatetime¡£ Ô´ÂëÈçÏ£º £½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½ ......
´ó¸ÅÇé¿ö£º C#дµÄwinformÓ¦ÓóÌÐò£¬ÒªÇó³ÌÐòÕûÌìÔËÐС£Êý¾Ý±íºÍÊý¾ÝÁ¿²¢²»´ó£¬±í×î¶à15¸ö£¬ÐÂÔöÊý¾ÝÿÈÕ×î¶à1000Ìõ£¬¶øÇÒ±íÖÐÖ»±£Áôµ±ÌìÊý¾Ý¡£ ÐèҪעÒâµÄÊdzÌÐò¶Ô±íµÄ²éѯºÍÐ޸ķdz£Æµ·±£¬¶øÇÒÊǶà¸öÏß³ÌÍ¬Ê ......