asp.net 2.0中得到sqldatasource返回的行數

在asp.net 2.0中，gridview是和sqldatasource控制項綁定的，那麼如何得到sqldatasource返回的記錄的行數呢？
比如sqldatasource控制項中用select * from ....，如何返回其記錄行數？在.net 2.0中，可以通過sqldatasource的
OnSelected事件實現，並且對select事件SqlDataSourceStatusEventArgs參數中的AffectedRows屬性設定一下就可以了，具體核心代碼如下：

.........(開頭部分省略）

<script runat="Server">

    protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)

   {

        totalRows.Text = e.AffectedRows.ToString();

    }

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="CustomerID"

            DataSourceID="SqlDataSource1" AllowPaging="True">

            <Columns>

                <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" />

                <asp:BoundField DataField="CompanyName" HeaderText="CompanyName" SortExpression="CompanyName" />

                <asp:BoundField DataField="ContactName" HeaderText="ContactName" SortExpression="ContactName" />

            </Columns>

        </asp:GridView>

        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=(local);Initial Catalog=Northwind;user id=sa;password=123456;"

            ProviderName="System.Data.SqlClient" SelectCommand="SELECT [CustomerID], [CompanyName], [ContactName] FROM [Customers]" OnSelected="SqlDataSource1_Selected">

        </asp:SqlDataSource>

        <asp:Label ID="Label1" runat="server" Text="Number of total rows:"></asp:Label>

        <asp:Label ID="totalRows" runat="server" Text="Label"></asp:Label>