<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="connstr" connectionString ="Data Source=WIN-N9HU8U26QFV; Initial Catalog=test; Integrated Security=True"/>
</connectionStrings>
</configuration>
private void btnConn_Click(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
MessageBox.Show("连接成功");
}
}哪儿写错了呢?
<configuration>
<connectionStrings>
<add name="connstr" connectionString ="Data Source=WIN-N9HU8U26QFV; Initial Catalog=test; Integrated Security=True"/>
</connectionStrings>
</configuration>
private void btnConn_Click(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
MessageBox.Show("连接成功");
}
}哪儿写错了呢?
public static string ConnString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
这个我在ASP.NET里面用的是好的。
<configuration>
<appSettings>
<add key="connstr" value="Data Source=WIN-N9HU8U26QFV; Initial Catalog=test; Integrated Security=True"/>
</appSettings>
</configuration> private void btnConn_Click(object sender, EventArgs e)
{
string connStr =
ConfigurationSettings.AppSettings["connstr"];
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
MessageBox.Show("连接成功");
}
}还是不行啊,OPEN的时候,提示ConnectionString 属性尚未初始化。
<add name="connstr" connectionString="Data Source=WIN-N9HU8U26QFV;Initial Catalog=HangBiaoDB;Persist Security Info=True;User ID=sa;Password=123"
providerName="System.Data.SqlClient" />
</connectionStrings>
你的config文件里面写的不正确,这样写试试。