如提,在WinForm中按照csdn上的说明,总提示缺少引用App.config:
<connectionStrings>
<add name="DatabaseConnection"
connectionString="Persist Security Info=False;Integrated Security=SSPI;database=Northwind;server=(local);"
providerName="System.Data.SqlClient" />
</connectionStrings>Form1.cs:
using System;
using System.Configuration;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;namespace DataGridView
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
SqlConnection sqlConn = GetDBConnection();
} private SqlConnection GetDBConnection()
{
ConnectionStringSettings settings;
settings = ConfigurationManager.ConnectionStrings["DatabaseConnection"]; SqlConnection conn = new SqlConnection(settings.ConnectionString); return conn;
}
}
}
<connectionStrings>
<add name="DatabaseConnection"
connectionString="Persist Security Info=False;Integrated Security=SSPI;database=Northwind;server=(local);"
providerName="System.Data.SqlClient" />
</connectionStrings>Form1.cs:
using System;
using System.Configuration;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;namespace DataGridView
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
SqlConnection sqlConn = GetDBConnection();
} private SqlConnection GetDBConnection()
{
ConnectionStringSettings settings;
settings = ConfigurationManager.ConnectionStrings["DatabaseConnection"]; SqlConnection conn = new SqlConnection(settings.ConnectionString); return conn;
}
}
}
settings = ConfigurationManager.ConnectionStrings["DatabaseConnection"];这两句出现错误……
1找不到类型或命名空间名称“ConnectionStringSettings”(是否缺少 using 指令或程序集引用?)
2当前上下文中不存在名称“ConfigurationManager”真郁闷,数据库连不上,下边做什么都没用。
connectionString="Data Source=WU;Initial Catalog=sell;User ID=sa"
providerName="System.Data.SqlClient" />
需要在工程里单独引用System.Configuration.dll文件。这与VS2003是不同的,谢谢帮助。