- C# code
NewsDao.cs #region 根据新闻类别Id取出该类别下的所有新闻 public DataTable SelectByCaId(int caid) { DataTable dt = new DataTable(); string cmdText = "news_SelectBycaId"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@caid",caid) }; dt = sqlhelp.ExecuteQuery(cmdText, paras, CommandType.StoredProcedure); return dt; } #endregionNewsManager.cs #region 根据新闻类别Id取出该类别下的所有新闻 public DataTable SelectByCaId(int caid) { return newsDao.SelectByCaId(caid); } #endregionList.aspx.cs if (!Page.IsPostBack) { string caid= Request.QueryString["caid"]; //绑定新闻列表 gvNews.DataSource = new NewsManager().SelectByCaId(caid); gvNews.DataBind(); }
存储过程
- SQL code
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[news_SelectBycaId]@caid intASBEGIN select n.id,n.title,n.createTime,c.caName , n.caId from _news n inner join _category c on n.caId=c.id and n.caId=@caid order by n.createTime descEND
------解决方案--------------------------------------------------------
检查ExecuteQuery方法。参数是否添加到cmd