上下文中不存在名称“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