DataGrid的问题 如何在DataGrid的脚页眉中显示所有DataGrid中记录的总记录数,总页数和当前的页数.请各位大侠指教! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 参考http://dev.csdn.net/develop/article/20/20221.shtm 总记录数,总页数和当前的页数1 select count(*) from 表!2 1结果/pagesize3 page.currentIndex+1; 最简单的办法:如果想在页眉上显示那就在DataGrid上面放一个Label,让它的Text="总记录数"+DataTable.Rows.Count+"总页数"+DataTable.Rows.Count/DataGrid.pagesize+"当前的页数"+DataGrid.page.currentIndex+1; <h2>在页脚上显示所有DataGrid中记录的总记录数,总页数和当前的页数</h2><asp:DataGrid id="dgAddSumOnFooter" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 48px" runat="server" Height="20px" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" BackColor="White" CellPadding="4" ToolTip="计算第一列的总和及平均值" ShowFooter="True" AutoGenerateColumns="False" Width="464px"> <SelectedItemStyle Font-Bold="True" ForeColor="#CCFF99" BackColor="#009999"></SelectedItemStyle> <ItemStyle ForeColor="#003399" BackColor="White"></ItemStyle> <HeaderStyle Font-Bold="True" ForeColor="#CCCCFF" BackColor="#003399"></HeaderStyle> <FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle> <Columns> <asp:BoundColumn DataField="LastName" HeaderText="姓名"></asp:BoundColumn> <asp:BoundColumn DataField="FirstName" HeaderText="姓"></asp:BoundColumn> <asp:BoundColumn DataField="TitleOfCourtesy" HeaderText="称谓"></asp:BoundColumn> <asp:BoundColumn DataField="Extension" HeaderText="示例数字"></asp:BoundColumn> </Columns> <PagerStyle HorizontalAlign="Left" ForeColor="#003399" BackColor="#99CCCC" Mode="NumericPages"></PagerStyle></asp:DataGrid>private int sum = 0;private void Page_Load(object sender, System.EventArgs e){ //页面初试化时进行数据绑定 if(!IsPostBack) DataGridDataBind();}private void DataGridDataBind(){ //定义数据连接对象,其中数据库连接字符串是在Web.Config文件中定义的 SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionSqlServer"].ToString()); //创建数据适配器对象 SqlDataAdapter da = new SqlDataAdapter("select LastName,FirstName,TitleOfCourtesy,Extension from Employees",conn); //创建DataSet对象 DataSet ds = new DataSet(); try { //填充数据集 da.Fill(ds,"testTable"); //进行数据绑定 dgAddSumOnFooter.DataSource = ds.Tables["testTable"]; sum =ds.Tables["testTable"].Rows.Count; dgAddSumOnFooter.DataBind(); } catch(Exception error) { Response.Write(error.ToString()); } }private void dgAddSumOnFooter_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e){ if (e.Item.ItemType == ListItemType.Footer) {="总记录数"+DataTable.Rows.Count+"总页数"+DataTable.Rows.Count/DataGrid.pagesize+"当前的页数"+DataGrid.page.currentIndex+1; e.Item.Cells[0].Text = "总记录数: "; e.Item.Cells[1].Text = sum.ToString()+"总页数:"; e.Item.Cells[2].Text =( sum/dgAddSumOnFooter.Pagesize).ToString()+"当前的页数:"; e.Item.Cells[3].Text = (dgAddSumOnFooter.page.currentIndex+1).ToString(); }} repeter的列绑定问题 请问如何利用多个dropdownlist进行筛选 获取QQ好友列表,有谁有经验的.>>?指教? 两个或多个DataSet或DataTable能相加不? 请教“读取客户端证书的问题” 系统迁移,数据库有是能访问有时不能访问 url重定位的问题 ASP.NET上传大文件问题 如何实现在点击一个服务器控件按钮时候不提交 关于弹出窗口确认后程序执行。怎么做? 水晶报表打包问题!vs2003+水晶报表10如何打包? 菜鸟提问,老鸟回答,菜鸟给分!
http://dev.csdn.net/develop/article/20/20221.shtm
如果想在页眉上显示
那就在DataGrid上面放一个Label,让它的Text="总记录数"+DataTable.Rows.Count+"总页数"+DataTable.Rows.Count/DataGrid.pagesize+"当前的页数"+DataGrid.page.currentIndex+1;
<asp:DataGrid id="dgAddSumOnFooter" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 48px"
runat="server" Height="20px" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" BackColor="White"
CellPadding="4" ToolTip="计算第一列的总和及平均值" ShowFooter="True" AutoGenerateColumns="False" Width="464px">
<SelectedItemStyle Font-Bold="True" ForeColor="#CCFF99" BackColor="#009999"></SelectedItemStyle>
<ItemStyle ForeColor="#003399" BackColor="White"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="#CCCCFF" BackColor="#003399"></HeaderStyle>
<FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle>
<Columns>
<asp:BoundColumn DataField="LastName" HeaderText="姓名"></asp:BoundColumn>
<asp:BoundColumn DataField="FirstName" HeaderText="姓"></asp:BoundColumn>
<asp:BoundColumn DataField="TitleOfCourtesy" HeaderText="称谓"></asp:BoundColumn>
<asp:BoundColumn DataField="Extension" HeaderText="示例数字"></asp:BoundColumn>
</Columns>
<PagerStyle HorizontalAlign="Left" ForeColor="#003399" BackColor="#99CCCC" Mode="NumericPages"></PagerStyle>
</asp:DataGrid>
private int sum = 0;
private void Page_Load(object sender, System.EventArgs e)
{
//页面初试化时进行数据绑定
if(!IsPostBack)
DataGridDataBind();
}private void DataGridDataBind()
{
//定义数据连接对象,其中数据库连接字符串是在Web.Config文件中定义的
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionSqlServer"].ToString());
//创建数据适配器对象
SqlDataAdapter da = new SqlDataAdapter("select LastName,FirstName,TitleOfCourtesy,Extension from Employees",conn);
//创建DataSet对象
DataSet ds = new DataSet();
try
{
//填充数据集
da.Fill(ds,"testTable");
//进行数据绑定
dgAddSumOnFooter.DataSource = ds.Tables["testTable"];
sum =ds.Tables["testTable"].Rows.Count;
dgAddSumOnFooter.DataBind();
}
catch(Exception error)
{
Response.Write(error.ToString());
}
}
private void dgAddSumOnFooter_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Footer)
{
="总记录数"+DataTable.Rows.Count+"总页数"+DataTable.Rows.Count/DataGrid.pagesize+"当前的页数"+DataGrid.page.currentIndex+1;
e.Item.Cells[0].Text = "总记录数: ";
e.Item.Cells[1].Text = sum.ToString()+"总页数:";
e.Item.Cells[2].Text =( sum/dgAddSumOnFooter.Pagesize).ToString()+"当前的页数:";
e.Item.Cells[3].Text = (dgAddSumOnFooter.page.currentIndex+1).ToString();
}}