Hi,

Does anyone know how to find out how many rows have been returned when an Object Data Source has been bound?

Thanks.

I believe you'd use the selecting event handler - like this:

    protected void ObjectDataSource1_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
    {
        bGetSelectCount = e.ExecutingSelectCount;
    }

Take a look at parameter 'e' in the Selected event of the ObjectDataSource. The ReturnValue should give you the datatable/dataset you're about to bind. You should be able to get the number of rows from that.

The e.ExecutingSelectCount returns a boolean.  How would I return the number of rows from that?

swaino, i get the number of rows like this.

Apologies - I omitted a chunk from that...

    bool bGetSelectCount;
    protected void ObjectDataSource1_Selected(object sender, ObjectDataSourceStatusEventArgs e)
    {
        if (bGetSelectCount)
            TextBox1.Text = e.ReturnValue.ToString(); 
    }

    protected void ObjectDataSource1_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
    {
        bGetSelectCount = e.ExecutingSelectCount;
    }

 Ok thanks all!