ѧϰasp.net C#
1¡¢DateTime Êý×ÖÐÍ
System.DateTime currentTime=new System.DateTime();
¡¡¡¡1.1 È¡µ±Ç°ÄêÔÂÈÕʱ·ÖÃë
currentTime=System.DateTime.Now;
¡¡¡¡1.2 È¡µ±Ç°Äê
int Äê=currentTime.Year;
¡¡¡¡1.3 È¡µ±Ç°ÔÂ
int ÔÂ=currentTime.Month;
¡¡¡¡1.4 È¡µ±Ç°ÈÕ
int ÈÕ=currentTime.Day;
¡¡¡¡1.5 È¡µ±Ç°Ê±
int ʱ=currentTime.Hour;
¡¡¡¡1.6 È¡µ±Ç°·Ö
int ·Ö=currentTime.Minute;
¡¡¡¡1.7 È¡µ±Ç°Ãë
int Ãë=currentTime.Second;
¡¡¡¡1.8 È¡µ±Ç°ºÁÃë
int ºÁÃë=currentTime.Millisecond;
£¨±äÁ¿¿ÉÓÃÖÐÎÄ£©
¡¡¡¡1.9 È¡ÖÐÎÄÈÕÆÚÏÔʾ——ÄêÔÂÈÕʱ·Ö
string strY=currentTime.ToString( "f "); //²»ÏÔʾÃë
¡¡¡¡1.10 È¡ÖÐÎÄÈÕÆÚÏÔʾ_ÄêÔÂ
string strYM=currentTime.ToString( "y ");
¡¡¡¡1.11 È¡ÖÐÎÄÈÕÆÚÏÔʾ_ÔÂÈÕ
string strMD=currentTime.ToString( "m ");
¡¡¡¡1.12 È¡µ±Ç°ÄêÔÂÈÕ£¬¸ñʽΪ£º2003-9-23
string strYMD=currentTime.ToString( "d ");
¡¡¡¡1.13 È¡µ±Ç°Ê±·Ö£¬¸ñʽΪ£º14£º24
string strT=currentTime.ToString( "t ");
¡¡¡¡2¡¢×Ö·ûÐÍת»» תΪ32λÊý×ÖÐÍ
¡¡¡¡Int32.Parse(±äÁ¿) Int32.Parse( "³£Á¿ ")
¡¡¡¡3¡¢ ±äÁ¿.ToString()
¡¡¡¡×Ö·ûÐÍת»» תΪ×Ö·û´®
¡¡¡¡12345.ToString( "n "); //Éú³É 12,345.00
¡¡¡¡12345.ToString( "C "); //Éú³É £¤12,345.00
¡¡¡¡12345.ToString( "e "); //Éú³É 1.234500e+004
¡¡¡¡12345.ToString( "f4 "); //Éú³É 12345.0000
¡¡¡¡12345.ToString( "x "); //Éú³É 3039 (16½øÖÆ)
¡¡¡¡12345.ToString( "p "); //Éú³É 1,234,500.00%
¡¡¡¡4¡¢±äÁ¿.Length Êý×ÖÐÍ
¡¡¡¡È¡×Ö´®³¤¶È
Ïà¹ØÎĵµ£º
Data Source=sqlservername;Initial Catalog=dbname;User ID=userid;Password=userpwd
Data Source=(local)\\SQLEXPRESS;Initial Catalog=Êý¾Ý¿âÃû;Integrated Security=True
Data Source=(local);Initial Catalog=Êý¾Ý¿âÃû;User ID=ÕʺÅ;Password=ÕʺÅÃÜÂë
Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\BegASPNET\ ......
½ñÌìÓÃOleDbÁ¬½ÓAccessʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£¿ÉÊÇÎÒµÄÁ¬½Ó×Ö·û´®ÖÐÃ÷Ã÷д×Ålocal.mdb¡£µ¥²½¸ú×Ùµ÷ÊÔ·¢ÏÖConnectionÖеÄÁ¬½Ó×Ö·û´®Ò²ÊÇ”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=local.mdb;”£¬¸ù±¾Ã»ÓÐdbo.mdbµÄÊ¡£ºóÀ´²é¹ýÅŲ鷢ÏÖÊÇschemaµÄÎÊÌâ¡£SQL ServerÖÐÓÐschemaµÄ¸ÅÄîËùÒÔÎÒÃÇÒ»°ã¶¼Ï°¹ß ......
Ôø¾ÈÏΪ£¬Ñ§ºÃCÓïÑÔ´ò±éÌìÏÂÎÞµÐÊÖ¡£ ºóÀ´·¢ÏÖΪÁËÃæÏò¶ÔÏ󣬲»µÃ²»ÓÃC++£¬ºóÀ´·¢ÏÖÃæÏò¶ÔÏó¹ûÈ»ÊǷdz£Î°´óµÄ˼Ï룡 ÔÙºóÀ´£¬´ÓVS6.0Õâ¸ö°æ±¾Ö®ºó£¬VC¾ÍÒѾûÓÐʲô̫´óµÄ±ä»¯ÁË£¬MFCµÈµÈ¶¼ÒѾÎȶ¨ÏÂÀ´ÁË£¬Î¢Èí²»ÍæÁË£¬Î¢ÈíÅܵ½.netƽ̨ÉÏÃæÈ¥ÍæÁË£¡£¡Î¢ÈíһЩеÄÓ¦Óã¬È«²¿¶¼Åܵ½.netƽ̨ÉÏÈ¥ÁË£¬VCƽ̨¸öÈ˾õµÃ¾ÍÊ£ ......
ÅäÖÃÎļþ¿ÉÓÃÀ´´æ·ÅһЩ¶à´ÎÓõ½µÄ³£Á¿Êý¾Ý£¬ÈçÁ¬½Ó´®£º
<appSettings>
<add key="connStr1" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
<add key="connStr2" value="App_Data\test.mdb"/>
</appSettings>
Õâ¸öÅäÖÃÊý¾Ý¿âÁ¬½Ó´®
ʹÓÃʾÀý£º
public class DBCo ......