asp.net webpart Êý¾Ý¿âÁ¬½Ó´íÎó
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: SQL ÍøÂç½Ó¿Ú, error: 26 - ¶¨Î»Ö¸¶¨µÄ·þÎñÆ÷/ʵÀýʱ³ö´í)
1.Ê×ÏÈÔËÐÐSQLServer
2.È»ºóÔËÐÐC:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe »á³öÏÖÒ»¸öͼÐλ¯µÄ²Ù×÷½çÃæ£¬¸ù¾ÝÌáʾ±ã¿É×Ô¶¯Éú³ÉÒ»¸öÃûΪaspnetdbµÄ¿â¡£
3.´ò¿ªvs.net 2005£¬Ð½¨Ò»¸öÍøÕ¾£¬ÍùÒ³ÃæÉÏÍÏÒ»¸öwebpartmanager,ÔËÐÐÒ»ÏÂ,³ö´í¡£ÒòΪÄ㻹ûÓÐÅäweb.configѽ£¬¶øÇÒvs.net2005Óëvs.net2003ÓÐËù²»Í¬£¬Ä¬ÈÏÊÇûÓÐweb.configÎļþµÄ,ÐèÒªÎÒÃÇ×Ô¼ºÔö¼Ó£¬(µ±È»ÄãÒ²¿ÉÒÔÖ±½ÓÐÞ¸ÄC:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIGÏÂĬÈϵÄweb.config£¬µ«ÊÇÎÒ²»ÍƼö)¡£
4.ÔÚмӵÄweb.configÖÐ°Ñ <connectionStrings/>Ò»ÐÐÐ޸ijÉÈçÏÂ
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=aspnetdb;Persist Security Info=True;User ID=sa;Password="
providerName="System.Data.SqlClient" />
</connectionStrings>
Íê³ÉºóµÄweb.configΪ
<?xml version="1.0" encoding="utf-8"?>
<!--
×¢Òâ: ³ýÁËÊÖ¶¯±à¼´ËÎļþÒÔÍ⣬Äú»¹¿ÉÒÔʹÓÃ
Web ¹ÜÀí¹¤¾ßÀ´ÅäÖÃÓ¦ÓóÌÐòµÄÉèÖ᣿ÉÒÔʹÓà Visual Studio ÖеÄ
“ÍøÕ¾”->“Asp.Net ÅäÖÔѡÏî¡£
ÉèÖúÍ×¢Ê͵ÄÍêÕûÁбíÔÚ
machine.config.comments ÖУ¬¸ÃÎļþͨ³£Î»ÓÚ
\Windows\Microsoft.Net\Framework\v2.x\Config ÖÐ
-->
<configuration>
<appSettings/>
<connectionStrings/>
<system.web>
<!--
ÉèÖà compilation debug="true" ½«µ÷ÊÔ·ûºÅ²åÈë
 
Ïà¹ØÎĵµ£º
ASP.NETÖ®XML£ºÒª²åÈëµÄ½Úµã³ö×Ô²»Í¬µÄÎĵµÉÏÏÂÎÄ
Òª²åÈëµÄ½Úµã³ö×Ô²»Í¬µÄÎĵµÉÏÏÂÎÄ
ʱ¼ä£º2009-06-12 08:15:11
Òì³£ÏêϸÐÅÏ¢: System.ArgumentException: Òª²åÈëµÄ½Úµã³ö×Ô²»Í¬µÄÎĵµÉÏÏÂÎÄ¡£
²úÉú×´¿ö£ºÏÖÔÚÓÐÁ½¸öxmlÎļþ£¬ÎÒÏë°ÑÕâÁ½¸öxmlºÏ²¢£¬ÔÚ¸øxml½Úµã²åÈëÒ»¸ö×Ó½Úµãʱ³öÏÖÁËÕâÑùµÄ´ ......
1. Êý¾Ý¿â·ÃÎÊÐÔÄÜÓÅ»¯
Êý¾Ý¿âµÄÁ¬½ÓºÍ¹Ø±Õ
·ÃÎÊÊý¾Ý¿â×ÊÔ´ÐèÒª´´½¨Á¬½Ó¡¢´ò¿ªÁ¬½ÓºÍ¹Ø±ÕÁ¬½Ó¼¸¸ö²Ù×÷¡£ÕâЩ¹ý³ÌÐèÒª¶à´ÎÓëÊý¾Ý¿â½»»»ÐÅÏ¢ÒÔͨ¹ýÉí·ÝÑéÖ¤£¬±È½ÏºÄ·Ñ·þÎñÆ÷×ÊÔ´¡£ASP.NETÖÐÌṩÁËÁ¬½Ó³Ø(Connection Pool)¸ÄÉÆ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿â¶ÔÐÔÄܵÄÓ°Ï졣ϵͳ½«Óû§µÄÊý¾Ý¿âÁ¬½Ó·ÅÔÚÁ¬½Ó³ØÖУ¬ÐèҪʱȡ³ö£¬¹Ø±ÕÊ ......
ÔÚ.NET֮ǰ£¬ÎÒÃÇÈç¹ûÏë·ÃÎʿͻ§¶ËµÄ×ÊÔ´£¬×î³£¼ûµÄ·½Ê½¾ÍÊÇÔÚÍøÒ³ÀïÃæÇ¶ÈëACTIVEX¿Ø¼þ¡£ÏÖÔÚÓÐÁË.NET£¬ÎÒÃÇ¿ÉÒÔ½«WINFORM¿Ø ¼þǶÈëÔÚÍøÒ³ÀïÃæ£¬´Ó¶øÖ±½Ó¿ØÖƿͻ§¶Ë£¬²»¹ýǰÌáÊǿͻ§¶Ë±ØÐë°²×°ÁË.NET¿â¡£ÕâÓеãÏñJAVA µÄAPPLET£¨±ÊÕß¶ÔJAVA²»ÊǺÜÊ죬ÈçÓÐÎÊÌâ»¶ÓÖ¸Õý£©¡£ÓÉÓÚÐèÒª.NETµÄÔËÐп⣬ËùÒÔʹÓÃÆðÀ´ÓкܶàÏÞÖÆ£¬²» ......
ÎҲſªÊ¼¿´ASP.NETÓëÊý¾Ý¿âµÄÁ¬½Ó£¬½ñÌìÒ»¿ªÊ¼¾ÍÒ»Á¬Óöµ½Èý¸öÎÊÌ⣬ÕÛÌÚÁËÒ»ÍíÉÏ...Ï£ÍûÎҲ鵽µÄ×ÊÁ϶Դó¼ÒÓÐÓá£
×î³õÎÒдµÄÓï¾äÊÇ£º
//Create the Connection
//SqlConnection conn = new SqlConnection(@"Data Source=(local)\NetSDK; Initial Catalog=Northwind; User ID = sa; password = yourPassword;");
ÉÏÃæÕâ ......
ÔÚתÏòеÄÒ³ÃæÊ±£¬»á³öÏÖÏÂÃæµÄ´íÎó
ÎÞ·¨ÕÒµ½×ÊÔ´¡£
˵Ã÷: HTTP 404¡£ÄúÕýÔÚ²éÕÒµÄ×ÊÔ´(»òÕßËüµÄÒ»¸öÒÀÀµÏî)¿ÉÄÜÒѱ»ÒƳý£¬»òÆäÃû³ÆÒѸü¸Ä£¬»òÔÝʱ²»¿ÉÓá£Çë¼ì²éÒÔÏ URL ²¢È·±£ÆäƴдÕýÈ·¡£
ÇëÇóµÄ URL: /lonin.aspx
½â¾ö·½·¨ÈçÏ£º
1.Ê×ÏÈ£¬ÒªÖØÐÂ×¢²áIIS £ºÔËÐÐcmd ºó ½øÈë“C:\WINDOWS\Microsoft.NET\Fra ......