“SqlHelper”并不包含“CacheParameters”的定义

/// SqlHelper.cs 类代码如下：using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Text;

/// <summary>
///SqlHelper 的摘要说明
/// </summary>
public class SqlHelper
{
  private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());
   
  public static readonly string ConnectionStringLocalTransaction = ConfigurationManager.ConnectionStrings["NewsConnectionString"].ConnectionString;
   
   
  public static SqlParameter[ ] GetCachedParameters(string cacheKey)
  {
  SqlParameter[] cachedParms =( SqlParameter[]) parmCache[cacheKey];
  if(cachedParms==null) 
  return null;
  SqlParameter[] clonedParms = new SqlParameter[cachedParms.Length];
  for(int i=0, j= cachedParms.Length; i<j;i++)
  clonedParms[i] = ( SqlParameter)((ICloneable)cachedParms[i]).Clone();
  return clonedParms;
   
  }


public SqlHelper()
{ 

   
//
//TODO: 在此处添加构造函数逻辑
//
}
}


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NewsManager.cs


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

/// <summary>
///NewsManager 的摘要说明
/// </summary>
public class NewsManager
{
  .......

public NewsManager()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
  public bool AddNwes(string newsTitle, string newsData, string newsCategory, string imageUrl) 
  {
  ................
  using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))  
  {
  ................

  }
  }
  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;
  }
  }
}
  

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
编译器错误消息: CS0117: “SqlHelper”并不包含“CacheParameters”的定义

源错误:

 

行 68: new SqlParameter (PARM_NEWS_CATEGORY,SqlDbType.NVarChar ,20),
行 69: };
[color=#FF0000]行 70: SqlHelper.CacheParameters(SQL_INSERT_NEWSINFO, parms);行 71: return parms;
行 72: }
 


哪位大侠能告诉我怎么定义吗？


[/color]

你的SqlHelper里只有GetCachedParameters这个方法 而且传入的是string类型

SqlHelper.CacheParameters(SQL_INSERT_NEWSINFO, parms);调用不对吧 你看看你的代码吧