如何在gridview的页脚显示记录总数

Question

那你把页脚不显示,把label放在gridview的下一行,lable统计总记录

Answer 1

頁腳不顯示，不能分頁，也不現實
顯示了，也不能跟label放在同一行所以還是用分頁控件或自己定義分頁，默認的不顯示

Answer 2

样式：第1页 共2页 38条记录  <<   <  1 2 3 4 5  >   >>
可以参考下                    第<asp:Label ID="Label5" runat="server"></asp:Label>页
                    共<asp:Label ID="Label6" runat="server"></asp:Label>页
                    <asp:Label ID="Label7" runat="server"></asp:Label>条记录
                    <asp:linkbutton ID="Label8" OnClick="fn_page" CommandName="first" Font-Underline="false" ForeColor="#666666" runat="server" Text="&nbsp;<b><<</b>&nbsp;" BorderColor="#666666" BackColor="#FFCD4A" BorderWidth="1"></asp:linkbutton>
                    <asp:linkbutton ID="Label9" OnClick="fn_page" CommandName="prev" Font-Underline="false" ForeColor="#666666" runat="server" Text="&nbsp;<b><</b>&nbsp;" BorderColor="#666666" BackColor="#FFCD4A" BorderWidth="1"></asp:linkbutton>
                    <asp:linkbutton ID="Label10" OnClick="new_page" Font-Underline="false" ForeColor="#666666" runat="server" BorderColor="#666666" BackColor="#FFCD4A" BorderWidth="1"></asp:linkbutton>
                    <asp:linkbutton ID="Label11" OnClick="new_page" Font-Underline="false" ForeColor="#666666" runat="server" BorderColor="#666666" BackColor="#FFCD4A" BorderWidth="1"></asp:linkbutton>
                    <asp:linkbutton ID="Label12" OnClick="new_page" Font-Underline="false" ForeColor="#666666" runat="server" BorderColor="#666666" BackColor="#FFCD4A" BorderWidth="1"></asp:linkbutton>
                    <asp:linkbutton ID="Label13" OnClick="new_page" Font-Underline="false" ForeColor="#666666" runat="server" BorderColor="#666666" BackColor="#FFCD4A" BorderWidth="1"></asp:linkbutton>
                    <asp:linkbutton ID="Label14" OnClick="new_page" Font-Underline="false" ForeColor="#666666" runat="server" BorderColor="#666666" BackColor="#FFCD4A" BorderWidth="1"></asp:linkbutton>
                    <asp:linkbutton ID="Label15" OnClick="fn_page" CommandName="next" Font-Underline="false" ForeColor="#666666" runat="server" Text="&nbsp;<b>></b>&nbsp;" BorderColor="#666666" BackColor="#FFCD4A" BorderWidth="1"></asp:linkbutton>
                    <asp:linkbutton ID="Label16" OnClick="fn_page" CommandName="last" Font-Underline="false" ForeColor="#666666" runat="server" Text="&nbsp;<b>>></b>&nbsp;" BorderColor="#666666" BackColor="#FFCD4A" BorderWidth="1"></asp:linkbutton>
    Sub new_page(ByVal s As System.Object, ByVal e As System.EventArgs)
        Dim str As Int16 = Convert.ToInt16(CType(s, LinkButton).Text)
        GridView1.PageIndex = str - 1
        GridView1.EditIndex = -1
        strsql = ViewState("strsql")
        BindList()
    End Sub    Sub fn_page(ByVal s As System.Object, ByVal e As System.EventArgs)
        Dim str As String = CType(s, LinkButton).CommandName.ToString
        Select Case str
            Case "first"
                GridView1.PageIndex = 0
                GridView1.EditIndex = -1
                strsql = ViewState("strsql")
                BindList()
            Case "prev"
                If GridView1.PageIndex > 0 Then
                    GridView1.PageIndex = GridView1.PageIndex - 1
                Else
                    GridView1.PageIndex = 0
                End If
                GridView1.EditIndex = -1
                strsql = ViewState("strsql")
                BindList()
            Case "next"
                GridView1.PageIndex = GridView1.PageIndex + 1
                GridView1.EditIndex = -1
                strsql = ViewState("strsql")
                BindList()
            Case "last"
                GridView1.PageIndex = GridView1.PageCount - 1
                GridView1.EditIndex = -1
                strsql = ViewState("strsql")
                BindList()
        End Select
    End Sub    Sub BindList()
        Dim objcmd As New OleDbDataAdapter(strsql, StrCon)
        Dim das As New DataSet
        objcmd.Fill(das, "acount")
        das.Tables("acount").DefaultView.Sort = ViewState("sort") & " " & ViewState("dire")
        GridView1.DataSource = das.Tables("acount").DefaultView
        GridView1.DataBind()
        Label5.Text = GridView1.PageIndex + 1
        Label6.Text = GridView1.PageCount
        Label7.Text = das.Tables(0).Rows.Count
        Label10.Text = Int((GridView1.PageIndex) / 5) * 5 + 1
        Label11.Text = Int((GridView1.PageIndex) / 5) * 5 + 2
        Label12.Text = Int((GridView1.PageIndex) / 5) * 5 + 3
        Label13.Text = Int((GridView1.PageIndex) / 5) * 5 + 4
        Label14.Text = Int((GridView1.PageIndex) / 5) * 5 + 5
        If Label10.Text = GridView1.PageIndex + 1 Then
            Label10.BackColor = Drawing.Color.White
        Else
            Label10.BackColor = Drawing.ColorTranslator.FromHtml("#FFCD4A")
        End If
        If Label11.Text = GridView1.PageIndex + 1 Then
            Label11.BackColor = Drawing.Color.White
        Else
            Label11.BackColor = Drawing.ColorTranslator.FromHtml("#FFCD4A")
        End If
        If Label12.Text = GridView1.PageIndex + 1 Then
            Label12.BackColor = Drawing.Color.White
        Else
            Label12.BackColor = Drawing.ColorTranslator.FromHtml("#FFCD4A")
        End If
        If Label13.Text = GridView1.PageIndex + 1 Then
            Label13.BackColor = Drawing.Color.White
        Else
            Label13.BackColor = Drawing.ColorTranslator.FromHtml("#FFCD4A")
        End If
        If Label14.Text = GridView1.PageIndex + 1 Then
            Label14.BackColor = Drawing.Color.White
        Else
            Label14.BackColor = Drawing.ColorTranslator.FromHtml("#FFCD4A")
        End If
    End Sub 

Answer 3

private void dgAddSumOnFooter_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (e.Item.ItemIndex >= 0)
{
//取指定列的数据总和
try
{
sum += int.Parse(e.Item.Cells[3].Text);
}
catc{}
}
//在页脚中添加指定列的总和和平均值
else if (e.Item.ItemType == ListItemType.Footer)
{
e.Item.Cells[0].Text = "总和为: ";sum.ToString();
e.Item.Cells[1].Text = sum.ToString();
e.Item.Cells[2].Text = "平均值为:";
e.Item.Cells[3].Text = ((int)(sum / dgAddSumOnFooter.Items.Count)).ToString();
}
}

Answer 4

sum += int.Parse(e.Item.Cells[3].Text);
报错+=

Answer 5

支持:
sum += int.Parse(e.Item.Cells[3].Text);

Answer 6

在FOOTTEMPLATE放个LABEL不就行了,再后再用ROW.COUNT计算行数

Answer 7

在FOOTTEMPLATE放个LABEL影响分页吧

Answer 8

在代碼頁Class下面
int intCnt;private void dgAddSumOnFooter_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (e.Item.ItemIndex >= 0)
{
//取指定列的数据总和
try
{
intCnt+=1;}
catc{}
}
//在页脚中添加指定列的总和和平均值
else if (e.Item.ItemType == ListItemType.Footer)
{
e.Item.Cells[0].Text = "总記錄為: "; intCnt.ToString();}
}