Web.configÖжÔAccessÊý¾Ý¿âÁ´½Ó¼¬ÊÖÎÊÌâ
£¨1£©ÔÚVS2008µÄWeb.configÖÐÅäÖÃÊý¾Ý¿âÁ´½Ó×Ö·û´®Ê±£¬Äܲ»ÄÜÅäÖöÔAccessµÄÁ´½Ó×Ö·û´®£¿
£¨2£©ÎÒÓÐÈçÏ´úÂ뱨´í£º
<add name="AccessStringDB" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source='FirstWeb.mdb';Persist Security Info=True" providerName="System.Data.SqlClient"/>
±¨´íÊÇ£º²»Ö§³Ö¹Ø¼ü×Ö: ¡°provider¡±¡£
ÊÔÁ˺ܶ෽·¨£¬¶¼²»ÐУ¡
Çë¸÷λ¼¼Êõʦ¸çʦ½ã°ïæ¡£¡£¡£¡£Òª¼ÇµÃÊǶÔAccessÊý¾Ý¿âÁ´½ÓµÄŶ£¡
<appSettings>
<add key="ConnProvider" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
<add key="ConnSource" value="App_Data/Êý¾Ý¿â.mdb"/>
</appSettings>
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|a.mdb" providerName="System.Data.OleDb"/>
<appSettings>
<add key="ConnString" value="provider=microsoft.jet.oledb.4.0;data source="/>
<add key="dbPath" value="~/App_Data/a.mdb"/>
</appSettings>
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|a.mdb" providerName="System.Data.OleDb"/>
<appSettings>
<add key="ConnString" value=&qu
Ïà¹ØÎÊ´ð£º
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ,
ÇëÎÊÓÐʲôºÃ°ì·¨Âð?
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ÒýÓÃ
°²×°OFFICE £¬Ñ¡Ôñ°²×° ......
ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......
±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......
¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......
ÎÒÔÚaccessÖд´½¨Ò»¸ö±í..ÎÒÔõô»ñÈ¡ËûµÄ´´½¨Óï¾ä..
ÎÒÖ÷ÒªÊÇÏë»ñÈ¡ËûµÄ´´½¨Óï¾äÓÃÓÚCMSµÄ°²×° »òÕßÔÚsqlserverÖа²×°ÓÃÓÃ..
VB code:
CreateDatabase Method Example
This example uses CreateDatabase to ......