C# 在SQLHelper外部获取存储过程返回回来的参数值
SqlParameter[] sp ={new SqlParameter("@pageIndex",1)
,new SqlParameter("@pageSize",10)
,new SqlParameter("@rowCount",0){Direction=ParameterDirection.Output}
,new SqlParameter("@pageCount",0){Direction=ParameterDirection.Output}
,new SqlParameter("@where","")}
DataTable dt = DAL.SqlHelper.GetDataTable(System.Data.CommandType.StoredProcedure, "T_GetPagedData", sp)
string rowCount = sp[2].Value.ToString()
string pageCount = sp[3].Value.ToString()
Response.Write("总行数=" + rowCount + "总页数=" + pageCount)