62,040
社区成员
发帖
与我相关
我的任务
分享
create proc GetUsers
@Count int out
as
select id,name from Users
set @Count = (Select COUNT(id) from Users)
go
SqlParameter param = new SqlParameter("@Count",SqlDbType.Int,5);
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
cmd.CommandText = "GetUsers";
cmd.Connection.Open();
cmd.ExecuteNonQuery();
object obj = cmd.Parameters["@Count"].Value;
// get the value correct
cmd.Connection.Close();
/* error */
SqlDataReader dr = cmd.ExecuteReader();
object obj = cmd.Parameters["@Count"].Value;
// error the return value is null
string proc = "GetUsers";
SqlParameter param = new SqlParameter("@Count");
DataTable dt = SqlHelper.GetDataTable(proc, param);
int count = dt.Rows[0]["0"];