Hi, Paul,
You can take your dataset and apply a 'rowfilter', or use the select() function to retrieve a subset of data - the filter that you apply will go to a certain dataview...for instance..
DsCustomers.Tables[0].DefaultView.RowFilter = "balance > 1000";
dataGrid1.DataSource = DsCustomers.Tables[0].DefaultView;
Keep in mind that you can't do full-blown SQL statements against ADO.NET data. The rowfilter is basically limited to the table to which you're applying the filter - it's best to do all the major querying in the backend (SQL Server or whatever).
If you do a few searches on rowfilter and dataview over the last year here on this forum, you'll find several more detailed examples.
Hope this helps...
Kevin