sqlÁ¬½Ó´úÂë - .NET¼¼Êõ / ASP.NET

sqlÁ¬½Ó´úÂë ûÓû§ÃÜÂëµÄÄÇÖÖ

---

C# code:
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NORTHWNDConnectionString"].ConnectionString);


ÔÚweb.config ÀïÃæ д

<add name="NORTHWNDConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=&quot;C:\SQL Server 2000 Sample Databases\NORTHWND.MDF&quot;;Integrated Security=True;Connect Timeout=30;User Instance=True"
  providerName="System.Data.SqlClient" />

---

string strCon = "Data Source=(local);Database=BooksManage;Uid=sa;Pwd=As123";//ÃÜÂëAs123

---

web.config
C# code:
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=localhost;Initial Catalog=Survey;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>



cs code
C# code:
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

---

ÎÒ¿¿£¬ÄãÊDz»±à³ÌµÄ°¡
{{-