Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)delvpublished in(发表于) 2014/1/23 3:12:52 C#生成静态页面的分页程序_[Asp.Net教程]
代码如下
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 { 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["字段名"]+""); } sw.WriteLine("上一页"); sw.WriteLine("下一页"); sw.Flush(); } catch(Exception ex) { HttpContext.Current.Response.Write(ex.Message); HttpContext.Current.Response.End(); } finally { sw.Close(); } } } }
赞