Hey Nancy,
>Also, you might consider whether it makes sense to throw an exception if no matches are found instead of just setting the DataSet to null.Actually, I wouldn't do either. If no matches were found, and your DataSet still exists (IOW, don't set it to null), then you'll simply not have any rows in your DataSet. Depending on what you're doing with the returned DataSet, that may make more sense from a coding standpoint (DataBinding to a table with no rows in it most likely will require no additional coding, the stuff in the UI will simply be empty). Obviously though, it depends on what you're doing (your example of a Login attempt is probably better dealt with by an exception rather than an empty DataSet).
Just my 2 cents.
~~Bonnie