in

CodeSmith Community

Your Code. Your Way. Faster!
All Tags » custom stored procedure » Paging (RSS)

Browse by Tags

  • Re: DeepSearch?

    You rock! I've been round and round with this problem, and then finally came back to your post. This is a great way to do this. Note to self to read property names properly. For some reason I assumed it was a method name and couldn't figure out why it always returned a null value. I can go to bed now...
    Posted to .netTiers - General Support (Forum) by Junto on 05-14-2007
    Filed under: Custom Stored Procedure, Paging, cst, CustomMethodRecordCountParamName

  • Re: Paging and Custom Stored Procedure Example

    I have had some success in solving this problem. The ORDER BY still eludes me, but I think a series of CASE WHEN statements would work (although ugly): ALTER PROCEDURE [dbo] . [_Company_SearchGetPaged] ( @WhereClause varchar ( 2000 ) = null , @PageIndex int = null , @PageSize int = null ) AS BEGIN -...
    Posted to .netTiers - General Support (Forum) by Junto on 05-10-2007
    Filed under: Custom Stored Procedure, PageSize, Paging, cst

  • Paging and Custom Stored Procedure Example

    Hi, Would anyone like to share an example of a custom stored procedure that: Supports paging, and Returns a TList not a dataset, and INNER JOINS on one or more sub tables so a WHERE search can target the sub tables I have the following, which is an exact copy of the same generated GetPaged SP for a table...
    Posted to .netTiers - General Support (Forum) by Junto on 05-08-2007
    Filed under: Custom Stored Procedure, Paging, cst
Page 1 of 1 (3 items)
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems