Showing related tags and posts accross the entire site.
-
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...
-
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 -...
-
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...