数据库里面有10记录,设置每页显示1条.可是只显示第一页.后面的都没了~~~求助一下..3Q
<asp:datagrid id="ShowEdu" runat="server" Width="536px" AutoGenerateColumns="False" OnPageIndexChanged="ShowEdu_Page"
PageSize="1" AllowPaging="True" AllowCustomPaging=True GridLines="Both">
<AlternatingItemStyle BackColor="#EEEEEE"></AlternatingItemStyle>
<HeaderStyle BackColor="#AAAADD" Font-Bold="True" HorizontalAlign="Center"></HeaderStyle>
<PagerStyle HorizontalAlign="Right" Mode="NumericPages"></PagerStyle>
<Columns>
<asp:TemplateColumn HeaderText="问题标题">
<ItemTemplate>
<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Subject") %>' ID="Subject"/>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="发送人">
<ItemTemplate>
<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "SenderName") %>' ID="SenderName"/>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="电子邮件">
<ItemTemplate>
<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Email") %>' ID="Email"/>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="填写时间">
<ItemTemplate>
<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "addtime") %>' ID="StartYear"/>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="客户IP">
<ItemTemplate>
<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "AddIp") %>' ID="AddIp"/>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="处理">
<ItemTemplate>
<a href='Admin_Idea_Edit.aspx?ID=<%# DataBinder.Eval(Container,"DataItem.ID") %>' target=_self >
修改</a>| <a href='admin_Idea_Del.aspx?ID=<%# DataBinder.Eval(Container,"DataItem.ID") %>' target=_self >
删除</a>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid></td>
</tr>
</tbody>
</table>
<table cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td>
<asp:label id="lblPageCount" runat="server"></asp:label>&nbsp;
<asp:label id="lblCurrentIndex" runat="server"></asp:label>
<asp:linkbutton id="btnFirst" onclick="PagerButtonClick" runat="server" Font-Name="verdana" Font-size="8pt"
ForeColor="navy" CommandArgument="0"></asp:linkbutton>&nbsp;
<asp:linkbutton id="btnPrev" onclick="PagerButtonClick" runat="server" Font-Name="verdana" Font-size="8pt"
ForeColor="navy" CommandArgument="prev"></asp:linkbutton>&nbsp;
<asp:linkbutton id="btnNext" onclick="PagerButtonClick" runat="server" Font-Name="verdana" Font-size="8pt"
ForeColor="navy" CommandArgument="next"></asp:linkbutton>&nbsp;
<asp:linkbutton id="btnLast" onclick="PagerButtonClick" runat="server" Font-Name="verdana" Font-size="8pt"
ForeColor="navy" CommandArgument="last"></asp:linkbutton>
</td>
</tr>
</table>
aspx.cs
private SqlConnection Conn=new SqlConnection();
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
btnFirst.Text = "最首页";
btnPrev.Text = "前一页";
btnNext.Text = "下一页";
btnLast.Text = "最后页"; OpenDatabase();
BindGrid();
}
private void OpenDatabase()
{
Conn.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
Conn.Open();
}
private void ShowStats()
{
lblCurrentIndex.Text = "第 " + (ShowEdu.CurrentPageIndex + 1).ToString() + " 页";
lblPageCount.Text = "总共 " + ShowEdu.PageCount.ToString() + " 页";
} public void PagerButtonClick(object sender, EventArgs e)
{
string arg = ((LinkButton)sender).CommandArgument.ToString();
switch(arg)
{
case "next":
if (ShowEdu.CurrentPageIndex < (ShowEdu.PageCount - 1))
{
ShowEdu.CurrentPageIndex += 1;
}
break;
case "prev":
if (ShowEdu.CurrentPageIndex > 0)
{
ShowEdu.CurrentPageIndex -= 1;
}
break;
case "last":
ShowEdu.CurrentPageIndex = (ShowEdu.PageCount - 1);
break;
default:
ShowEdu.CurrentPageIndex = System.Convert.ToInt32(arg);
break;
}
BindGrid();
ShowStats();
}
public void BindGrid()
{
string Sql = "SELECT * from IdeaTB ";
SqlConnection con = Conn;
SqlCommand cmd = new SqlCommand(Sql,con);
DataSet ds  = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(Sql,con);
adapter.Fill(ds, "IdeaTB");
ShowEdu.DataSource = ds.Tables["IdeaTB"].DefaultView;
ShowEdu.DataBind();
ShowStats();
}
public void ShowEdu_Page(object sender, DataGridPageChangedEventArgs e)
{
int startIndex ;
startIndex = ShowEdu.CurrentPageIndex * ShowEdu.PageSize;
ShowEdu.CurrentPageIndex = e.NewPageIndex;
BindGrid();
ShowStats();
}