连接数据库

[leavetingting]

请问.net中web.config中有几种连接数据库方式？分别是什么？如果是默认windows验证呢？怎么写？谢谢了，请赐教！

[kingdom_0]

参考

[gw6328]

  <add name="NorthWind" providerName="System.Data.SqlClient" connectionString="server=.;database=NorthWind;Integrated Security=SSPI" />

--在网上找了一上。应该那个Integrated Security 就是集成安全吧。 

[liukaizxc]

web.config
<connectionStrings>
<add name="ConnectionString" connectionString="server=服务器地址;database=hd1022157;uid=用户名;pwd=用户密码（没有不用写）"/>
</connectionStrings>

[leavetingting]

[Quote=引用 2 楼 jinfengyiye 的回复:]

C# code

<add name="NorthWind" providerName="System.Data.SqlClient" connectionString="server=.;database=NorthWind;Integrated Security=SSPI" />

--在网上找了一上。应该那个Integrated Security 就是集成安全吧。
[/Quote]

恩 这个用过现在是这样写的
<appSettings>
<add key="conn" value="server=localhost;uid=sa;password=09004;database=myweb;"/>
</appSettings>

[gudujianxiao]

<connectionStrings> 和<appSettings>两种

[longlongtingyu]

在web.config配置文件中添加如下代码：

<configuration>
  <connectionStrings>
    <add name = "NorthwindConnectionString" connectionString = "Data Source = .;Initial Catalog = Northwind; Persist Security Info = True"
     providerName = "System.Data.SqlClient"
  </connectionStrings>
</configuration>

从web.config配置文件中获取连接字符串进行使用的实例

protected void Button1_Click(object sender, EventArgs e)
{
  // 使用WebConfigurationManager获取web.config配置文件中的连接字符串
  string ConnectionString = WebConfigurationManager.
     ConnectionStrings["NorthwindConnectionString"].ConnectionString;
  // 使用连接字符串构造一个SqlConnection实例
  SqlConnection conn = new SqlConnection(ConnectionString);
  try
  {
    .....
  }
  catch(SqlException ex)
  {
     ...
  }
  catch(Exception ex)
  {
     ...
  }
  finally
  {
    ...
  }
}

[hot_yao]

Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;