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=" 當(dāng)前為第<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 窗體設(shè)計(jì)器生成的代碼
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 該調(diào)用是 ASP.NET Web 窗體設(shè)計(jì)器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設(shè)計(jì)器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內(nèi)容。
		/// </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();
		}
	}
}