list.aspx.cs

具有一般blog的相册、文章、作品等功能程序结构也比较清晰采用三层结构开发（利用了SQLHelper.cs（源码））采用了UrlReWrite技术后台采用FTB(FreeTextBox)编辑器

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 liuwei.FrameWork.DB;

namespace liuwei.admin
{
	/// <summary>
	/// list 的摘要说明。
	/// </summary>
	public class list : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.DropDownList ddSmallType;
		private string smallTypeID;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			smallTypeID=Request.QueryString["smalltypeid"];
			if (smallTypeID==null||smallTypeID=="")
			{
				smallTypeID="0";
			}
			if (!Page.IsPostBack)
			{
				DataTable dt = DbProvider.Instance().GetContentAdmin(Convert.ToInt32(smallTypeID));
				DataGrid1.DataSource = dt;
				DataGrid1.DataBind();
				dt.Clear();
				dt.Dispose();

				DataTable dtSmallType = DbProvider.Instance().GetSmallTypeListAll();
				ddSmallType.DataSource = dtSmallType;
				ddSmallType.DataTextField = "smalltypename";
				ddSmallType.DataValueField = "smalltypeid";
				if (smallTypeID!="0")
				{
					ddSmallType.SelectedValue = smallTypeID;
				}
				ddSmallType.DataBind();

				dtSmallType.Clear();
				dtSmallType.Dispose();
			}
		}

		public void DataGrid_Page(object sender, DataGridPageChangedEventArgs e) 
		{

			DataGrid1.CurrentPageIndex = e.NewPageIndex;
			try
			{
				DataTable dt = DbProvider.Instance().GetContentAdmin(Convert.ToInt32(smallTypeID));
				DataGrid1.DataSource = dt;
				DataGrid1.DataBind();
				dt.Clear();
				dt.Dispose();
			}
			catch(System.Data.SqlClient.SqlException er)
			{
				throw new Exception(er.Message);
			}
		}

		public void DataGrid_Delete(object sender, DataGridCommandEventArgs e) 
		{

			// delete the selected row
			string postID = e.Item.Cells[0].Text;
			DbProvider.Instance().DelContent(Convert.ToInt32(postID));
			DataGrid1.CurrentPageIndex = 0;
			DataGrid1.EditItemIndex = -1;
			Response.Redirect ("list.aspx");
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ddSmallType.SelectedIndexChanged += new System.EventHandler(this.ddSmallType_SelectedIndexChanged);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void ddSmallType_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			Response.Redirect ("list.aspx?smalltypeid=" + ddSmallType.SelectedValue);
		}
	}
}