myzhuti.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;


namespace free.bbs
{
	/// <summary>
	/// Summary description for myzhuti.
	/// </summary>
	public class myzhuti : System.Web.UI.Page
	{
		protected System.Web.UI.HtmlControls.HtmlTable table_1;
		protected  const int  Record_Per_Page=40; //'定义每一页显示的记录数
		protected int nRecCount ; //保存记录总数
		protected int nPageCount;  //保存总共的数据页面数目
		protected int nPage;     //存放要浏览当前数据页面号
		protected int nStart ; // 存放当前页面的起始记录序号
		protected int nEnd;     //存放当前页面的终止记录序号
		protected int  nPageEnd;  //存储当前页面的最后一面的序号 

		protected System.Data.SqlClient.SqlConnection myconn;
		protected System.Data.SqlClient.SqlCommand mycomm;
		protected System.Data.SqlClient.SqlDataReader reader;
		protected System.Data.SqlClient.SqlDataAdapter mydda;
		HtmlTableRow myrow;
		HtmlTableCell mycell;
		string h_yonghuming,h_shijian;
		
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			try
			{
				string yonghuming=Request.Cookies["free_huiyuan"].Value.ToString();
				if(yonghuming=="dengchu")
				{
					Response.Redirect("error.aspx");
				}
			}
			catch 
			{
				Response.Redirect("error.aspx");
			}
			myconn=new SqlConnection(Session["str_connection"].ToString());
			string sqlselect="SELECT islock,isceam, isfix, zhuti, yonghuming, postid, neirong, shijian,ancestor_id FROM posts WHERE (yonghuming ='"+Request.Cookies["free_huiyuan"].Value.ToString()+"') ORDER BY isfix desc ,postid desc";
			mydda=new SqlDataAdapter(sqlselect,myconn);
			myconn.Open();
			DataSet ds=new DataSet(); 
			mydda.Fill(ds,"myzhuti");
			nPage = Convert.ToInt32 ( Request.Params[ "Page"] );//得到当前页号
			try