这里是计算一共有多少页数
protected void CalcRecord()
{
DataTable dt= Mehod.Return("select COUNT(*) from T_FriendList tf join T_User tu on tf.Friend_id=tu.userid join T_Say ts on tf.Friend_id=ts.[User_id] where tf.[User_id]=@userid", CommandType.Text,new SqlParameter("@userid",Session["user"].ToString()));
if (dt.Rows.Count != 0)
{
int totle =Convert.ToInt32(dt.Rows[0][0].ToString());
if (totle % 10 == 0)
{
ViewState["pagenums"] = totle / 10;
}
else
{
ViewState["pagenums"] = totle / 10 + 1;
}
}
}
这里是创建导航
dh.Controls.Clear();
for (int i = 1; i <= Convert.ToInt32(ViewState["pagenums"].ToString()); i++)
{
LinkButton btn = new LinkButton();
btn.BackColor = System.Drawing.Color.Aqua;
btn.BorderStyle = BorderStyle.Groove;
btn.BorderColor = System.Drawing.Color.Red;
btn.Text = i.ToString();
btn.Command += new CommandEventHandler(btn_Command);
if (!dh.Controls.Contains(btn))
{
dh.Controls.Add(btn);
}
}