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);

---

我靠，你是不编程的啊
{{-