Updated at the bottom
==============================
Thanks Bonnie, once again your input was valuable.
As far as building the Where clause, I've done it both ways ... building it in the Biz class *or* passing parameters to a Stored Proc. It depends on how generic it needs to be, I think.
I am going to pass a dataset, never thought of that. So I create the table in the GUI and then pass the Dataset as a parameter to the biz object - just to make sure I am getting this.
Or
because I have multiple forms that use the same style for filtering the data, just some may have or less "where clauses", would I create its own class and then just pass back the string where clause to the Biz, for customers, or suppliers?
I am just doing a sound check to make sure I got this idea right.
============================
OR
Would an array be better, less memory instensive and would it have a smaller footprint than a DataSet.
Because i look through an array as well.
I am looking for speed, so any suggestions is good.
Thanks Bonnie.