ASP.NETÁ¬½Ó×Ö·û´®
1.Êý¾Ý¿âÎļþÁ¬½Ó
<add name="LocalSqlServer" connectionString="Data
Source=.\SQLExpress;Integrated
Security=True;
AttachDBFilename=|DataDirectory|TimeTracker.mdf;User
Instance=true" />
Ò». integrated security=trueΪwindowsÓû§ÑéÖ¤£¬¶øÎªfalseʱΪÊý¾Ý¿âÉí·ÝÑéÖ¤£¨ÐèuidºÍpwd£©
¶þ. AttachDBFilenameΪÁ¬½ÓÊý¾Ý¿âÎļþµØÖ·£¬|DataDirectory|Ó﷨ΪÊý¾Ý¿â·¾¶Ìæ»»×Ö·û´®£¬¼´Ìæ»»App_DataÎļþ¼Ð·¾¶£¬ÕâÑù¾Í²»ÐèÒªÖ¸
¶¨¾ø¶Ô·¾¶
Èý. User Instance = true, ָʾÊÇ·ñ½«Ä¬ÈϵÄExpressʵÀýÖØ¶¨Ïòµ½µ÷ÓÃÕË»§Ï²¢ÔÚÔËÐÐʱÆô¶¯ÊµÀý
2.Êý¾Ý¿â·þÎñÆ÷Á¬½Ó
<add name="ConnectionString1" connectionString="Integrated Security=SSPI;Initial Catalog=master;Server=(local);" providerName="System.Data.SqlClient"/>
Ïà¹ØÎĵµ£º
Ê×ÏÈÊý¾Ý¿â±íµÄÉè¼Æµ±ÖÐ
×¢²áÓû§±íÓ¦¸Ã°üº¬Ò»¸öÊÇ·ñ¼¤»îµÄ×ֶΣ¬Í¨¹ý´Ë×Ö¶ÎÀ´ÅжÏÊÇ·ñ¼¤»î¡£ºÍÒ»¸ö¼¤»îkeyµÄ×ֶΣ¬´Ë×Ö¶ÎÓÃÓÚ·ÅÖü¤»îÂë
³ÌÐò·½Ãæ
ÔÚÓû§×¢²áµÄʱºòËæ»úÉú³ÉÒ»¸ö¼¤»îÂë(ÇëÈ·±£¼¤»îÂëΨһ)£¬°ÑÓû§ÐÅÏ¢¼°¼¤»îÂë²åÈëµ½Êý¾Ý±íÖС£
ͨ¹ý·¢ÓʼþµÄ·½Ê½Ïò×¢²áÓû§ÌṩµÄÓÊÏä·¢Ò»·â°üº¬¼¤»îÁ´½ÓºÍ¸Õ¸ÕÉú³ÉµÄ¼¤» ......
1¡¢Êý¾Ý¿Ø¼þ£¨ÈçDataGrid/DataListµÈ¿Ø¼þ£©¸ñʽ»¯ÈÕÆÚ·½·¨£º
e.Item.Cell[0].Text = Convert.ToDateTime(e.Item.Cell[0].Text).ToShortDateString();
//Ö¸¶¨ÁУ¨µÚ1ÁУ©¸ñʽ»¯ÈÕÆÚ
2¡¢ÓÃStringÀàת»»ÈÕÆÚÏÔʾ¸ñʽ£º
String.Format( "yyyy-MM-dd ",yourDateTime);
3¡¢ÓÃConvert·½·¨×ª»»ÈÕÆÚÏÔʾ¸ñʽ£º
Convert.ToDat ......
ʹÓÃÑéÖ¤×é¿ÉÒÔ½«Ò³ÃæÉϵÄÑéÖ¤¿Ø¼þ¹éΪһ×é¡£¿ÉÒÔ¶Ôÿ¸öÑéÖ¤×éÖ´ÐÐÑéÖ¤£¬¸ÃÑéÖ¤ÓëͬһҳµÄÆäËûÑéÖ¤×éÎ޹ء£
½«Òª·Ö×éµÄËùÓпؼþµÄ ValidationGroup ÊôÐÔÉèÖÃΪͬһ¸öÃû³Æ£¨×Ö·û´®£©¼´¿É´´½¨ÑéÖ¤×é¡£¿ÉÒÔΪÑéÖ¤×é·ÖÅäÈκÎÃû³Æ£¬µ«±ØÐë¶Ô¸Ã×éµÄËùÓгÉԱʹÓÃÏàͬµÄÃû³Æ¡£
Ôڻط¢¹ý³ÌÖУ¬Ö» ......
˵µ½ASP.NET»º´æ£¬ÄǾÍÊÇ£º¾¡Ô绺´æ£»¾³£»º´æÄúÓ¦¸ÃÔÚÓ¦ÓóÌÐòµÄÿһ²ã¶¼ÊµÏÖ»º´æ¡£ÏòÊý¾Ý²ã¡¢ÒµÎñÂß¼²ã¡¢UI »òÊä³ö²ãÌí¼Ó»º´æÖ§³Ö¡£ÄÚ´æÏÖÔڷdz£±ãÒË — Òò´Ë£¬Í¨¹ýÒÔÖÇÄܵķ½Ê½ÔÚÕû¸öÓ¦ÓóÌÐòÖÐʵÏÖ»º´æ£¬¿ÉÒÔ»ñµÃºÜ´óµÄÐÔÄÜÌá¸ß¡£ »º´æ¿ÉÒÔÑÚ¸ÇÐí¶à¹ýʧ »º´æÊÇÒ»ÖÖÎÞÐè´óÁ¿Ê±¼äºÍ·ÖÎö¾Í¿ÉÒÔ»ñµÃ“×ã¹»Á¼ºÃµÄ ......