高手看看啊 DataGrid控件为何不能分页！

loveskyline 2003-12-02 10:50:35

可以正常读数据库，可以显示分页按钮，但分页时始终是首页。
<%@ Page language="c#"%>
<%@ import Namespace="System.Data.SqlClient" %>
<%@ import Namespace="System.Data" %>
<script language=C# runat=server>
void Page_Load(){
string strSelect="select * from news order by id desc";
string strConnect="server=191.168.0.0;uid=jiu;pwd=jiu1903;database=jiu";
DataSet objDataSet=new DataSet();
SqlConnection objConnection=new SqlConnection(strConnect);
SqlDataAdapter objDataAdapter=new SqlDataAdapter(strSelect,objConnection);
objDataAdapter.Fill(objDataSet,"news");
DataView objDataView=new DataView(objDataSet.Tables["news"]);
Mumushu.DataSource=objDataView;
Mumushu.DataBind();
}
</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">

<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
<form runat=server>
<asp:DataGrid ID="Mumushu" Runat=server
AllowPaging="true"
PageSize=10
PagerStyle-Mode=NumericPages
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
/>
</form>
</td>
</tr>
</table>
</body>
</HTML>

...全文

26 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

loveskyline 2003-12-02

打赏
举报

问题以经解决，谢谢，各位高人鼎立相住哦。

felixl 2003-12-02

打赏
举报

分页属性设置完，要添加分页函数的，方法楼上的大哥说的已经很清楚了！

ponycsdn 2003-12-02

打赏
举报

都是星级高手，小弟不敢多言。hgknight(江雨.net) 同意

hgknight 2003-12-02

打赏
举报

还需响应PageIndexChanged函数

private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;
BindDataGrid();
}

acewang 2003-12-02

打赏
举报

参考:
<%@ Import Namespace="System.Data" %>

<html>
<script language="C#" runat="server">

DataTable Cart;
DataView CartView;

ICollection CreateDataSource()
{
DataTable dt = new DataTable();
DataRow dr;

dt.Columns.Add(new DataColumn("IntegerValue", typeof(Int32)));
dt.Columns.Add(new DataColumn("StringValue", typeof(string)));
dt.Columns.Add(new DataColumn("CurrencyValue", typeof(double)));

for (int i = 0; i < 100; i++)
{
dr = dt.NewRow();

dr[0] = i;
dr[1] = "Item " + i.ToString();
dr[2] = 1.23 * (i+1);
dt.Rows.Add(dr);
}

DataView dv = new DataView(dt);
return dv;
}

void Page_Load(Object sender, EventArgs e)
{

if (!IsPostBack)
{
// Need to load this data only once.
ItemsGrid.DataSource = CreateDataSource();
ItemsGrid.DataBind();
}

if (CheckBox1.Checked)
ItemsGrid.PagerStyle.Mode = PagerMode.NumericPages;
else
ItemsGrid.PagerStyle.Mode = PagerMode.NextPrev;

}

void Grid_Change(Object sender, DataGridPageChangedEventArgs e)
{

// Set CurrentPageIndex to the page the user clicked.
ItemsGrid.CurrentPageIndex = e.NewPageIndex;

// Rebind the data.
ItemsGrid.DataSource = CreateDataSource();
ItemsGrid.DataBind();

}

</script>

<body>

<form runat=server>

<h3>DataGrid Paging Example</h3>

<asp:DataGrid id="ItemsGrid" runat="server"
BorderColor="black"
BorderWidth="1"
CellPadding="3"
AllowPaging="true"
AutoGenerateColumns="false"
OnPageIndexChanged="Grid_Change">

<HeaderStyle BackColor="#00aaaa">
</HeaderStyle>

<PagerStyle Mode="NextPrev">
</PagerStyle>

<Columns>

<asp:BoundColumn
HeaderText="Number"
DataField="IntegerValue"/>
<asp:BoundColumn
HeaderText="Item"
DataField="StringValue"/>
<asp:BoundColumn
HeaderText="Price"
DataField="CurrencyValue"
DataFormatString="{0:c}">

<ItemStyle HorizontalAlign="right">
</ItemStyle>

</asp:BoundColumn>

</Columns>

</asp:DataGrid>

<br>

<asp:CheckBox id="CheckBox1"
Text="Show page navigation"
AutoPostBack="true"
runat="server"/>

</form>

</body>
</html>

acewang 2003-12-02

打赏
举报

1.Page_Load:
if (!Page.IsPostBack)
{
//绑定数据
}
2.添加翻页事件:
<asp:DataGrid id="ItemsGrid" runat="server"
BorderColor="black"
BorderWidth="1"
CellPadding="3"
AllowPaging="true"
AutoGenerateColumns="false"
OnPageIndexChanged="Grid_Change">

Sub Grid_Change(sender As Object, e As DataGridPageChangedEventArgs)

' Set CurrentPageIndex to the page the user clicked.
ItemsGrid.CurrentPageIndex = e.NewPageIndex

' Rebind the data.
ItemsGrid.DataSource = CreateDataSource()
ItemsGrid.DataBind()
End Sub 'Grid_Change

supercdz 2003-12-02

打赏
举报

在DataGrid的 PageIndexChanged时间中

DataGrid1.CurpageIndex = e.NewpageIndex
在重新绑定

loulanlouzhu 2003-12-02

打赏
举报

ms-help://MS.VSCC/MS.MSDNVS.2052/Vbcon/html/vbwlkWalkthroughDisplayingDataInListBoxesOnWebFormsPage.htm

===弯弯的月亮小小的船，小小的船，两头尖，我在小小的船里坐，只看见闪闪
的星星蓝蓝的天．

===本贴子以“现状”提供且没有任何担保，同时也没有授予任何权利