DataTable and SQL Queries

[zoltan_ie]

Is there an method or a way of preforming a SQL SELECT statement on a DataTable so that it returns a array of Rows?

The DataTable.Select() method won't do the job as my query is a bit too complex for me to use it.

This is my SQL query:

SELECT COUNTY_ID , NAME
FROM TOWNS
WHERE NAME IN
( SELECT NAME FROM TOWNS
GROUP BY NAME HAVING COUNT(*) > 1);

Do I need to use a SQLDataAdapter or something? Just a guideline on how I should go about doing this would be helpful.

Thanks