kc.aspx.cs

本文介绍了在Visual Studio.net环境下开发一个教材库管理系统的过程。创建了一套行之有效的方案。文章介绍了管理系统的系统分析部分

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;
using System.Configuration;


namespace jiaocaiku
{
	/// <summary>
	/// kc 的摘要说明。
	/// </summary>
	public class kc : System.Web.UI.Page
	{
		protected Wuqi.Webdiyer.AspNetPager pager1;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (!IsPostBack)
			{
				
				SqlConnection conn= new SqlConnection(ConfigurationSettings.AppSettings["connstr"].ToString());
				string strsql="select count(*) from kc";
				SqlCommand cmd=new SqlCommand(strsql,conn);
				conn.Open();
				pager1.RecordCount=(int)cmd.ExecuteScalar();
				conn.Close();
				bindgrid();
			
				
			}
		}

		protected void bindgrid()
		{
		

			SqlConnection conn= new SqlConnection(ConfigurationSettings.AppSettings["connstr"].ToString());
			string strsql="select * from kc order by id desc";
			SqlDataAdapter da=new SqlDataAdapter(strsql,conn);
			DataSet ds=new DataSet();
			da.Fill(ds,pager1.PageSize*(pager1.CurrentPageIndex-1),pager1.PageSize,"kc");
			da.Fill(ds,"alldatatable");
			DataGrid1.VirtualItemCount=ds.Tables["alldatatable"].Rows.Count;

			DataGrid1.DataSource=ds.Tables["kc"];
			DataGrid1.DataBind();
			pager1.CustomInfoText=" 当前为第<font color=\"red\"><b>"+pager1.CurrentPageIndex.ToString()+"</b></font>页,";
			pager1.CustomInfoText+="共有<font color=\"blue\"><b>"+pager1.PageCount.ToString()+"</b></font>页,";
			pager1.CustomInfoText+="共有<font color=\"blue\"><b>"+pager1.RecordCount.ToString()+"</b></font>条新闻";
		
			
			da.Dispose();
			conn.Close();



		}



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

		}
		#endregion

		private void pager1_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
		{
			pager1.CurrentPageIndex=e.NewPageIndex;
			bindgrid();
		}
	}
}