Re: SelectCountMethod error - looking for parameters?

Miky,

of course you need to retrieve the total row count from the database to
do decent paging. However, IMHO a better design would be to have an
output parameter in your select method instead of another method to
call. That way your SelectMethod can be static and everything done in
one call to the database server. With that logic split in two method
calls you need to have an instance variable to save the total row count
and return it in the SelectCountMethod or to perform another call to
the database in the SelectCountMethod (with most custom paging schemas
you can know the total row count where you do paging).

Manuel Abadia
http://www.manuelabadia.com

miky wrote:
Manuel,
Actually, the SelectCountMethod is needed in my case since I'm handling
paging at the database, not using the GridView's default mechanism.
Since this method only returns a designated page at a time the GridView
can't know the total records unless I tell it.

I'll look into your thoughts on attributes. I don't have a grasp of
them yet.

Thanks for your help (and the reference - I'll have to look into that
too)!


miky

.

Relevant Pages

  • Re: SelectCountMethod error - looking for parameters?
    ... of course you need to retrieve the total row count from the database to ... one call to the database server. ... the database in the SelectCountMethod (with most custom paging schemas ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: High paging activity with no load
    ... Actually just because the current output of vmstat doesn't show any ... paging activity, doesn't mean that the system isn't paging. ... expecially if the database is filesystem based, since by default, AIX ...
    (comp.unix.aix)
  • How would the God of Standard Sql - Celko do server side paging?
    ... On a very large database, how would Celko implement paging. ... To do paging on the database side, you must use some sort of ordering/ ...
    (microsoft.public.sqlserver.programming)
  • Re: ASP/MS Access paging through large recordset
    ... As for the database record paging, it is a common requirement when we ... display database driven web pages. ... logic layer and the others in database layer. ...
    (microsoft.public.inetserver.asp.db)