Filtering a DataSet or DataTable

[GarethKruse]

Hello,

I'm new to SQL Server T-SQL and C#.

In a method of a web application, I create an SQLDataAdapter and execute a stored procedure on the SQL Server from within the C# method. The corresponding query result is filled into a DataSet. Now I want to filter the result set in the same method according to some criteria like:

FilteredResult =
filter (FilledDataSet or DataTable, criteria)

where criteria is something like:

select ....
from ...
where ....
.
.
.



Could you give me a simple example?

Thank you in advance.

Gareth