con.Open();

            adapter.Fill(ds,"table");

            con.Close();

            DataTable dt = new DataTable();

            dt = ds.Tables["table"];

            //以下设置控件参数

            this.LzhPages1.AllCount = dt.Rows.Count;//总记录条数

            this.LzhPages1.CurrentPage = cp;//当前页，从URL中读取

            this.LzhPages1.ShowPages = 10;//导航数字个数

            this.LzhPages1.Count = 10;//每页显示的记录条数

            StringBuilder sql = new StringBuilder();

            //以下三个字符串最终组合成一个完整的表格<table>

            string htmlHeader = "";//<table>标签

            string htmlBody = "";//中间有若干个<tr>标签，即行

            string htmlFoot = "";//</table>标签

            sql.AppendFormat("select top {0} * from [Order Details] where 1=1 and OrderID not in (select top {1} OrderID from [Order Details] where 1=1 order by OrderID desc) order by OrderID desc",this.LzhPages1.Count,this.LzhPages1.CurrentPage * this.LzhPages1.Count);

            SqlCommand cmd1 = new SqlCommand(sql.ToString(),con);

            adapter.SelectCommand = cmd1;

            con.Open();

            adapter.Fill(ds,"table1");

            con.Close();

            dt= ds.Tables["table1"];

            htmlHeader =  "<table style=''''font-size:12px'''' border=''''1'''' cellpadding=''''0'''' cellspacing=''''0'''' width=''''100%'''' bordercolor=''''#008000'''' bordercolorlight=''''#008000'''' bordercolordark=''''#FFFFFF''''>\n";

            for(int i = 0;i < dt.Rows.Count ;i ++)

            {

                htmlBody = htmlBody + String.Format("<tr>\n<td width=''''12%''''>{0}</td>\n<td width=''''43%''''>{1}</td>\n<td width=''''24%''''>{2}</td><td width=''''21%''''>{3}</td>\n</tr>\n",dt.Rows[i][0].ToString(),dt.Rows[i][1].ToString(),dt.Rows[i][2].ToString(),dt.Rows[i][3].ToString());

            }

            htmlFoot = "</table>\n";

        this.myHtml.InnerHtml = htmlHeader + htmlBody + htmlFoot;

6、  sql.AppendFormat("select top {0} * from [Order Details] where 1=1 and OrderID not in (select top {1} OrderID from [Order Details] where 1=1 order by OrderID desc) order by OrderID desc",this.LzhPages1.Count,this.LzhPages1.CurrentPage * this.LzhPages1.Count);此语句中的SQL语句就是用来分页的，我们的控件只是用来控制页面，数据还得通过SQL语句或存储过程读取。

7、  结果图：

上一页  [1] [2]