读书人

上下文中不存在名称“SqlHelper”?该

发布时间: 2012-03-23 12:06:21 作者: rapoo

上下文中不存在名称“SqlHelper”?
using System;
using System.Data;
using System.Text;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;


public class NewsManager
{

private const string SQL_INSERT_NEWSINFO = "INSERT INTO newsinfo VALUES(@title,@data,@date,@imageurl,@category) ";
private const string PARM_NEWS_TITLE = "@title ";
private const string PARM_NEWS_DATA = "@data ";
private const string PARM_NEWS_DATE = "@date ";
private const string PARM_NEWS_CATEGORY = "@category ";
private const string PARM_NEWS_IMAGEURL = "@imageurl ";




private static SqlParameter[] GetParameters()
{


//这句的SqlHelper有问题。
SqlParameter[] parms = SqlHelper.GetCachedParameters(SQL_INSERT_NEWSINFO);




if (parms == null)
{

parms = new SqlParameter[]{
new SqlParameter(PARM_NEWS_TITLE,SqlDbType.NVarChar,20),
new SqlParameter(PARM_NEWS_DATA,SqlDbType.NVarChar,500),
new SqlParameter(PARM_NEWS_DATE,SqlDbType.DateTime),
new SqlParameter(PARM_NEWS_IMAGEURL,SqlDbType.NVarChar,50),
new SqlParameter(PARM_NEWS_CATEGORY,SqlDbType.NVarChar,20) };


//还有这句的SqlHelper。
SqlHelper.CachParameters(SQL_INSERT_NEWSINFO, parms);


}
return parms;
}


public NewsManager()
{}

public bool AddNews(string newsTitle, string newsData, string newsCategory, string imageUrl)
{

StringBuilder strSQL = new StringBuilder();

SqlParameter[] newsParms = GetParameters();

SqlCommand cmd = new SqlCommand();

newsParms[0].Value = newsTitle;
newsParms[1].Value = newsData;

newsParms[2].Value = DateTime.Now;
newsParms[3].Value = imageUrl;
newsParms[4].Value = newsCategory;


foreach (SqlParameter parm in newsParms)
cmd.Parameters.Add(parm);


//还有这句的SqlHelper。
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))


{
strSQL.Append(SQL_INSERT_NEWSINFO);

conn.Open();

cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strSQL.ToString();

int val = cmd.ExecuteNonQuery();

cmd.Parameters.Clear();

if (val > 0)
return true;


else
return false;
}
}
}

[解决办法]
1。
LZ 的 SqlHelper 定义在哪里?

2。
如果定义在单独的 dll / 项目中,请先添加对此 dll / 项目 的引用

3。
如果具有上层命名命名请用 using 语句导入

using MyNameSpace1.MyNameSpace2.MyNameSpace3.SqlHelper;
[解决办法]
没看到LZ引用SqlHelper这个东东是!

[解决办法]
少写了一行
using com.DataAccess

读书人网 >asp.net

热点推荐