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" ½«µ÷ÊÔ·ûºÅ²åÈë
 
Ïà¹ØÎĵµ£º
ÔÚ.NET֮ǰ£¬ÎÒÃÇÈç¹ûÏë·ÃÎÊ¿Í»§¶ËµÄ×ÊÔ´£¬×î³£¼ûµÄ·½Ê½¾ÍÊÇÔÚÍøÒ³ÀïÃæǶÈëACTIVEX¿Ø¼þ¡£ÏÖÔÚÓÐÁË.NET£¬ÎÒÃÇ¿ÉÒÔ½«WINFORM¿Ø ¼þǶÈëÔÚÍøÒ³ÀïÃ棬´Ó¶øÖ±½Ó¿ØÖÆ¿Í»§¶Ë£¬²»¹ýÇ°ÌáÊÇ¿Í»§¶Ë±ØÐë°²×°ÁË.NET¿â¡£ÕâÓеãÏñJAVA µÄAPPLET£¨±ÊÕ߶ÔJAVA²»ÊǺÜÊ죬ÈçÓÐÎÊÌ⻶ÓÖ¸Õý£©¡£ÓÉÓÚÐèÒª.NETµÄÔËÐп⣬ËùÒÔʹÓÃÆðÀ´ÓкܶàÏÞÖÆ£¬²» ......
2010-01-0822:00:30
0¡¢ÒýÑÔ
Web Ò³ÃæÊÇÎÞ״̬µÄ£¬ ·þÎñÆ÷¶Ôÿһ´ÎÇëÇó¶¼ÈÏΪÀ´×Ô²»Í¬Óû§£¬Òò´Ë£¬±äÁ¿µÄ״̬ÔÚÁ¬Ðø¶ÔͬһҳÃæµÄ¶à´ÎÇëÇóÖ®¼ä»òÔÚÒ³ÃæÌøתʱ²»»á±»±£Áô¡£ÔÚÓÃAsp.NET Éè¼Æ¿ª·¢Ò»¸öWebϵͳʱ£¬ Óöµ½Ò»¸öÖØÒªµÄÎÊÌâÊÇÈçºÎ±£Ö¤Êý¾ÝÔÚÒ³Ãæ¼ä½øÐÐÕýÈ·¡¢°²È«ºÍ¸ßЧµØ´«ËÍ£¬Asp.net ÌṩÁË×´Ì ......
1. µÄ.net£¬ÓÃÊó±êÓÒ»÷ÄãµÄ¹¤³Ì(½â¾ö·½°¸)£¬Ñ¡Ôñadd new project(Ìí¼Óн¨ÏîÄ¿)¡£
2.Ñ¡Ôñsetup and deployment projects£¨°²×°ºÍ²¿ÊðÏîÄ¿£©µÄ web setup project(web°²×°ÏîÄ¿)¡££¨×¢ÒâsetupprojectµÄ´æ·Å·¾¶¡£Í¨³£Ä¬ÈÏ£©
3.vsµÄ´°¿Ú»áÏÔʾÎļþϵͳ£¨you setup name£©¡£ÓÃÊó±êµã»÷×óÀ¸ÏµÄ"web application folder" µÄ¼Óº ......
//µÃµ½Êý¾ÝΪ¿âÁ¬½Ó
SqlConnection con=new SqlConnection("Êý¾Ý¿âÁ¬½Ó×Ö·û´®");
//Óô洢¹ý³ÌÃû³ÆºÍÊý¾Ý¿âÁ¬½Ó´´½¨SqlCommand ¶ÔÏó
SqlCommand command = new SqlCommand("´æ´¢¹ý³ÌÃû³Æ",con);
//´ò¿ªÁ¬½Ó
con.Open();
//¶ÔÊý¾Ý¿â½øÐÐÏàÓ¦µÄ²Ù×÷
...................................
........................... ......