Shawn,
An array might be a little faster perhaps ... I just prefer to use DataSets for everything (maybe I'm just stubborn? <g>)
And yes, because you have multiple forms that would be using this paradigm, you should have a separate Biz class that would handle any of the manipulation necessary to process the search criteria.
So, it sounds like you're on the right track.
~~Bonnie
>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.