using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace SampleCS
{
///
/// °í±ÞÆäÀÌ¡Å×½ºÆ®¿¡ ´ëÇÑ ¿ä¾à ¼³¸íÀÔ´Ï´Ù.
///
public class °í±ÞÆäÀÌ¡Å×½ºÆ® : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected int intPage = 0;//°í±Þ2 : ¸î¹ø° ÆäÀÌÁö¸¦ º¸¿©ÁÙ°ÇÁö
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
this.DataGrid1.VirtualItemCount = 10000;//°í±Þ1
ReadData();
}
}
private void ReadData()
{
SqlConnection objCon = new SqlConnection(
"server=(local);database=Sample;uid=Sample;pwd=Sample");
objCon.Open();
SqlCommand objCmd = new SqlCommand();
objCmd.Connection = objCon;
//30 -> " + º¯¼ö + "
objCmd.CommandText =
"Select Top 10 Num From PagingTest Where Num Not In (Select Top " + intPage*10 + " Num From PagingTest Order By Num Desc) Order By Num Desc";//°í±Þ3
objCmd.CommandType = CommandType.Text;
SqlDataAdapter objDa = new SqlDataAdapter();
objDa.SelectCommand = objCmd;
DataSet objDs = new DataSet();
objDa.Fill(objDs, "PagingTest");
this.DataGrid1.DataSource = objDs;
this.DataGrid1.DataBind();
}
#region Web Form µðÀÚÀ̳ʿ¡¼ »ý¼ºÇÑ ÄÚµå
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: ÀÌ È£ÃâÀº ASP.NET Web Form µðÀÚÀ̳ʿ¡ ÇÊ¿äÇÕ´Ï´Ù.
//
InitializeComponent();
base.OnInit(e);
}
///
/// µðÀÚÀÌ³Ê Áö¿ø¿¡ ÇÊ¿äÇÑ ¸Þ¼µåÀÔ´Ï´Ù.
/// ÀÌ ¸Þ¼µåÀÇ ³»¿ëÀ» ÄÚµå ÆíÁý±â·Î ¼öÁ¤ÇÏÁö ¸¶½Ê½Ã¿À.
///
private void InitializeComponent()
{
this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
intPage = e.NewPageIndex;//°í±Þ4
this.DataGrid1.CurrentPageIndex = e.NewPageIndex;
ReadData();
}
}
}