存储过程返回值 没取到~ 求助!

guohouchang guohouchang 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区

CREATE PROCEDURE sp_DispNewPictrueList
@Count int = 0 output
AS
EXEC( 'SELECT TOP 5 p.[id],u.userName as 作者,[Title] AS 作品,[imgUrl] AS url
,[vote] AS 票数,[hit] AS 浏览 FROM [PictrueVote].[dbo].[Pictrue] AS p INNER JOIN Users as u ON p.uid = u.id
Where p.[state] = ''true'' order by p.postTime Desc');
SELECT @Count =COUNT(1) from [PictrueVote].[dbo].[Pictrue]
GO



string proc = "sp_DispNewPictrueList";
List<Pictrue> list = new List<Pictrue>();
count = 0;
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = proc;
SqlParameter param = new SqlParameter("@Count", SqlDbType.Int, 0, ParameterDirection.Output, true, 0, 0, string.Empty, DataRowVersion.Default, DBNull.Value);
cmd.Parameters.Add(param);
if (conn.State == ConnectionState.Closed)
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
count = (int)param.Value;
while (reader.Read())
{
Pictrue pic = new Pictrue
{
id = Convert.ToInt32(reader[0]),
UserName = Convert.ToString(reader[1]),
Title = Convert.ToString(reader[2]),
imgUrl = Convert.ToString(reader[3]),
vote = Convert.ToInt32(reader[4]),
hit = Convert.ToInt32(reader[5])
};
list.Add(pic);
}
}
return list;


以上为主要代码~
...全文

相关推荐

评论 14
收藏 已收藏
分享
返回顶部
guohouchang
.NET社区 62,274 成员 668,968 内容