如何在gridview的页脚显示记录总数
问题如上,自己考虑在gridview页脚放置一label,可是不知道怎么放置 --------------------编程问答-------------------- up --------------------编程问答-------------------- up --------------------编程问答-------------------- 那你把页脚不显示,把label放在gridview的下一行,lable统计总记录--------------------编程问答-------------------- up --------------------编程问答-------------------- up --------------------编程问答-------------------- 頁腳不顯示,不能分頁,也不現實
顯示了,也不能跟label放在同一行
所以還是用分頁控件或自己定義分頁,默認的不顯示
--------------------编程问答-------------------- 样式:第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=" <b><<</b> " 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=" <b><</b> " 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=" <b>></b> " 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=" <b>>></b> " 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
--------------------编程问答-------------------- 有没有C#的 --------------------编程问答-------------------- 考虑模版 --------------------编程问答-------------------- 共同进步
顺便接分 --------------------编程问答-------------------- 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();
}
} --------------------编程问答-------------------- 不能用 --------------------编程问答-------------------- sum += int.Parse(e.Item.Cells[3].Text);
报错+= --------------------编程问答-------------------- 把页脚隐藏了。直接自己写个翻页的东西不就成了
现在好多网都是这么干的 --------------------编程问答-------------------- 支持:
sum += int.Parse(e.Item.Cells[3].Text);
--------------------编程问答-------------------- 在FOOTTEMPLATE放个LABEL不就行了,再后再用ROW.COUNT计算行数 --------------------编程问答-------------------- 在FOOTTEMPLATE放个LABEL影响分页吧 --------------------编程问答-------------------- 在代碼頁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();
}
} --------------------编程问答-------------------- int intCnt=0; --------------------编程问答-------------------- 第一次发帖看看
补充:.NET技术 , ASP.NET