我在SQLServerDAL层中的一个方法,Add是我的存储过程名!public void Insert(BQWsb.Model.AccountInfo accountInfo)
{
SqlParameter[] pars = new SqlParameter[8]; pars[0] = new SqlParameter("@AccountID", SqlDbType.VarChar, 50);
pars[0].Value = accountInfo.AccountID; pars[1] = new SqlParameter("@OperationID", SqlDbType.VarChar, 50);
pars[1].Value = accountInfo.OperationID; pars[2] = new SqlParameter("@OrderID", SqlDbType.VarChar, 50);
pars[2].Value = accountInfo.OrderID; pars[3] = new SqlParameter("@StartTime", SqlDbType.DateTime);
pars[3].Value = accountInfo.StartTime; pars[4] = new SqlParameter("@OtherCardNum", SqlDbType.VarChar, 50);
pars[4].Value = accountInfo.OtherCarduNum; pars[5] = new SqlParameter("@Earning", SqlDbType.Decimal);
pars[5].Value = accountInfo.Earning; pars[6] = new SqlParameter("@Defray", SqlDbType.Decimal);
pars[6].Value = accountInfo.Defray; pars[7] = new SqlParameter("@OperationType", SqlDbType.VarChar, 50);
pars[7].Value = accountInfo.OperationType; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Add", pars);
}它总提示SqlHelper”的类型初始值设定项引发异常,
我配置文件里是这么写的<add name="constr" connectionString="Data Source=.;Initial Catalog=Reckoning;User ID=sa;pwd=sa" providerName ="System.Data.SqlClient"/>我的SqlHelper是这么写的 public static readonly string ConnectionStringLocalTransaction = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;这里是什么原因呢?又不能调试!谁知道错误出现在什么地方么?
{
SqlParameter[] pars = new SqlParameter[8]; pars[0] = new SqlParameter("@AccountID", SqlDbType.VarChar, 50);
pars[0].Value = accountInfo.AccountID; pars[1] = new SqlParameter("@OperationID", SqlDbType.VarChar, 50);
pars[1].Value = accountInfo.OperationID; pars[2] = new SqlParameter("@OrderID", SqlDbType.VarChar, 50);
pars[2].Value = accountInfo.OrderID; pars[3] = new SqlParameter("@StartTime", SqlDbType.DateTime);
pars[3].Value = accountInfo.StartTime; pars[4] = new SqlParameter("@OtherCardNum", SqlDbType.VarChar, 50);
pars[4].Value = accountInfo.OtherCarduNum; pars[5] = new SqlParameter("@Earning", SqlDbType.Decimal);
pars[5].Value = accountInfo.Earning; pars[6] = new SqlParameter("@Defray", SqlDbType.Decimal);
pars[6].Value = accountInfo.Defray; pars[7] = new SqlParameter("@OperationType", SqlDbType.VarChar, 50);
pars[7].Value = accountInfo.OperationType; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Add", pars);
}它总提示SqlHelper”的类型初始值设定项引发异常,
我配置文件里是这么写的<add name="constr" connectionString="Data Source=.;Initial Catalog=Reckoning;User ID=sa;pwd=sa" providerName ="System.Data.SqlClient"/>我的SqlHelper是这么写的 public static readonly string ConnectionStringLocalTransaction = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;这里是什么原因呢?又不能调试!谁知道错误出现在什么地方么?
检查SqlHelper.ExecuteNonQuery
我用的是7层架构的那种编程模式,SqlHelper里面的东西都是微软写好了的,是可以直接用的!我感觉他好像是没进入SqlHelper这个类里面!我看了下一般报我这种错的,都好像坏死配置文件里面的学错了,或者调用错了,我这两个都没错啊!现在就被卡在这里了!