求教~VS2010+SQL SERVER2008如何使用aspnetpager控件分页
VS2010+SQL SERVER2008如何使用aspnetpager控件分页 --------------------编程问答--------------------都大同小异，没什么区别的，详细的看aspnetpager官网！ --------------------编程问答-------------------- 这个跟VS以及SQL也没什么关系吧.. --------------------编程问答-------------------- 你还用自带的分页控件》》》》》》》》 --------------------编程问答-------------------- 都一样吧 版本不是向下兼容吗 --------------------编程问答-------------------- 都一样的 设置好初始页 有几页 和在第几页就好了PageIndex, PageSize, out RecordCount 这三个值设置好久好了 --------------------编程问答-------------------- aspNetPager.PageSize = PageSize;
PageIndex = aspNetPager.CurrentPageIndex;
aspNetPager.RecordCount = RecordCount;//总记录数
方法
getAllByViewPage(sqbm, a, b, DropDownList1.SelectedValue, PageIndex, PageSize, out RecordCount); --------------------编程问答--------------------
private void getSource()
{
#region 组建查询条件
string where = " where 1= 1 and t.t_u_id=" + user.U_em_id;
if (ddlState.SelectedValue != "100")
{
where += " and t.t_state = " + ddlState.SelectedValue;
}
if (ddlIsRead.SelectedValue != "100")
{
where += " and t.t_isread = " + ddlIsRead.SelectedValue;
}
string begin = "";
string end = "";
DateTime d_begin = DateTime.Now;
DateTime d_end = DateTime.Now;
try
{
if (!string.IsNullOrEmpty(txtBegin.Text.Trim()))
{
begin = txtBegin.Text.Trim() + "00:00:00";
d_begin = DateTime.Parse(begin);
}
if (!string.IsNullOrEmpty(txtEnd.Text.Trim()))
{
end = txtEnd.Text.Trim() + "23:59:59";
d_end = DateTime.Parse(end);
}
if ((!string.IsNullOrEmpty(begin)) && (!string.IsNullOrEmpty(end)))
{
where += " and t.t_orderDate between '" + d_begin + "' and '" + d_end + "'";
}
else if ((!string.IsNullOrEmpty(begin)))
{
where += " and t.t_orderDate >= '" + d_begin + "' ";
}
else if ((!string.IsNullOrEmpty(end)))
{
where += " and t.t_orderDate between <= '" + end + "'";
}
}
catch (Exception ex)
{
throw new Exception("请输入正确的日期，格式为'2012-01-01'");
}
#endregion
string strSql = "select t.*,e1.em_name as sub_name ,e2.em_name readName from timeorder t left join employee e1 on t.t_u_id = e1.id left join employee e2 on t.t_readerid= e2.id";
dt = DBUtility.DbHelper.Query(strSql + where).Tables[0];
}
private void bindList()
{
PagedDataSource page = new PagedDataSource();
AspNetPager1.RecordCount = dt.Rows.Count;
page.DataSource = dt.DefaultView as DataView;
page.AllowPaging = true;
page.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
page.PageSize = AspNetPager1.PageSize;
gvList.DataSource = page;
gvList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
getSource();
bindList();
}
}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
bindList();
}
补充：.NET技术 , ASP.NET
