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.