Paging DataSets on a webpage using custom stored procedures

OK, so you want to use a dataset returned from a custom stored proc (csp) in web page, but don't want to do any of the paging plumbing yourself.

Specify your csp such that it will be picked up by NT and returns a dataset i.e. make sure the columns don't match the parent entity. NT will automatically generate the code to handle the paging for you in the data layer.  If you generate the service layer they will also be picked up there to.

Ok so how do we get it on our web page.  Create an ObjectDataSource in the following manner: 

<asp:ObjectDataSource runat="server" ID="ods" TypeName="MySystem.Services.ProductService" SelectMethod="GetNoProductSite"  />

Note the TypeName and SelectMethod point to the service and method you want to execute.

You can then create an EntityGridView and link to the data source using the datasourceid. Enable paging and away you go! 

swin

Swin/Robert,

What is meant by "NT will automatically generate the code to handle the paging for you in the data layer."?

I expected this solution returns ALL results and then pages through them, similarly to the way .NET works without .NETTiers. (using Gridview and Objectdatasource).

Or does the statement mean that .NETTiers is somehow customizing the paging to avoid this inefficiency?

Thanks.
 

swin:

OK, so you want to use a dataset returned from a custom stored proc (csp) in web page, but don't want to do any of the paging plumbing yourself.

Specify your csp such that it will be picked up by NT and returns a dataset i.e. make sure the columns don't match the parent entity. NT will automatically generate the code to handle the paging for you in the data layer.  If you generate the service layer they will also be picked up there to.

Ok so how do we get it on our web page.  Create an ObjectDataSource in the following manner: 

<asp:ObjectDataSource runat="server" ID="ods" TypeName="MySystem.Services.ProductService" SelectMethod="GetNoProductSite"  />

Note the TypeName and SelectMethod point to the service and method you want to execute.

You can then create an EntityGridView and link to the data source using the datasourceid. Enable paging and away you go! 

swin

mt too want to know the meaning of those words 

You can then create an EntityGridView and link to the data source using the datasourceid. Enable paging and away you go! 

 Paging is working...But I do not have a total record count and when I try to export to excel I get the following error???

Specified argument was out of the range of valid values.
Parameter name: value

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: value

Source Error:

Line 565:
Line 566:            this.PageIndex = 0;
Line 567:            this.PageSize = this.RecordsCount;
Line 568:            this.DataSourceID = this.DataSourceID;
Line 569:            this.DataBind();

Is it possible to use the excel and total records of the footer when using a custom sproc?