Eric,
This is more of a question for the ado newsgroup:
microsoft.public.dotnet.framework.adonet. But to answer your question, the
following whitepaper may help you out:
No, you can do just basic filtering in Select method. You need to go to the
database for anything more sophisticated. Of cause, you can always do
whatever you wish programmatically, you may choose this if another database
query would be too expensive.