c#Á´½ÓACCESSµÄÁ´½Ó×Ö´®Ôõôд£¿
ÈçÌ⣬ÐèÒªÁ¬½ÓACCESSÊý¾Ý¿â£¬Ð»Ð»
C# code:
//Á¬½Ó×Ö·û´®
private static string connString = "Provider=Microsoft.Jet.OLEDB.4.0;;Data Source=DataBase.mdb";//DataBase.mdbÊý¾Ý¿âÎļþÃû
http://www.connectionstrings.com
DataBase.mdbÊÇÊý¾Ý¿âµÄÎļþÃû£¬µ«ÊÇÎÒÏëµÃÖªµÀÊý¾Ý¿âÎļþµÄ´æ·Å·¾¶²Å¿ÉÒÔ£¬µ«ÊÇÔÚÉÏÃæµÄÓï¾äÖÐûÓÐÖ¸Ã÷·¾¶£¬ÄܽâÊÍÏÂÂð£¿
Êý¾Ý¿â·ÅÔÚ³ÌÐòͬĿ¼£¬Ò²¿ÉÒÔд¾ø¶Ô·¾¶Âï
<add name="connectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|web.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|*.mdb;
¡°*¡±ÊÇÄãÊý¾Ý¿âµÄÃüÃû£¬°ÑÕâ¾ä»°·ÅÔÚWeb.configµÄ<appSettings>ÀïÃæ
<appSettings>
<add key="conn" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|*.mdb;">
</appSettings>
Ïà¹ØÎÊ´ð£º
21cnµÄÓÊÏ䣬ÔÚoutlookÅäÖúó¿ÉÒÔÕý³£ÊÕ·¢Óʼþ£¬¿ÉÊÇÎÒдÔÚC#ÖоͲ»ÐУ¬»»³ÉÆäËüÓÊÏ䣬163ºÜÔç×¢²áµÄ¡£¿ÉÒÔ·¢ËÍ¡£²éÁ˺ܾã¬Ã»ÓÐÕÒµ½ÔÒò£¬Çë¸ßÊÖ°ïæ½â´ð¡£¡£¡£Ð¡µÜ£¬Ð»ÁË¡£¡£´úÂëÈçÏ£º
private void SendMail ......
ÎÒÓÃjqueryÎÞË¢ÐÂÉÏ´«Í¼Æ¬ºó·µ»Øjson¸ñʽµÄÊý¾Ý±¨´í
£¨Êµ¼ÊÉÏͼƬÊÇÉÏ´«³É¹¦µÄÁË£¬Ö»ÊÇ·µ»Øjson¸ñʽ×ܶÁ²»µ½£¬×ÜÊDZ¨´í£©
ÎÒµ÷ÊÔÉÏ´«µÄashxÒ³ÈçÏÂ
ÎÞ·¨ÏÔʾ XML Ò³¡£
ʹÓà Ñùʽ±íÎÞ·¨²é¿´ XML ÊäÈë¡£Çë¸ü ......
ÎÒÓÐÒ»¸öÀàËÆµÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_ME ......
˼·£ºÒªÓÃc#Éú³ÉÒ»¸ö²¥·Å»úµÄ²¥·ÅÁбíµÄxml£¬ÀýÈ磺
<daty datys='2010-04-05' datye='2010-05-01' > //ÕâÊDz¥·ÅµÄÈÕÆÚ¶Î
<time times='01:12:00' timee='02:30:00'> ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......