DBHelper错误

[zhang694759158]

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
/*********************************
* 类名：DBHelper
* 功能描述：提供数据访问基础操作
* ******************************/
namespace HotelManager.DAL
{
public static class DBHelper
{
//数据库连接属性
private static SqlConnection connection;
public static SqlConnection Connection
{
get
{
string connectionString = ConfigurationManager.ConnectionStrings["HotelManageConnectionString"].ConnectionString;
if (connection == null)
{
connection = new SqlConnection(connectionString);
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
return connection;
}
}
/// <summary>
/// 执行无参SQL语句
/// </summary>
public static int ExecuteCommand(string safeSql)
{
SqlCommand cmd = new SqlCommand(safeSql, Connection);
int result = cmd.ExecuteNonQuery();
return result;
}
/// <summary>
/// 执行有参SQL语句
/// </summary>
public static int ExecuteCommand(string sql, params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand(sql, Connection);
cmd.Parameters.AddRange(values);
return cmd.ExecuteNonQuery();
}
/// <summary>
/// 执行无参SQL语句，并返回执行行数
/// </summary>
public static int GetScalar(string safeSql)
{
SqlCommand cmd = new SqlCommand(safeSql, Connection);
int result = Convert.ToInt32(cmd.ExecuteScalar());
return result;
}
/// <summary>
/// 执行有参SQL语句，并返回执行行数
/// </summary>
public static int GetScalar(string sql, params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand(sql, Connection);
cmd.Parameters.AddRange(values);
int result = Convert.ToInt32(cmd.ExecuteScalar());
return result;
}
/// <summary>
/// 执行无参SQL语句，并返SqlDataReader
/// </summary>
public static SqlDataReader GetReader(string safeSql)
{
SqlCommand cmd = new SqlCommand(safeSql, Connection);
SqlDataReader reader = cmd.ExecuteReader();
return reader;
}
/// <summary>
/// 执行有参SQL语句，并返SqlDataReader
/// </summary>
public static SqlDataReader GetReader(string sql, params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand(sql, Connection);
cmd.Parameters.AddRange(values);
SqlDataReader reader = cmd.ExecuteReader();
return reader;
}
}
}


错误：string connectionString = ConfigurationManager.ConnectionStrings["HotelManageConnectionString"].ConnectionString;
当前上下文不存在ConfigurationManager
如果改成
System.Configuration.ConfigurationSettings.AppSettings["HotelManageConnectionString"].ToString();
说这一中方式过时了 我用的是vs2010

急求高人赐招

[demoooo]

试试这样呢

System.Configuration.ConfigurationManager.AppSettings["HotelManageConnectionString"];

[wuyq11]

System.Configuration.ConfigurationManager.ConnectionStrings["HotelManageConnectionString"].ConnectionString;

[zhang694759158]

上面的两位你们说的我试了一下缺少程序集引用 该怎么引用呀 我初学不会说详细点

[君之诺言]

举个例子：
private static string dbProviderName = ConfigurationManager.ConnectionStrings["SOC.ConnectionString.Sql"].ProviderName;
private static string dbConnectionString = ConfigurationManager.ConnectionStrings["SOC.ConnectionString.Sql"].ConnectionString;

web.config 里要添加（改成你自己的数据库连接）：
<connectionStrings>
<add name="SOC.ConnectionString.Sql" providerName="System.Data.SqlClient" connectionString="Server=59.64.159.108\SQLEXPRESS;uid=sa;pwd=123456;database=SOC"/>
</connectionStrings>

[beyond_me21]

添加引用System.Configuration

[qdnyjiangqiang]

右击DBHelper所在的程序集，添加引用，在添加引用的选项卡里选择System.Configuration ，添加该引用

[huangwenquan123]

在你类库中或项目中右击，添加引用System.Configuration

[njlywy]

在DBHelper。cs中添加引用System.Configuration

[yujiayou]

在你的UI中要添加System.configuration引用
点击右键添加引用 有很多你慢慢去找

[bourbon1795]

在项目文件中的"引用"右击
添加引用System.configuration

[cyssxf101]

[Quote=引用 2 楼 wuyq11 的回复:]
System.Configuration.ConfigurationManager.ConnectionStrings["HotelManageConnectionString"].ConnectionString;
[/Quote]
对这里好像做了，改改吧！

[kokorenfeng]

string connectionString = ConfigurationManager.ConnectionStrings["HotelManageConnectionString"].ConnectionString;

[Specialaspnet]

System.Configuration.ConfigurationManager.ConnectionStrings["HotelManageConnectionString"].ConnectionString；
在项目文件中的"引用"右击
添加引用System.configuration