]小弟在用gridview绑定数据,自动分页的时候不管点第几页都是显示第一页,不知道错在哪里了,请高手指点一下:
属性代码
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" CellPadding="4"
ForeColor="#333333" GridLines="None" onpageindexchanged="PageIndexChanged"
onpageindexchanging="PageIndexChanging">
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#E3EAEB" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#7C6F57" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
-----------------
操作代码:
protected SqlConnection conn = new SqlConnection();
protected SqlDataAdapter sda = new SqlDataAdapter();
protected DataSet ds=new DataSet(); protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
bind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
bind();
}
protected void bind()
{
string str_conn = "server=(local);database=web;user id=sa;password=sasasa";
conn.ConnectionString = str_conn;
string fun = "select * from Fare";
SqlCommand fun_cmd = new SqlCommand(fun, conn);
sda.SelectCommand = fun_cmd;
sda.Fill(ds, "Fare");
GridView1.DataSource = ds.Tables["Fare"];
GridView1.DataBind();
}
protected void PageIndexChanged(object sender, EventArgs e)
{
bind();
} protected void PageIndexChanging(object sender, GridViewPageEventArgs e)
{ }
属性代码
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" CellPadding="4"
ForeColor="#333333" GridLines="None" onpageindexchanged="PageIndexChanged"
onpageindexchanging="PageIndexChanging">
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#E3EAEB" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#7C6F57" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
-----------------
操作代码:
protected SqlConnection conn = new SqlConnection();
protected SqlDataAdapter sda = new SqlDataAdapter();
protected DataSet ds=new DataSet(); protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
bind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
bind();
}
protected void bind()
{
string str_conn = "server=(local);database=web;user id=sa;password=sasasa";
conn.ConnectionString = str_conn;
string fun = "select * from Fare";
SqlCommand fun_cmd = new SqlCommand(fun, conn);
sda.SelectCommand = fun_cmd;
sda.Fill(ds, "Fare");
GridView1.DataSource = ds.Tables["Fare"];
GridView1.DataBind();
}
protected void PageIndexChanged(object sender, EventArgs e)
{
bind();
} protected void PageIndexChanging(object sender, GridViewPageEventArgs e)
{ }
{
gv.PageIndex = e.NewPageIndex;//指定下当前页码嘛
}
{
GridView1.PageIndex = e.NewPageIndex;
Gvbind();
}
正解, 你可以调试 时候看下 e.NewPageIndex;GridView1.PageIndex 的值 就理解了