sqlhelp使用的问题,报错:SqlHelper 类型初始值设定项引发异常 本帖最后由 xiaozhanger 于 2010-04-26 12:56:25 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 断点,看一下ConnectionStringVote的内容 ConfigurationManager.ConnectionStrings["DB"].ConnectionString;在webconfig中有没有名为DB的连接串? public abstract class SqlHelper你为什么要声明为abstract???? web.config中的连接字符串有问题!仔细看看! 检查ConfigurationManager.ConnectionStrings["DB"].ConnectionString;单步跟踪 看web.config 里面节点为connectionString 中设置的<add name="DB" connectionString="中链接字符串是否正确 给你个标准的SQLhelperusing System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using System.Configuration;/********************************* * 类名:DBHelper * 功能描述:提供数据访问基础操作 * ******************************/namespace NetView.DAL{ public static class DBHelper { //数据库连接属性 private static SqlConnection connection; public static SqlConnection Connection { get { string connectionString = ConfigurationManager.ConnectionStrings["NetViewConnectionString"].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; } }}Web.Config<connectionStrings> <add name="NetViewConnectionString" connectionString="Data Source=.;Initial Catalog=NetView;User ID=sa;password=123456" providerName="System.Data.SqlClient"/> </connectionStrings> 请教ado.net使数据库同步的问题 String值问题 a1 string a1的构造器是String()晕 加好友数据设计方案 ASP.NET与Windows应用程序模式的数据联结怎么差这么远? 母版页如何使用javascript? PETSHOP4的BLL,是不是可以再分开来? 谁能帮我做个购物车!价格可协商! 要使鼠标移动到某个列后,显示相关信息? csdn论坛的用户cookies过期时间是多久? 请教一个T-SQL语句,思路有点乱乱~ 360度 全景不用flash做 怎么做
在webconfig中有没有名为DB的连接串?
单步跟踪
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
/*********************************
* 类名:DBHelper
* 功能描述:提供数据访问基础操作
* ******************************/
namespace NetView.DAL
{
public static class DBHelper
{
//数据库连接属性
private static SqlConnection connection;
public static SqlConnection Connection
{
get
{
string connectionString = ConfigurationManager.ConnectionStrings["NetViewConnectionString"].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;
}
}
}Web.Config<connectionStrings>
<add name="NetViewConnectionString" connectionString="Data Source=.;Initial Catalog=NetView;User ID=sa;password=123456" providerName="System.Data.SqlClient"/>
</connectionStrings>