>That's pretty much what I thought...I knew you could do filters and other things in ADO.NET, but didn't think that actual SQL statements could be executed.
>

Other than the filtering of a table that ADO.NET provides, another alternative is to put the data into an XMLDataDocument and use a XPath query.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconperformingxpathqueryondataset.asp