C#生成静态页面的分页程序

代码如下

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;
using System.Text;

public partial class Default4 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ //定义参数
StreamWriter sw = null;
string htmlfilename;
string path = HttpContext.Current.Server.MapPath(“html/”);
// 数据库生成分页

int onepage=10;
string ConnectionString = “连接字符串”;
SqlConnection myConnection = new SqlConnection(ConnectionString);
string sSelect = “SELECT count(*) as pcount from 表名”;
SqlCommand cmd = new SqlCommand(sSelect,myConnection);
myConnection.Open();
SqlDataReader Dr = cmd.ExecuteReader();
Dr.Read();
int Count=int.Parse(Dr["pcount"].ToString());

int allpages=Count/onepage;

for (int i = 0;i<allpages; i++)
{



htmlfilename = “index_”+”"+i+”"+”.html”;

int start = i * onepage;

int nextpage=i+1;
int perpage=i-1;

if (nextpage==allpages)
{
nextpage=i;
}

if (perpage==-1)
{
perpage=0;

}


// 写文件
try
{


SqlConnection gConnection = new SqlConnection(ConnectionString);
gConnection.Open();
string vQuery = “SELECT TOP “+onepage+” * FROM 表名 WHERE (ID NOT IN (SELECT TOP “+start+” Id FROM 表名 ORDER BY id)) ORDER BY ID”;
SqlDataAdapter vmd = new SqlDataAdapter(vQuery,gConnection);
DataSet ds=new DataSet();
vmd.Fill(ds,”table1″);
DataTable dt=ds.Tables["table1"];



sw = new StreamWriter(path + htmlfilename , false, Encoding.GetEncoding(“GB2312″));
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(“”+dr["字段名"].ToString()+dr["字段名"]+”<br>”);
}

sw.WriteLine(“<a href=”+”index_”+”"+perpage+”"+”.html”+”>上一页</a>”);
sw.WriteLine(“<a href=”+”index_”+”"+nextpage+”"+”.html”+”>下一页</a>”);
sw.Flush();
}
catch(Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
HttpContext.Current.Response.End();
}
finally
{
sw.Close();
}
}
}
}