By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,885 Members | 1,469 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,885 IT Pros & Developers. It's quick & easy.

Best practice to filter data?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.