大家可能遇到的问题:
这个是写在一个类文件里面的class OperateData
public SqlDataAdapter GetList( string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select PostID,PostUserID,PostTitle,PostContent,CONVERT(varchar(12),PostTime,111) PostTime ");
strSql.Append(" FROM PostInfo Order by PostID Desc");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
SqlConnection con=new SqlConnection(DbHelperSQL.connectionString);
SqlDataAdapter sda = new SqlDataAdapter(strSql.ToString(),con);
return sda;
}
public SqlDataAdapter GetList( string strWhere)












这个是写在页面代码中的
OperateData operatedata
=
new
OperateData();
protected
void
Page_Load(
object
sender, EventArgs e)
{
ShowDataList();
PageCount();//显示当前数
}
private
void
ShowDataList()
{
SqlDataAdapter sda = operatedata.GetList("");
DataSet ds = new DataSet();
sda.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "PostInfo");
this.RepeaterList.DataSource = ds.Tables["PostInfo"].DefaultView;
this.RepeaterList.DataBind();
}
private
void
PageCount()
{
this.AspNetPager1.RecordCount=operatedata.PageCount("");//数据总数
}
protected
void
AspNetPager1_PageChanging(
object
src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
ShowDataList();
}























