Question

asp.net sql2008用windows身份登陆的连接串怎么写

Answer 1

你说的是配置文件吗 如果是的话代码如下：1. <appSettings>
<add key= "dsn " value= "Data Source=localhost;UID=sa;PWD=;DATABASE=SMS "/>
</appSettings>
2<connectionStrings>
<add name = "ConnectionStr1 " connectionString= "Server=(local); Database=aspnetdb; User ID=sa; Password= " />
</connectionStrings>
你既然学了这个 应该能看的懂了吧 不多解释了

Answer 2

采用OLeDb方式连接：
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Data Source=.

Answer 3

<connectionStrings>
<add name = "ConnectionStr1 " connectionString= "Server=(服务器命); Database=数据库名; User ID=sa; Password=密码 " />
</connectionStrings>

Answer 4

data source=.;initial catalog=mydatabase;integrated security=true