ASP.NET
ʹÓà SqlDataSource ¿Ø¼þÖ»ÐèºÜÉٵĴúÂë»òÎÞÐèÈκδúÂë¼´¿É´ÓÊý¾Ý¿âÖмìË÷Êý¾Ý¡£SqlDataSource ¿Ø¼þ¿ÉÓÃÓÚÈκξßÓйØÁª ADO.NET Ìṩ³ÌÐò£¨ÔÚÅäÖÃÎļþµÄ DbProviderFactories ½ÚÖÐÅäÖ㩵ÄÊý¾Ý¿â£¬°üÀ¨ Microsoft SQL Server¡¢Oracle¡¢ODBC »ò OLE DB Êý¾Ý¿â£¨Èç Microsoft Access£©¡£ÄúÔÚÅäÖÃʱָ¶¨ SqlDataSource ʹÓÃµÄ SQL Óï¾äÓï·¨ÒÔ¼°ÊÇ·ñ¿ÉÒÔʹÓøü¸ß¼¶µÄÊý¾Ý¿â¹¦ÄÜ£¨Èç´æ´¢¹ý³Ì£©¾ùÓÉËùÓõÄÊý¾Ý¿â¾ö¶¨¡£µ«ÊÇ£¬Êý¾ÝÔ´¿Ø¼þ¶ÔÓÚËùÓÐÊý¾Ý¿âµÄ²Ù×÷¶¼ÊÇÏàͬµÄ¡£
ÈôҪʹÓà SqlDataSource ¿Ø¼þ´ÓÊý¾Ý¿âÖмìË÷Êý¾Ý£¬ÖÁÉÙÐèÒªÉèÖÃÒÔÏÂÊôÐÔ£º
·ProviderName£º ÉèÖÃΪ ADO.NET Ìṩ³ÌÐòµÄÃû³Æ£¬¸ÃÌṩ³ÌÐò±íʾÄúÕýÔÚʹÓõÄÊý¾Ý¿â¡£Èç¹ûÄúÕýÔÚʹÓà Microsoft SQL Server£¬Ç뽫 ProviderName ÊôÐÔÉèÖÃΪ“System.Data.SqlClient”£»Èç¹ûÄúÕýÔÚʹÓà Oracle Êý¾Ý¿â£¬Ç뽫 ProviderName ÊôÐÔÉèÖÃΪ“System.Data.OracleClient”£»ÒÀ´ËÀàÍÆ¡£
·ConnectionString£º ÉèÖÃΪÓÃÓÚÊý¾Ý¿âµÄÁ¬½Ó×Ö·û´®¡£
·SelectCommand£º ÉèÖÃΪ´ÓÊý¾Ý¿âÖзµ»ØÊý¾ÝµÄ SQL ²éѯ»ò´æ´¢¹ý³Ì¡£Îª SelectCommand ÊôÐÔÉèÖõIJéѯÓëÔÚ±àд ADO.NET Êý¾Ý·ÃÎÊ´úÂëʱΪ ADO.NET IDbCommand ¶ÔÏóµÄ CommandText ÊôÐÔÉèÖõIJéѯÏàͬ¡£SQL ²éѯµÄʵ¼ÊÓ﷨ȡ¾öÓÚÄúµÄÊý¾Ý¼Ü¹¹ºÍÄúËùʹÓõÄÊý¾Ý¿â¡£
Ò»¡¢Ö¸¶¨Ìṩ³ÌÐòÃû³Æ
½« ProviderName ÊôÐÔÉèÖÃΪ ADO.NET Ìṩ³ÌÐòµÄÃû³Æ£¬¸ÃÌṩ³ÌÐòÓë´æ´¢Êý¾ÝµÄÊý¾Ý¿âµÄÀàÐ͹ØÁª¡£ÔÊÐíµÄÌṩ³ÌÐòµÄÁбíÔÚÅäÖÃÎļþ£¨Machine.config »ò Web.config Îļþ£©µÄ DbProviderFactories ½ÚÖÐ×¢²á¡£Ä¬ÈÏÇé¿öÏ£¬SqlDataSource ¿Ø¼þʹÓöÔÓ¦ÓÚ Microsoft SQL Server µÄ System.Data.SqlClient ADO.NET Ìṩ³ÌÐò¡£Òò´Ë£¬Èç¹ûÒªÁ¬½Óµ½ SQL Server Êý¾Ý¿â£¬ÔòÎÞÐèÏÔʽָ¶¨Ìṩ³ÌÐò¡£µ«ÊÇ£¬Äú»¹¿ÉÒÔÖ¸¶¨ System.Data.OracleClient¡¢System.Data.Odbc »ò System.Data.OleDb Ìṩ³ÌÐò¡£
˵Ã÷£º ²»Òª½« ProviderName ÊôÐÔÉèÖÃΪ·ÇÍÐ¹Ü ADO Ìṩ³ÌÐòµÄÖµ£¬Èç SQLOLEDB »ò MSDAORA¡£
¶þ¡¢Ö¸¶¨Á¬½Ó×Ö·û´®
¿É½« ConnectionString ÊôÐÔÉèÖÃΪÓÃÓÚÌØ¶¨Êý¾Ý¿âµÄÁ¬½Ó×Ö·û´®¡£²»¹ý£¬½« SqlDataSource ¿Ø¼þµÄ ConnectionString ÊôÐÔÉèÖÃÎªÌØ¶¨Á¬½Ó×Ö·û´®£¬¶ÔÓÚ´óÐÍÕ¾µãÀ´Ëµ²¢²»ÄÜËãÊÇÒ»ÖÖÒ×ÓÚά»¤µÄ²ßÂÔ¡£ÁíÍ⣬Á¬½Ó×Ö·û´®ÒÔÃ÷ÎÄÐÎʽ´æ´¢ÔÚ ASP.NET Ò³ÖС£ÈôҪʹ Web Ó¦ÓóÌÐò¸üÒ×ÓÚά»¤²¢ÇÒ°²È«ÐÔ¸ü¸ß£¬½¨Ò齫Á¬½Ó×Ö
Ïà¹ØÎĵµ£º
£¼input id = " loFile " type = " file " runat = " server " £¾
£¼form method = " post " enctype =" multipart/form-data " runat = " server "£¾
£¼/form £¾
1.»ñµÃÉÏ´«ÎļþµÄÃû³Æ£º£¨¹Ø¼üÊÇPostedFileÀàµÄÓ¦Óã©
ʹÓÃPathÀàÖеÄGetFileName·½·¨£¬¾ßÌåÈçÏ£º
lstrFileName = loFile.PostedFile.FileName ......
1. Ìî¿Õ:
(1)ÃæÏò¶ÔÏóµÄÓïÑÔ¾ßÓÐ________ÐÔ¡¢_________ÐÔ¡¢________ÐÔ¡£
(2)ÄÜÓÃforeach±éÀú·ÃÎʵĶÔÏóÐèҪʵÏÖ ________________½Ó¿Ú»òÉùÃ÷________________·½·¨µÄÀàÐÍ¡£
(3)ÁоÙADO.netÖеÄÎå¸öÖ÷Òª¶ÔÏó_______________¡¢_____________¡¢_______________¡¢_______________¡¢_________________¡£
2. ²»¶¨ÏîÑ¡Ôñ£ ......
ÖÚËùÖÜÖªASP.NET 2.0Àï¶Ô±¾µØ»¯£¨Localization£©×öÁ˺ܶ๤×÷£¬´ó´ó¼ò»¯ÁË¿ª·¢¹ý³Ì¡£½ñÌìÖÕÓÚÄܳé³öʱ¼äÑо¿Ò»ÏÂÕâ¸ö¼¼ÊõÁË£¬×ÊÁϺܶ࣬µ«´ó¶à´ø×ÅÒ»¹ÉÒ§ÎĽÀ×ֵķÒëζµÀ£¬So......×Ô¼ºÐ´Ò»Æª¡£
1.ʹÓù¤¾ß×Ô¶¯Éú³É±¾µØ»¯×ÊÔ´£¨LocalResources£©
2.ÔÀ´Localizable AttributePropertyÊÇÕâô»ØÊÂѽ
3.ÊÖ¹¤Ìí¼Ó±¾µ ......
ASP.NET ÌṩÈýÖÖÓÃÓÚÔÚ³öÏÖ´íÎóʱ²¶»ñºÍÏìÓ¦´íÎóµÄÖ÷Òª·½·¨£ºPage_Error ʼþ¡¢Application_Error ʼþÒÔ¼°Ó¦ÓóÌÐòÅäÖÃÎļþ (Web.config)¡£
Èç¹ûÄú²»µ÷Óà Server.ClearError »òÕß²¶»ñ Page_Error »ò Application_Error ʼþÖеĴíÎó£¬Ôò½«¸ù¾Ý Web.config ÎļþµÄ <customErrors> ²¿·ÖÖеÄÉèÖô¦Àí´íÎó¡£ÔÚ & ......
ÔÚ¡¶ASP.NET¿ª·¢£ºÔÚÓû§¿Ø¼þÖÐÌí¼ÓÊôÐÔ¡·ÕâһƪÎÄÕÂÖÐÎÒÃǶ¨ÒåÁËÒ»¸öÓû§µÇ¼µÄÓû§¿Ø¼þUserLogin.ascx Îļþ£¬ÀïÃæ°üº¬ÁËÒ»¸öLinkButton·þÎñÆ÷°´Å¥¿Ø¼þ£¬µ±Óû§µ¥»÷¸Ã°´Å¥Ê±·þÎñÆ÷¶Ë»á×Ô¶¯Éú³ÉÒ»¸ö»Ø·¢À´¼¤·¢Page.Loadʼþ¡£³ýÁË·þÎñÆ÷×Ô¶¯²úÉú»Ø·¢À´¼¤·¢Page.LoadʼþÍ⣬ÎÒÃÇ¿ÉÒÔ¸øLinkButtonÌí¼ÓÒ»¸öËü×Ô¼ºµÄʼþ ......