private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
this.DGBind();
}
//
// SqlConnection con=DB.CreateDB();
// SqlCommand cmd=new SqlCommand("select * from new",con);
// con.Open();
// SqlDataAdapter sda=new SqlDataAdapter();
// sda.SelectCommand=new SqlCommand("select * from news",con);
// DataSet ds=new DataSet();
// sda.Fill(ds,"emp");
// this.DG.DataSource=ds.Tables["emp"];
// this.DG.DataBind();
}
#region Web Form 設計工具產生的程式碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 此為 ASP.NET Web Form 設計工具所需的呼叫。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 此為設計工具支援所必須的方法 - 請勿使用程式碼編輯器修改
/// 這個方法的內容。
/// </summary>
private void InitializeComponent()
{
this.DG.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DG_PageIndexChanged);
this.DG.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void DGBind()
{
SqlConnection con=DB.CreateDB();
SqlCommand cmd=new SqlCommand("select * from news order by Newstime desc",con);
con.Open();
SqlDataAdapter sda=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
sda.Fill(ds,"emp");
this.DG.DataSource=ds.Tables["emp"];
this.DG.DataBind();
}
private void DG_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
this.DG.CurrentPageIndex=e.NewPageIndex;
this.DGBind();
}