C# .NET - how to filter dataset?

Hi,
I'm working on an already built app (poorly built).
they do not have collections of objects to bind to a datatable... instead they bind the DataSet directly.  Now they want to build in some sort of filtering to filter the dataset.
now, usually, i build it into the stored procedure and pass in parameters, but, i do not want to modify the SP which does a straight SELECT all type syntax.
is it possible to filter the DataSet?   if so, how?   or will i need to reconstruct the stored procedure?

u can use a DatasetView for that

First, a DataSet is disconnected from the database, so once you have it you no longer have to be concerned about Stored Procs.
First, you have the DataTable Select method:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatatableclassselecttopic.asp
Next, you have the Find method:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatarowcollectionclassfindtopic2.asp
Remember, F1 and Google are your friends.

work like like a WHERE clause in SQL Server?
for example
ds.tables[0].select("firstname like '%a%' OR lastname like '%b'%")

I have one more link for you...  This one is a c# application with source code that does exactly what you want.
http://www.codeproject.com/csharp/OazSwitchNetConfig.asp

Hi,

You can filter dataset values using Select() method of dataset table.

Syntax :

<DataSet>.Tables[0].Select("UserName like 'geo%'");

and so on. Here Tables[0] denotes the first table of the dataset. So you can loop thru the dataset to filter the necessary table data.