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 錯誤信息請問哪里出問題了????存儲過程是這樣寫嗎???謝謝!
請問哪里出問題了?存儲過程是這樣寫嗎???謝謝!
蝴蝶刀刀
2023-03-18 14:10:26