467,182 Members | 1,054 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,182 developers. It's quick & easy.

Best practice to filter data?

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
Nov 21 '05 #1
  • viewed: 1212
Share:
1 Reply
Richard,

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

Cor
Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

145 posts views Thread by Mark Johnson | last post: by
2 posts views Thread by Joe Bloggs | last post: by
3 posts views Thread by cbrown@duclaw.com | last post: by
18 posts views Thread by Bob Stearns | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.