Re: Going to a specific page?



Thanks Mohamed!

Your suggestion is ideal. Unfortunately, the application doesn't have a
rationale data access layer - SQL is interspersed with presentation
code and business logic. I've taken a approach which is a variant of
your suggestion - defining a rowfilter on the dataview prior to binding
to the grid. Performance is not an issue. There are only a few hundred
records in the DB with anticipated growth of 10-20 records per year.

As an aside I'm taking the dataview filter approach for expediancy. A
supposedly senior developer who was also PM on the project with no
oversight created a monstrosity of an app - he's now gone. Since we've
already screwed the client the few $s left are being applied to meeting
the clients specific requirements while fixing the unseen
application/coding errors on our $. The last and biggest hurdle is to
build stored procedures for the primary datagrid. When I build the
stored procedures I'll add an option to constrain the search by alpha
range.

.



Relevant Pages

  • Re: Using lists for validation
    ... After doing what Niek says you might want to sort that range, so you get names in alphabetic order ... Before I saw it I saw Niek Otten's other suggestion, ... but when I get a 7th client I can't seem to redefine the clientlist to include it. ...
    (microsoft.public.excel)
  • Re: Male or Female for Narration?
    ... It's not that the client is being indecisive....I just wanted to be ... Patrick Stewart-ish was not a bad suggestion, ... Stewart is currently doing a gig in Brooklyn, ...
    (rec.video.production)
  • Re: Dropping Zeros from Avg
    ... That's a good suggestion. ... works just fine, and the client likes it, so we'll probably stick with that. ... >> Outgoing mail is certified Virus Free. ...
    (microsoft.public.access.gettingstarted)
  • Re: Male or Female for Narration?
    ... It's not that the client is being indecisive....I just wanted to be ... Patrick Stewart-ish was not a bad suggestion, ... Let's hope he don't tawk Brooklyn. ...
    (rec.video.production)
  • Re: Paging recordsets in ado.net
    ... Could you please clarify your suggestion? ... Having the rows held in a server-side cursor impacts scalability ... Hitchhiker's Guide to Visual Studio and SQL Server ... which by default uses a client side cursor. ...
    (microsoft.public.dotnet.framework.adonet)