asp.net Êý¾Ý¿â²Ù×÷
ASP.NET²Ù×÷Êý¾Ý¿â
ͨ¹ý¶ÔADO.NETµÄ»ù±¾½²½â£¬ÒÔ¼°½²½âÁËһЩÊý¾ÝÔ´¿Ø¼þµÄ»ù±¾Ó÷¨ºó£¬±¾Õ½«½éÉÜһЩASP.NET²Ù×÷Êý¾Ý¿âµÄ¸ß¼¶Ó÷¨£¬°üÀ¨Ê¹ÓÃSQLHelper£¬ÒÔ¼°Êý¾ÝÔ´¿Ø¼þ¶ÔÊý¾ÝµÄ²Ù×÷¡£±¾ÕÂÊǶÔÇ°ÃæµÄÊý¾Ý¿â֪ʶµÄÒ»ÖÖ²¹³äºÍÌáÉý¡£
9.1 ʹÓÃADO.NET²Ù×÷Êý¾Ý¿â
ÉÏÒ»ÕÂÖнéÉÜÁËADO.NETµÄ»ù±¾¸ÅÄî¡¢ADO.NETµÄ¶ÔÏó£¬ÒÔ¼°ÈçºÎʹÓÃADO.NET¡£Ê¹ÓÃADO.NETÄܹ»¼«´óµÄ·½±ã¿ª·¢ÈËÔ±¶ÔÊý¾Ý¿â½øÐвÙ×÷¶øÎÞÐè¹ØÐÄÊý¾Ý¿âµ×²ãÖ®¼äµÄÔËÐУ¬ADO.NET²»½ö°üÀ¨¶à¸ö¶ÔÏó£¬Í¬Ñù°üÀ¨¶àÖÖ·½·¨£¬ÕâЩ·½·¨¶¼¿ÉÒÔÓÃÀ´Ö´Ðпª·¢ÈËÔ±Ö¸¶¨µÄSQLÓï¾ä£¬µ«ÊÇÕâЩ·½·¨ÊµÏÖ¹ý³ÌÓÖ²»¾¡Ïàͬ£¬±¾½Ú½«½éÉÜADO.NETÖÐÊý¾ÝµÄ²Ù×÷·½·¨¡£
9.1.1 ʹÓÃExecuteReader()²Ù×÷Êý¾Ý¿â
ʹÓÃExecuteReader()²Ù×÷Êý¾Ý¿â£¬ExecuteReader()·½·¨·µ»ØµÄÊÇÒ»¸öSqlDataReader¶ÔÏó»òOleDbDataReader¶ÔÏó¡£µ±Ê¹ÓÃDataReader¶ÔÏóʱ£¬²»»áÏñDataSetÄÇÑùÌṩÎÞÁ¬½ÓµÄÊý¾Ý¿â¸±±¾£¬DataReaderÀà±»Éè¼ÆΪ²úÉúÖ»¶Á¡¢Ö»½øµÄÊý¾ÝÁ÷¡£ÕâЩÊý¾ÝÁ÷¶¼ÊÇ´ÓÊý¾Ý¿â·µ»ØµÄ¡£ËùÒÔ£¬Ã¿´ÎµÄ·ÃÎÊ»ò²Ù×÷Ö»ÓÐÒ»¸ö¼Ç¼±£´æÔÚ·þÎñÆ÷µÄÄÚ´æÖС£
Ïà±ÈÓëDataSet¶øÑÔ£¬DataReader¾ßÓнϿìµÄ·ÃÎÊÄÜÁ¦£¬²¢ÇÒÄܹ»Ê¹ÓýÏÉٵķþÎñÆ÷×ÊÔ´¡£DataReader¶ÔÏóÌṩÁË“Óαê”ÐÎʽµÄ¶ÁÈ¡·½·¨£¬µ±´Ó½á¹ûÖжÁÈ¡ÁËÒ»ÐУ¬Ôò“Óαꔻá¼ÌÐø¶ÁÈ¡µ½ÏÂÒ»ÐС£Í¨¹ýRead·½·¨¿ÉÒÔÅжÏÊý¾ÝÊÇ·ñ»¹ÓÐÏÂÒ»ÐУ¬Èç¹û´æÔÚÊý¾Ý£¬Ôò¼ÌÐøÔËÐв¢·µ»Øtrue£¬·ñÔò·µ»Øfalse¡£Ê¾Àý´úÂëÈçÏÂËùʾ¡£
string str = "server='(local)';database='mytable';uid='sa';pwd='sa'";
SqlConnection con = new SqlConnection(str);
con.Open();
Ïà¹ØÎĵµ£º
web.config:
<system.net>
<mailSettings>
<smtp deliveryMethod="Network" from="chunyou128<you@163.com>">
&n ......
¹Ø±Õ´°Ìå
1.
this.btnClose.Attributes.Add("onclick", "window.close();return false;");
2.¹Ø±Õ±¾´°Ìå¼äÌøתµ½ÁíÒ»¸öÒ³Ãæ
this.HyperLink1.NavigateUrl = "javascript:onclick=window.opener.location.assign
......
°ïÈË¿´Ò»¸öÍøÕ¾£¬ÊÇghost¿Ë¡ºó³öÏÖ¿Õ°×¹ÊÕÏ£¬ÎÞÂÛÖØ×°IIS»¹ÊÇNETFrameWork¶¼²»ÄÜÕý³£½âÎöaspxÎļþÒ»Ñù£¬Óöµ½aspxÏÔʾ¾ÍÊÇ¿Õ°×Ò³Ãæ¡£
×îºó·¢ÏÖglobal.aspxµÄapplication_error´¦ÀíÖаѴíÎóÐÅÏ¢²Á³ýÁË£¬Ð޸ĻØÀ´ÈÃËüÏÔʾ¾ßÌå´íÎó¡£
·¢ÏÖÎÞ·¨cscдÈëdllÎļþµ½ÁÙʱĿ¼¡£
½â¾ö·½·¨£¬¸³ÓèNetServiceÓû§ÍêÈ«¿ØÖÆȨÏÞ£¬ÔÚ%win ......
ÏÖÔÚµÄÆóÒµ¼¶¿ª·¢ÏîÄ¿£¬ÌرðÊÇÍøÕ¾Ò»°ã¶¼»áÓõ½log¹¦ÄÜ£¬ÏëÏë´ó²¿·Ö»áÓÃEnterprise Logging Application Block µÄ¹¦ÄÜ »òÕß×Ô¼ºÐ´Ò»¸ö×é¼þ£¬¼Ç¼ϵͳÈÕ־ʼþ£¬¸üºÃµÄ¸ú×ÙÁ˽âϵͳÔËÐÐÇé¿ö, ÏÖÓÃASP.NET MVC µÄ¹ýÂËÊôÐÔʵÏÖlog¹¦ÄÜ£¡
ASP.NET MVCµÄfilter ÊÇÒ»¸öÊôÐÔ£¬¿ÉÒÔÓ¦Ó ......
´íÎóÐÅÏ¢£º
»Ø·¢»ò»Øµ÷²ÎÊýÎÞЧ¡£ÔÚÅäÖÃÖÐʹÓà <pages enableEventValidation="true"/> »òÔÚÒ³ÃæÖÐʹÓà <%@ Page EnableEventValidation="true" %> ÆôÓÃÁËʼþÑéÖ¤¡£³öÓÚ°²È«Ä¿µÄ£¬´Ë¹¦ÄÜÑéÖ¤»Ø·¢»ò»Øµ÷ʼþµÄ²ÎÊýÊÇ·ñÀ´Ô´ÓÚ×î³õ³ÊÏÖÕâЩʼþµÄ·þÎñÆ÷¿Ø¼þ¡£Èç¹ûÊý¾ÝÓÐЧ²¢ÇÒÊÇÔ¤Æڵģ¬ÔòʹÓà ClientScriptMan ......