Solved: Total rowcount for gridview

Hi,

I have been trying to figure out how to get the total rowcount for a gridview (I am using paging). I thought that the methods used here would work:

http://www.webswapp.com/codesamples/viewsource.aspx?file=~/codesamples/aspnet20/dropdownlist_gridview/default.aspx

but I get an error: System.InvalidCastException: Unable to cast object of type 'tbl_Email_Blast2DataTable' to type 'System.Collections.Generic.List`1[DataTableAdapters.tbl_Email_Blast2TableAdapter]'.

Below is my code. Thanks for any help.

Bonnie

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
 
public partial class Email_List : System.Web.UI.Page
{
    protected void test(object sender, ObjectDataSourceStatusEventArgs e)
    {
        rowcountTextBox.Text = ((List<DataTableAdapters.tbl_Email_Blast2TableAdapter>)e.ReturnValue).Count.ToString();
    }
 
 }
********************************************************************************************************************
 
<%@ Page Language="C#" MasterPageFile="~/Email_List/MasterPage2.master" Debug="true" AutoEventWireup="true" CodeFile="CSV_List.aspx.cs" Inherits="Email_List" Title="Email Address List" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<div align="center"> 
 <h3 style="font-family:Tahoma;">Datawarehouse Email Marketing List<br />
     <asp:TextBox ID="rowcountTextBox" runat="server"></asp:TextBox></h3>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
        AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="Solid"
        BorderWidth="1px" CellPadding="3" DataKeyNames="db_key" DataSourceID="ObjectDataSource2"
        ForeColor="Black" GridLines="Vertical" PageSize="25">
        <FooterStyle BackColor="#CCCCCC" Font-Names="Tahoma" Font-Size="Small" />
        <Columns>
            <asp:TemplateField HeaderText="Edit" ShowHeader="False">
                <EditItemTemplate>
                    <asp:ImageButton ID="ImageButton1" runat="server" CausesValidation="True" CommandName="Update"
                     ImageUrl="~/images/disk.png" ToolTip="Save Changes"  />
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:ImageButton ID="ImageButton2" runat="server" CausesValidation="False" CommandName="Edit"
                        ImageUrl="~/images/pencil.png" ToolTip="Edit Email Addresses" />
                </ItemTemplate>
            </asp:TemplateField>
            
            <asp:TemplateField HeaderText="Delete" ShowHeader="False">
                <EditItemTemplate>
                    <asp:ImageButton ID="ImageButton3" runat="server" CausesValidation="False"
                            CommandName="Cancel" ImageUrl="~/images/diskx.png" ToolTip="Discard Changes"  Text="Cancel" />
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:ImageButton ID="ImageButton4" runat="server" CausesValidation="False" CommandName="Delete"
                        ImageUrl="~/images/cancel.png"  ToolTip="Delete Email Address" />
                </ItemTemplate>
            </asp:TemplateField>
          
            <asp:TemplateField HeaderText="Email Address" SortExpression="email_address">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("email_address") %>' Width="255px"></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("email_address") %>' Width="255px"></asp:Label>
                </ItemTemplate>
                <ItemStyle HorizontalAlign="Left" />
            </asp:TemplateField>
            <asp:BoundField DataField="company_name" HeaderText="Company Name" SortExpression="company_name">
                <ItemStyle HorizontalAlign="Left" />
            </asp:BoundField>
        </Columns>
        <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" Font-Names="Tahoma" Font-Size="Small" />
        <AlternatingRowStyle BackColor="#CCCCCC" />
        <RowStyle Font-Names="Tahoma" Font-Size="Small" />
        <EditRowStyle Font-Names="Tahoma" Font-Size="Small" ForeColor="Black" BackColor="#FFFF80" />
    </asp:GridView>
    <asp:ObjectDataSource ID="ObjectDataSource2" runat="server" DeleteMethod="Delete" OldValuesParameterFormatString="original_{0}" SelectMethod="GetCSVAddresseSorted"
        TypeName="DataTableAdapters.tbl_Email_Blast2TableAdapter" InsertMethod="Insert" UpdateMethod="Update" OnSelected="test">
        <DeleteParameters>
            <asp:Parameter Name="Original_db_key" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="email_address" Type="String" />
            <asp:Parameter Name="company_name" Type="String" />
            <asp:Parameter Name="Original_db_key" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="email_address" Type="String" />
            <asp:Parameter Name="company_name" Type="String" />
        </InsertParameters>
    </asp:ObjectDataSource>
</div>
 
</asp:Content>

Open in new window