Data Access and ObjectDataSource Control

Re: How do I find the number of rows returned in an Object Data Source

swaino — Mon, 11 Jun 2007 09:02:16 GMT

Ok thanks all!

Re: How do I find the number of rows returned in an Object Data Source

Sohnee — Tue, 05 Jun 2007 12:32:26 GMT

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;
    }

Re: How do I find the number of rows returned in an Object Data Source

kennyp — Tue, 05 Jun 2007 08:18:49 GMT

swaino, i get the number of rows like this.

Private Sub ObjectDataSource1_Selected(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceStatusEventArgs) Handles ObjectDataSource1.Selected

NumberOfRows = e.ReturnValue.Rows.Count()

End Sub

Re: How do I find the number of rows returned in an Object Data Source

swaino — Mon, 04 Jun 2007 15:58:23 GMT

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

Re: How do I find the number of rows returned in an Object Data Source

kennyp — Mon, 04 Jun 2007 14:26:25 GMT

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.

Re: How do I find the number of rows returned in an Object Data Source

Sohnee — Mon, 04 Jun 2007 14:20:41 GMT

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

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

How do I find the number of rows returned in an Object Data Source

swaino — Mon, 04 Jun 2007 13:51:55 GMT

Hi,

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

Thanks.