asp.net ÏÂweb.configÖÐÅäÖÃÊý¾Ý¿âÁ¬½Ó
1¡¢Web.config ¿ÉÒÔ²ÉÓÃдÁ¬½ÓÌõ¼þ »ò ¸½¼Ó ×.mdf Îļþ
<connectionStrings>
<add name="Sales"
providerName="System.Data.SqlClient"
connectionString= "server=myserver;database=Products;uid=<user name>;pwd=<secure password>" />
<add name="LocalSqlServer"
providerName="System.Data.SqlClient"
connectionString="server=.;database=NorthWind;Integrated Security=SSPI" />
<add name="Sql2005Express"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|NorthWnd.mdf;Integrated Security=True;User Instance=true"
providerName="System.Data.SqlClient"/>
</connectionStrings>
2¡¢×.cs Á¬½ÓÊý¾Ý¿â ´úÂë
string connectionStr = System.Configuration.ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString();
3¡¢MSDN - Ë÷Òý - connectionStrings ¿ÉÒԲ鿴web.configÀïÊý¾Ý¿âÁ¬½Ó»ò¸½¼ÓÉèÖá£
ms-help://MS.MSDNQTR.v90.chs/dv_aspnetgenref/html/b6ffbb2e-a4d1-410e-8f7e-9755e92c65de.htm
Ïà¹ØÎĵµ£º
1. µÄ.net£¬ÓÃÊó±êÓÒ»÷ÄãµÄ¹¤³Ì(½â¾ö·½°¸)£¬Ñ¡Ôñadd new project(Ìí¼Óн¨ÏîÄ¿)¡£
2.Ñ¡Ôñsetup and deployment projects£¨°²×°ºÍ²¿ÊðÏîÄ¿£©µÄ web setup project(web°²×°ÏîÄ¿)¡££¨×¢ÒâsetupprojectµÄ´æ·Å·¾¶¡£Í¨³£Ä¬ÈÏ£©
3.vsµÄ´°¿Ú»áÏÔʾÎļþϵͳ£¨you setup name£©¡£ÓÃÊó±êµã»÷×óÀ¸ÏµÄ"web application folder" µÄ¼Óº ......
ÎҲſªÊ¼¿´ASP.NETÓëÊý¾Ý¿âµÄÁ¬½Ó£¬½ñÌìÒ»¿ªÊ¼¾ÍÒ»Á¬Óöµ½Èý¸öÎÊÌ⣬ÕÛÌÚÁËÒ»ÍíÉÏ...Ï£ÍûÎҲ鵽µÄ×ÊÁ϶Դó¼ÒÓÐÓá£
×î³õÎÒдµÄÓï¾äÊÇ£º
//Create the Connection
//SqlConnection conn = new SqlConnection(@"Data Source=(local)\NetSDK; Initial Catalog=Northwind; User ID = sa; password = yourPassword;");
ÉÏÃæÕâ ......
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: SQL ÍøÂç½Ó¿Ú, error: 26 - ¶¨Î»Ö¸¶¨µÄ·þÎñÆ÷/ʵÀýʱ³ö´í)
1.Ê×ÏÈÔËÐÐSQLServer
2.È»ºóÔËÐÐC:\WINDOWS\Microsoft.NET\Framework\v2.0.5072 ......
// <summary>
/// ¹ýÂËhtml´úÂë
/// </summary>
public static string RphtmlStr(string html)
{
&n ......
using System;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
namespace op_db
{
/**//// <summary>
/// רÃÅÓÃÀ´´¦ÀíÓëÊý¾Ý¿âµÄ²Ù×÷
/// </summary>
public class&n ......