请问哪里出问题了？存储过程是这样写吗？？？谢谢！

Question

NewsManager.cs public News SelectById(string id) { return ndao.SelectById(id); } NewsDAO.cs public News SelectById(string id) { // TODO:根据新闻ID取出该条新闻主体内容 News n = new News(); DataTable dt = new DataTable(); SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@id", id) }; dt = sqlhelper.ExecuteQuery("showArticle", CommandType.StoredProcedure); n.Id = id; n.Title = dt.Rows[0]["title"].ToString(); n.Content = dt.Rows[0]["content"].ToString(); n.CreateTime = dt.Rows[0]["addtime"].ToString(); n.Author = dt.Rows[0]["author"].ToString(); n.Category = dt.Rows[0]["bigclassname"].ToString(); n.Sorce = dt.Rows[0]["origin"].ToString(); return n; } show.aspx.cs string id = Request.QueryString["id"]; NewsManager nm = new NewsManager(); News news = nm.SelectById(id); 存储过程SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GOCREATE PROCEDURE showArticle @id intAS BEGINselect a.id,a.title,a.content,a.origin,a.author,a.addtime,b.bigclassname from article a inner join bigclass b on a.bigclassid=b.bigclassid where a.id=@id order by a.idEND GO 错误信息请问哪里出问题了？？？？存储过程是这样写吗？？？谢谢！

Answer 1

SqlParameter[]
paras
=
new
SqlParameter[]
{

new
SqlParameter("@id",
id)

};
Parameters[0].Value=你要传递的ID值;//这里可能不是这样写
但是一定要有个赋值的操作。