CodeSmith Community

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