How to get row count of ObjectDataSource

c# objectdatasource rowcount
Mostafa picture Mostafa · Dec 13, 2009 · Viewed 21.9k times · Source

Hello you all

How can i get row count of ObjectDataSouce ?

I use ObjectDataSource and DataList . I want show some thing to the user for example in a label when there are certain row returned by ObjectDataSource . One of situation is when there is no record .

Thank you .

Answer

Watki02 picture Watki02 · Jun 23, 2011

I was looking for the same answer... Another solution I ended up using is the following: This is found on a .vb file behind an .aspx page. It handles the "selected" event of the datasource.

Protected Sub ObjectDataSource1_Selected(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceStatusEventArgs) Handles ObjectDataSource1.Selected
    ' Select data for rowcount
    Dim dt As DataTable = e.ReturnValue
    ' Set row count label
    Me.lblCount.Text = dt.Rows.Count.ToString
End Sub

Related questions

GridView bound with Properties of nested class

I have an object map similar to what's listed below. When I try to bind the properties of NestedClass in a GridView I get the error: "A field or property with the name 'NestedClass.Name' was not found on the …

Read More
Understanding ObjectDataSource and Select Parameters

I have in a GridView control a TemplateField like: <asp:TemplateField ItemStyle-Width="150px"> <ItemTemplate> <asp:DropDownList ID="ddlFields" runat="server" DataSourceID="odsOperator" DataTextField="Text" DataValueField="Value" /> <asp:HiddenField ID="hfFieldType" runat="server" Value=…

Read More
Return Custom Object <List T> from Entity framework and assign to Object Data Source

I need some guidance with an issue, I am using Entity Framework 4.0, I have a DAL and BLL and am binding to ObjectDataSource on the page. I had to write a stored procedure using PIVOT and dynamic SQL to return …

Read More