¹ØÓÚAccessºÍExcelµÄÁ¬½Ó×Ö·û´®
1.Á¬½ÓAccessµÄÁ¬½Ó×Ö·û´®
string strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @FileName;
2.Á¬½ÓExcel
string strExcel = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + @FileName + ";Extended Properties=Excel 8.0;";
Ïà¹ØÎĵµ£º
ÏÂÃæ¸ø³öÁËʹÓÃC# ¿ª·¢µÄÒ»¸öѹËõACCESSÊý¾Ý¿âµÄ³ÌÐò
ÏñFolderBrowserDialog£¨ÓÃÓÚä¯ÀÀÑ¡ÔñÎļþ¼ÐµÄ¶Ô»°¿ò£©¡¢MessageBox£¨ÏûÏ¢´¦Àí¶Ô»°¿ò£©¡¢DirectoryInfo£¨Ä¿Â¼ÐÅÏ¢£¬¿ÉÓÃÓÚ´´½¨¡¢¼ì²âÊÇ·ñ´æÔڵȶÔĿ¼µÄ²Ù×÷£©¡¢FileInfo£¨ÎļþÐÅÏ¢£¬¿ÉÓÃÓÚÎļþµÄ¼ì²â¡¢ÎļþÐÅÏ¢µÄ»ñÈ¡¡¢¸´ÖƵȲÙ×÷£©¡¢DataGridView£¨Êý¾Ý±í¸ñ¿Ø¼þ£¬ÓÃÓ ......
C#ÖзÃÎʹؼü×Ö£¨access keyword£©ÓÐÁ½¸ö£ºbase¡¢this
1.base
ÓÃÓÚ´ÓÅÉÉúÀàÖзÃÎÊ»ùÀàµÄ³ÉÔ±£¬°üÀ¨£º
a.µ÷ÓûùÀàÉÏÒѱ»ÆäËü·½·¨ÖØÐ´£¨override£©µÄ·½·¨¡£
b.Ö¸¶¨´´½¨ÅÉÉúÀàʵÀýʱӦµ÷ÓõĻùÀ๹Ô캯Êý¡£
×¢Ò⣺¶Ô»ùÀàµÄ·ÃÎÊÖ»ÄÜ ......
½ñÌì̸Á½¸öASPÔËÐÐʱ¿ÉÄܳöÏÖµÄÓëIISÓйصĴíÎó
-------------------------------------------------------------------
´íÎóÀàÐÍÒ»£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ²»ÄܸüС£Êý¾Ý¿â»ò¶ÔÏóΪֻ¶Á¡£
´íÎóÀàÐͶþ£º
Microsoft OLE DB Provider ......
ÔÚSQL ServerÖÐÄ£ºý²éѯͨ³£ÊÇÕâÑùµÄSelect * from articleTable where authorName like '%jacky%'
µ«ÊÇÔÚAccessÖÐÓÃÕâÌõÓï¾äÖ´ÐеÄʱºò¾¹È»·¢Ïֲ鲻³ö½á¹û£¬Ôõô¿ÉÄÜÄØ£¿
ºóÀ´²éÁËÏÂ×ÊÁÏ£¬·¢ÏÖÎÊÌâÈçÏ£º
Òª½øÐÐÄ£ºý²éÕÒ£¬Ôò±ØÐëʹÓÃͨÅä·û£¬ACCESS¿âµÄͨÅä·ûºÍSQL SERVERµÄͨÅä·û²»Ò»Ñù¡£
ACCESS¿âµÄͨÅä·ûΪ£º
*& ......
ÔÚдÕâÆª²©ÎĵÄʱºò£¬ÎÒÕæµÄÈ̲»×¡½ÐÒ»Éù£¬ËûÂèµÄ±ä̬£¬½ñÌì×öÒ»¸öÍøÕ¾Ê±ºò£¬ÓÉÓÚÒªÓõ½ACCESS£¬ÄǾÍÓÃÁË£¬°Ñ֮ǰµÄÁ´½ÓÓï¾äCOPY+C¹ýÀ´
¿´¿´ÓÐʲôÎÊÌâ¡£
string connstr = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source="+System.Web.HttpContext.Current.Server.MapPath("window2003.mdb");
Ò»¿´£¬Ó¦¸ÃûʲôÎÊÌ ......