Because he can?

In Word you can only store 2 bytes. That is why I use Writer.

which poet is that?

In Word you can only store 2 bytes. That is why I use Writer.

the shine so overwhelming you cannot see the issues anymore

In Word you can only store 2 bytes. That is why I use Writer.

You should add it as a tip

In Word you can only store 2 bytes. That is why I use Writer.

I wouldn't mourn. It was in the eighties when I wrote:

10 PRINT "Herman is the best !!1!!1!11!";;;;;
20 GOTO 10

In Word you can only store 2 bytes. That is why I use Writer.

The Unchase OData client (UOC) creates the connection between the client (WebForm) and the OData service (over IIS). In IIS OData controllers send the data over the HTTPGet when requested. The UOC uses linq to translate the linq query to OData HTTP request. The Reference.cs created by the UOC shows even the connections between tables in the DB over ODATA. What I now suspect is that the controller in the IIS does:

return db.Users.Where(x => !x.IsDeleted)

It is not using Include("UserGroups") to fill these nodes with data. The linq query translates to requerst Uri: http://localhost/api/global/Users?$orderby=Id

In Word you can only store 2 bytes. That is why I use Writer.

Unfortunately the error stays.... Maybe some help: [Expression.VisitChildren(ExpressionVisitor) Method (System.Linq.Expressions) | Microsoft Docs](https://docs.microsoft.com/en-us/dotnet/api/system.linq.expressions.expression.visitchildren?view=net-6.0)

In Word you can only store 2 bytes. That is why I use Writer.

Even if I set in the GridView:

AllowSorting="true" AllowPaging="true" PageSize="10"

Still I have

[ArgumentException: must be reducible node]
System.Linq.Expressions.Expression.VisitChildren(ExpressionVisitor visitor) +97
System.Linq.Expressions.ExpressionVisitor.VisitExtension(Expression node) +11
System.Linq.Expressions.Expression.Accept(ExpressionVisitor visitor) +12
System.Linq.Expressions.ExpressionVisitor.Visit(Expression node) +20
System.Web.Util.OrderingMethodFinder.OrderMethodExists(Expression expression) +38
System.Web.UI.WebControls.QueryableHelpers.IsOrderingMethodFound(IQueryable`1 queryable) +16

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +168
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +105
System.Web.UI.WebControls.ModelDataSourceView.ProcessSelectMethodResult(DataSourceSelectArguments arguments, DataSourceSelectResultProcessingOptions selectResultProcessingOptions, ModelDataMethodResult result) +393
System.Web.UI.WebControls.ModelDataSourceView.GetSelectMethodResult(DataSourceSelectArguments arguments) +86
System.Web.UI.WebControls.ModelDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +14
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.ModelDataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +81
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +169
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +71
System.Web.UI.WebControls.GridView.DataBind() +5
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +93
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +72
System.Web.UI.Control.EnsureChildControls() +116
System.Web.UI.Control.PreRenderRecursiveInternal() +49
System.Web.UI.Control.PreRenderRecursiveInternal() +236
System.Web.UI.Control.PreRenderRecursiveInternal() +236
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4719

And now in CODE (used the ScottGu mentioned code in the link from first reply) Created a clean asp.net 4.7.2 webforms project. I have an ODATA service which is read via Unchase OData library Index.Asp has the gridview:

                    <%# Item.UserGroup.Count %>

My codebehind:

namespace TestGridView
{
public partial class Index : Page
{

    private Default.Container container; // is for working with the OData Service

    protected void Page\_Init(object sender, EventArgs e)
    {
        Uri uri = new Uri("http://localhost/api/global");
        container = new Default.Container(uri)
        {
            Credentials = CredentialCache.DefaultNetworkCredentials,
            Timeout=3600
        };
    }
    protected void Page\_LoadComplete(object sender, EventArgs e)
    {
        GrdTest.BackColor = System.Drawing.Color.LightGreen;
        GrdTest.AlternatingRowStyle.BackColor = System.Drawing.Color.LightBlue;
        GrdTest.RowStyle.BackColor = System.Drawing.Color.LightGray;
    }

    // The return type can be changed to IEnumerable, however to support
    // paging and sorting, the following parameters must be added:
    //     int maximumRows
    //     int startRowIndex
    //     out int totalRowCount
    //     string sortByExpression
    public IQueryable GrdTest\_GetData(int? maximumRows, int? startRowIndex)
    {
        if (maximumRows == null || startRowIndex == null)
            return container.Users;

        return container.Users.Skip(startRowIndex ?? 0).Take(maximumRows ?? 0);
    }
}

}

This will lead to 1 gridview without paging and shows data. Then I change my GridView to:

Been working all weekend on it. Using the SelectMethod and Creating the method in codebehind is no problem. But when everything stays yelling except loading data I am done with it. Read enough on it. Have over 11,000 users of this site of mine and I am not gonna take risks. Besides it is really strange that the SelectMethod in a page leads to a break in an UpdateProgress control in the masterpage. If I put that in comments, it is claiming for reducible nodes.

In Word you can only store 2 bytes. That is why I use Writer.

This is a horrible suggestion. Only tested SelectMethod. AJAX starts yelling about Registerscripts issues GridView can't set styling anymore via my Library (Node isues ??) And Async leads to exception it needs a return Task (which it is). Back to my way

In Word you can only store 2 bytes. That is why I use Writer.

Hi all, where in the lifecycle of an asp.net page do you load the data for a gridview? In Page_Load (which runs twice and check on !IsPostback is needed), in Page_LoadComplete (runs once) or in Page_Prerender (runs once) I see better/smoother working of the pages when loading in Page_Loadcomplete event. How are your experiences? I use Page_Prerender to set properties of a GridView other than DataSource and DataBind.

In Word you can only store 2 bytes. That is why I use Writer.

Not a dad-a-lake? And beyond 50 years it's dad-a-leak?

In Word you can only store 2 bytes. That is why I use Writer.

Please don't judge the shelfies by it's cover

In Word you can only store 2 bytes. That is why I use Writer.

Just turn around and we will paint your belly too

In Word you can only store 2 bytes. That is why I use Writer.

As long as you don't touch my AXE (LYNX in UK)

In Word you can only store 2 bytes. That is why I use Writer.

Turn off scroll-lock and ALT-lock on your keyboard

In Word you can only store 2 bytes. That is why I use Writer.

You better dive and duck

In Word you can only store 2 bytes. That is why I use Writer.

Ain't the boss is called Tim Crook?

In Word you can only store 2 bytes. That is why I use Writer.

And someone above just yelled: lettuce have papers

In Word you can only store 2 bytes. That is why I use Writer.