Re: a search panel (1 row grid) attached to a grid

From: Alex Taylor (basswar_at_vnet.hu)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 09:10:11 +0200

Hi Dhaval!

There are some dbgrid components that do some kind of sorting,
filtering, incremental searching on the fly at component level.
(DevExpress QuantumGrid, EHLib's TDbGridEh, etc.) But I suggest You
should write your own searching/filtering comp/method 'cause they are
all do this on the client side (IIR). With large datasets client-side
filtering/inc. searching is a nightmare. But it's on You, try these
grids, see the demos. But these demos all come with a minimal sized
database and You don't see their behaviour with large amount of data.
But everything depend on your needs. With large datasets I use
server-side filtering, ie. creating the SQL string dynamically based on
user input.

Regards:Alex

Relevant Pages

  • Re: ado search question
    ... sorting, filtering, searching ... > and cursor move to bottom ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: coding for combo box problems - handling entries -
    ... The real problem here is you are using a bound combo box for searching. ... Combos used for searching or filtering should not be bound controls. ...
    (microsoft.public.access.formscoding)
  • Re: DataTable vs DataView
    ... > filtering, sorting, and searching. ... I need to use a DataView. ... Bruce ...
    (microsoft.public.dotnet.languages.vb)
  • Re: News reader
    ... > i'm getting stressed of my outlook express and want to change. ... > any suggestion a better newsreader but have filtering like outlook ... searching OE does that XanaNews doesn't do at present? ...
    (borland.public.delphi.non-technical)