这两天正在学习DataGrid,我的代码,很简单,查了白天资料,搞了半天,那个分页的">"老是点不了:
ASPX:
<asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 272px; POSITION: absolute; TOP: 152px"
runat="server" AutoGenerateColumns="False" AllowPaging="True" PageSize="5" AllowCustomPaging="true">
<Columns>
<asp:BoundColumn DataField="ProductID" HeaderText="产品ID"></asp:BoundColumn>
<asp:BoundColumn DataField="ProductName" HeaderText="产品名称"></asp:BoundColumn>
<asp:BoundColumn DataField="QuantityPerUnit" HeaderText="数量"></asp:BoundColumn>
<asp:BoundColumn DataField="UnitPrice" HeaderText="单价"></asp:BoundColumn>
<asp:BoundColumn DataField="UnitsInStock" HeaderText="每股"></asp:BoundColumn>
</Columns>
</asp:DataGrid>
CS:
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack){
BindGrid();
}
} private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
//Response.Write("fanle!!!!");
DataGrid1.CurrentPageIndex=e.NewPageIndex;
BindGrid();
} public void BindGrid()
{
SqlConnection myConnection = new SqlConnection(@"server=(local);database=NorthWind;uid=sa;pwd=;");
myConnection.Open();
SqlCommand myCommand = new SqlCommand("select * from Products",
myConnection);
SqlDataAdapter dataAdapter = new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
dataAdapter.Fill(ds); DataGrid1.DataSource=ds;
DataGrid1.DataBind();
myConnection.Close();
}
ASPX:
<asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 272px; POSITION: absolute; TOP: 152px"
runat="server" AutoGenerateColumns="False" AllowPaging="True" PageSize="5" AllowCustomPaging="true">
<Columns>
<asp:BoundColumn DataField="ProductID" HeaderText="产品ID"></asp:BoundColumn>
<asp:BoundColumn DataField="ProductName" HeaderText="产品名称"></asp:BoundColumn>
<asp:BoundColumn DataField="QuantityPerUnit" HeaderText="数量"></asp:BoundColumn>
<asp:BoundColumn DataField="UnitPrice" HeaderText="单价"></asp:BoundColumn>
<asp:BoundColumn DataField="UnitsInStock" HeaderText="每股"></asp:BoundColumn>
</Columns>
</asp:DataGrid>
CS:
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack){
BindGrid();
}
} private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
//Response.Write("fanle!!!!");
DataGrid1.CurrentPageIndex=e.NewPageIndex;
BindGrid();
} public void BindGrid()
{
SqlConnection myConnection = new SqlConnection(@"server=(local);database=NorthWind;uid=sa;pwd=;");
myConnection.Open();
SqlCommand myCommand = new SqlCommand("select * from Products",
myConnection);
SqlDataAdapter dataAdapter = new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
dataAdapter.Fill(ds); DataGrid1.DataSource=ds;
DataGrid1.DataBind();
myConnection.Close();
}
2.查看翻页事件是否丢失...
this.ListView.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.ListView_PageIndexChanged);