存储过程 out

public static DataTable Page(int pageIndex, int pageSize, out int pageCount, string tableName, string where, string pageField, string orderBy, out int count, string queryField, string groupBy)
{
pageCount = 0;
count = 0;
string SqlStr = "PublicPage";
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@pageIndex",SqlDbType.Int),
new SqlParameter("@pageSize",SqlDbType.Int),
new SqlParameter("@pageCount",SqlDbType.Int),
new SqlParameter("@tableName",SqlDbType.NVarChar,999),
new SqlParameter("@where",SqlDbType.NVarChar,999),
new SqlParameter("@PageField",SqlDbType.NVarChar,80),
new SqlParameter("@orderBy",SqlDbType.NVarChar,999),
new SqlParameter("@Count",SqlDbType.Int),
new SqlParameter("@QueryField",SqlDbType.NVarChar,999),
new SqlParameter("@GroupBy",SqlDbType.NVarChar,2000)
};
sp[0].Value = pageIndex;
sp[1].Value = pageSize;
sp[2].Direction = ParameterDirection.Output;
sp[3].Value = tableName;
sp[4].Value = where;
sp[5].Value = pageField;
sp[6].Value = orderBy;
sp[7].Direction = ParameterDirection.Output;
sp[8].Value = queryField;
sp[9].Value = groupBy;
DataTable temdt = SQLDB.SQLHelper.ExecuteQuery(SqlStr, sp, CommandType.StoredProcedure);
pageCount = Convert.ToInt32(sp[2].Value);
count = Convert.ToInt32(sp[7].Value);
return temdt;
}

 

 

 

 

如上面这段代码解决了 aspnetpager 2次查询问题 哎 学无止境