当前位置: 代码迷 >> ASP.NET >> 提示异常:SqlHelper”并不包含“CacheParameters”的定义?好心人教教小弟我菜鸟
  详细解决方案

提示异常:SqlHelper”并不包含“CacheParameters”的定义?好心人教教小弟我菜鸟

热度:4067   发布时间:2013-02-26 00:00:00.0
提示错误:SqlHelper”并不包含“CacheParameters”的定义?好心人教教我初学者
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NewsManager.cs

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/// <summary>
///NewsManager 的摘要说明
/// </summary>
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";
public NewsManager()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
  public bool AddNwes(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);
  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;
  }
  }
  private static SqlParameter[] GetParameters() 
  {
  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.CacheParameters(SQL_INSERT_NEWSINFO, parms); return parms;
  }
  }
}






~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ SqlHelper.cs

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/// <summary>
///SqlHelper 的摘要说明
/// </summary>
public class SqlHelper
{
   
  public static readonly string ConnectionStringLocalTransaction = ConfigurationManager.ConnectionStrings["NewsConnectionString"].ConnectionString;
  private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());
   
  public static SqlParameter[ ] GetCachedParameters(string cacheKey)
  {
  SqlParameter[] cachedParms =( SqlParameter[]) parmCache[cacheKey];