初學者做網站

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
mygDB(); 
}

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{
GridView1.PageIndex = e.NewPageIndex;
mygDB();
}

protected void mygDB()
{
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=mydata;User Id=sa;Password=1234");
conn.Open();

SqlCommand cmd = new SqlCommand("Select * From Item_Detail", conn);
SqlDataReader dr = cmd.ExecuteReader();

DataTable dt = new DataTable();
dt.Load(dr);

GridView1.DataSource = dt.AsDataView();
GridView1.DataBind();
}

原始檔

<asp:GridView ID="GridView1" runat="server" OnPageIndexChanging ="GridView1_PageIndexChanging"
AllowPaging="True" Height="157px">

如果要使用分頁 ... 要有 PageIndexChanging

且把 原始檔 asp: ........... 改成 OnPageIndexChanging ="GridView1_PageIndexChanging"