<Table>实现分页

前台：

<div>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:Button ID="Button3"
            runat="server" Text="搜索" onclick="Button3_Click" />
        <asp:Button ID="Button4" runat="server" Text="首页" onclick="Button4_Click" />
        <asp:Button ID="Button1" runat="server" Text="上一页" onclick="Button1_Click" />
        <asp:Button ID="Button2"
            runat="server" Text="下一页" onclick="Button2_Click" />
        <asp:Button ID="Button5" runat="server" Text="尾页" onclick="Button5_Click" />
        <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
            <div id=d1 runat=server></div>
    </div>

后台：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.Text;

namespace 新闻查询
{
    public partial class 分页 : System.Web.UI.Page
    {
        static int max = 0;//最大页数（整除index后的值）
        static int index = 0;//当前页数
        static int count = 0;//总数据条数
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                load();
            }
            if (TextBox1.Text.Length == 0)
            {
                using (SqlConnection conn = new SqlConnection(connstr))
                {
                    using (SqlCommand cmd = conn.CreateCommand())
                    {
                        conn.Open();
                        cmd.CommandText = "select * from T_News";
                        DataTable dt = new DataTable();
                        SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                        adapter.Fill(dt);
                        max = dt.Rows.Count / 3;//最大的页数
                        count = dt.Rows.Count;//总条数
                    }
                }
            }
            else//搜索的时候
            {
                using (SqlConnection conn = new SqlConnection(connstr))
                {
                    using (SqlCommand cmd = conn.CreateCommand())
                    {
                        conn.Open();
                        cmd.CommandText = " select * from T_News where (NewsTitle like '%" + TextBox1.Text + "%' or NewsContent like '%" + TextBox1.Text + "%') order by Id";
                        //cmd.Parameters.AddWithValue("@L", "%" + TextBox1.Text + "%");
                        DataTable dt = new DataTable();
                        SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                        adapter.Fill(dt);
                        max = dt.Rows.Count / 3;//最大的页数
                        count = dt.Rows.Count;//总条数
                    }
                }
            }
           
        }
        string connstr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
        protected void Button3_Click(object sender, EventArgs e)
        {
            load();
        }

        private void load()
        {
           

 

            using (SqlConnection conn = new SqlConnection(connstr))
            {
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    //conn.Open();
                    //cmd.CommandText = "select NewsTitle,NewsContent,CreateTime from T_News where NewsTitle like @L or NewsContent like @L";
                    //cmd.Parameters.AddWithValue("@L", "%" + TextBox1.Text + "%");
                    //DataTable dt = new DataTable();
                    //SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    //adapter.Fill(dt);
                    //StringBuilder sb = new StringBuilder();
                    //sb.Append("<table>");
                    //for (int i = 0; i < dt.Rows.Count; i++)
                    //{
                    //    sb.Append("<tr>");
                    //    sb.Append("<td>");
                    //    sb.Append(dt.Rows[i]["NewsTitle"].ToString());
                    //    sb.Append("</td>");
                    //    sb.Append("<td>");
                    //    sb.Append(dt.Rows[i]["NewsContent"].ToString());
                    //    sb.Append("</td>");
                    //    sb.Append("<td>");
                    //    sb.Append(dt.Rows[i]["CreateTime"].ToString());
                    //    sb.Append("</td>");
                    //    sb.Append("</tr>");
                    //}
                    //sb.Append("</table>");
                    //d1.InnerHtml = sb.ToString();
                    conn.Open();
                    cmd.CommandText = "aa";
                    SqlParameter p = new SqlParameter("@ss", "%" + TextBox1.Text + "%");
                    SqlParameter p2 = new SqlParameter("@count",SqlDbType.Int);
                    p2.Direction = ParameterDirection.Output;
                    cmd.Parameters.Add(p);
                    cmd.Parameters.Add(p2);
                    cmd.CommandType=CommandType.StoredProcedure;
                    DataTable dt = new DataTable();
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(dt);
                    Response.Write(p2.Value.ToString());
                    StringBuilder sb = new StringBuilder();
                    sb.Append("<table>");
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["NewsTitle"].ToString());
                        sb.Append("</td>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["NewsContent"].ToString());
                        sb.Append("</td>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["CreateTime"].ToString());
                        sb.Append("</td>");
                        sb.Append("</tr>");
                    }
                    sb.Append("</table>");
                    d1.InnerHtml = sb.ToString();
                }
            }
        }
       
        protected void Button1_Click(object sender, EventArgs e)
        {
            if (index > 1)
            {
                index--;
            }
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    conn.Open();
                    cmd.CommandText = "select top 3 NewsTitle,NewsContent,CreateTime from T_News where Id not in(select top " + Convert.ToString((index - 1) * 3) + " Id from T_News where NewsTitle like @L or NewsContent like @L order by Id) and (NewsTitle like @L or NewsContent like @L) order by Id";//当sql语句中like%%表示搜索所有内容。like%国%表示搜索带有国字的内容，此处偷懒所以没有判断是否是搜索。因为默认like%%就是搜索所有的内容，否则为搜索模式
                    cmd.Parameters.AddWithValue("@L", "%" + TextBox1.Text + "%");
                    DataTable dt = new DataTable();
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(dt);
                    StringBuilder sb = new StringBuilder();
                    sb.Append("<table>");
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["NewsTitle"].ToString());
                        sb.Append("</td>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["NewsContent"].ToString());
                        sb.Append("</td>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["CreateTime"].ToString());
                        sb.Append("</td>");
                        sb.Append("</tr>");
                    }
                    sb.Append("</table>");
                    d1.InnerHtml = sb.ToString();
                }
            }
        }
      
        protected void Button2_Click(object sender, EventArgs e)
        {
            if (count % 3 == 0)
            {
                if (index < max)
                {
                    index++;
                }
            }
            else
            {
                if (index <= max)
                {
                    index++;
                }
            }
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    conn.Open();
                    cmd.CommandText = "select top 3 NewsTitle,NewsContent,CreateTime from T_News where Id not in(select top " + Convert.ToString((index - 1) * 3) + " Id from T_News where NewsTitle like @L or NewsContent like @L order by Id) and (NewsTitle like @L or NewsContent like @L) order by Id";
                    cmd.Parameters.AddWithValue("@L", "%" + TextBox1.Text + "%");

                    DataTable dt = new DataTable();
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(dt);
                    StringBuilder sb = new StringBuilder();
                    sb.Append("<table>");
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["NewsTitle"].ToString());
                        sb.Append("</td>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["NewsContent"].ToString());
                        sb.Append("</td>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["CreateTime"].ToString());
                        sb.Append("</td>");
                        sb.Append("</tr>");
                    }
                    sb.Append("</table>");
                    d1.InnerHtml = sb.ToString();
                }
            }
        }

        protected void Button4_Click(object sender, EventArgs e)
        {
            index = 1;
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    conn.Open();
                    cmd.CommandText = "select top 3 NewsTitle,NewsContent,CreateTime from T_News where Id not in(select top " + Convert.ToString((index - 1) * 3) + " Id from T_News where NewsTitle like @L or NewsContent like @L order by Id) and (NewsTitle like @L or NewsContent like @L) order by Id";
                    cmd.Parameters.AddWithValue("@L", "%" + TextBox1.Text + "%");

                    DataTable dt = new DataTable();
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(dt);
                    StringBuilder sb = new StringBuilder();
                    sb.Append("<table>");
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["NewsTitle"].ToString());
                        sb.Append("</td>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["NewsContent"].ToString());
                        sb.Append("</td>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["CreateTime"].ToString());
                        sb.Append("</td>");
                        sb.Append("</tr>");
                    }
                    sb.Append("</table>");
                    d1.InnerHtml = sb.ToString();
                }
            }
           
        }

        protected void Button5_Click(object sender, EventArgs e)
        {
            if (count % 3 == 0)
            {
                index = max;
            }
            else
            {
                index = max + 1;
            }
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    conn.Open();
                    cmd.CommandText = "select top 3 NewsTitle,NewsContent,CreateTime from T_News where Id not in(select top " + Convert.ToString((index - 1) * 3) + " Id from T_News where NewsTitle like @L or NewsContent like @L order by Id) and (NewsTitle like @L or NewsContent like @L) order by Id";
                    cmd.Parameters.AddWithValue("@L", "%" + TextBox1.Text + "%");

                    DataTable dt = new DataTable();
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(dt);
                    StringBuilder sb = new StringBuilder();
                    sb.Append("<table>");
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["NewsTitle"].ToString());
                        sb.Append("</td>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["NewsContent"].ToString());
                        sb.Append("</td>");
                        sb.Append("<td>");
                        sb.Append(dt.Rows[i]["CreateTime"].ToString());
                        sb.Append("</td>");
                        sb.Append("</tr>");
                    }
                    sb.Append("</table>");
                    d1.InnerHtml = sb.ToString();
                }
            }
        }
    }
}

 SQL存储过程：

create proc aa
 @ss nvarchar(20),
 @count int out
 as
 select NewsTitle,NewsContent,CreateTime from T_News where NewsTitle like @ss or NewsContent like @ss
 select @count=COUNT(*) from T_News where NewsTitle like @ss or NewsContent like @ss
 
 declare @o int;
 exec aa '%国%',@o out
 print @o;