Question

asp.net中如何调用存储过程实现分页

Answer 1

sql实现分页，asp.net实现显示 也是可以的

Answer 2

如果用AspNetPager1 控件
步骤
1写好存储过程
public static DataTable GetReEvaluation(string testcode,string majorquestionId,string minorQuestionID,
string handledId, int searchType,string searchScore,int pNumber)
{
try
{
DataSet dataSet = new DataSet();
SqlParameter[] parameters ={
new SqlParameter("@PCount",20),
new SqlParameter("@PNumber",pNumber),
};
OMSSqlClientManager.ExecuteStatementBySP("spGetReEvaluation", parameters, out dataSet);
if (dataSet != null && dataSet.Tables.Count > 0)
{
return dataSet.Tables[0];
}
}
catch (Exception ex)
{
log.Error(ex.Message);
log.Error(ex.StackTrace);
}
return null;
}
前台
<td style="text-align:left;">
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" FirstPageText="第一页" LastPageText="最后一页"
PrevPageText="上一页" PageSize="20" CssClass="anpager"
CurrentPageButtonClass="cpb" BorderWidth="0px" Width="600px"
NextPageText="下一页" NumericButtonCount="8"
PageIndexBoxType="TextBox" ShowPageIndexBox="Auto" SubmitButtonText="Go" SubmitButtonClass=""
TextAfterPageIndexBox="页" TextBeforePageIndexBox="转到" LayoutType="Table"
onpagechanged="AspNetPager1_PageChanged" >
</webdiyer:AspNetPager>
</td>
后台 //查询
protected void btnSearch_Click(object sender, EventArgs e)
{
BindGridView(1);
}
private void BindGridView(int pageIndex)
{
//@PCount =50, --每页多少数据
//@PNumber =1 --第几页
DataTable ds = OMSSubjectiveRemarkManager.GetReEvaluation(参数);
if (ds != null && ds.Rows.Count > 0)
{
int allPageCount = Convert.ToInt32(ds.Rows[0]["AllCount"].ToString());
showPage.Style["display"] = "block";
virtual_div.Style["display"] = "block";
AspNetPager1.Visible = true;
AspNetPager1.RecordCount = allPageCount;
pdsStuAction.PageSize = AspNetPager1.PageSize;
pdsStuAction.AllowPaging = true;
pdsStuAction.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pdsStuAction.DataSource = ds.DefaultView;
GridView1.DataSource = ds;
GridView1.DataBind();
PageInfo.Visible = true;
PageInfo.Text = "共<span style='color:Red'>" + allPageCount.ToString() + "</span>条记录 第<span style='color:Red'>" + AspNetPager1.CurrentPageIndex.ToString() + "</span>页/共<span style='color:Red'>" + (allPageCount % AspNetPager1.PageSize == 0 ? (allPageCount / AspNetPager1.PageSize).ToString() : (allPageCount / AspNetPager1.PageSize + 1).ToString()) + "</span>页";
}
else
{
GridView1.DataSource = null;
GridView1.DataBind();
PageInfo.Visible = false;
showPage.Style["display"] = "none";
}
｝

protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
BindGridView(AspNetPager1.CurrentPageIndex);
}