Best practice to filter data?

[Richard Fagen]

Hi,

What are the best practices to filter a datagrid based on user input?

For example:
I want to display a grid with rows of sales information and allowed the
users to specify options (ex: customer and date ranges), then when they
click the 'apply filter' button, I want the rows filtered.

I've read about methods using a dataview with the rowfilter and sort
properties. I also read about re-issuing a sqlselect command and then
refilling the dataset.

Is it a good idea to use the data adapter wizard with parameters?
I have tried using the "?" syntax when using the data adapter wizard,
but then I ran into problems when I tried to rename the paramters to
something more meaningful than param2, param3, etc. I suspect it is
best to code these statements by hand.

What would really help me (and I'm sure other out too) is a good example
filtering the PUBS database in a simple form with just a grid and a
few controls for the filters.

Thanks

Richard

 

[Cor Ligthert]

Richard,

Please don't multipost about almost the same topics. It makes answering
almost impossible.

Cor