"SELECT" with disconnected data

Question

Just recently making the move from ASP.OLD to C#-based ASP.NET. From what I've read, with a disconnected DataSet, you can then somehow do the equivalent of a SQL SELECT on the recordset. (If I'm wrong please let me know!) However I cannot find any good info on how that is done. I'm hoping someone can take a look at what I am attemping, and tell me the best way using ADO to do it, as I may be heading in a bad direction. For an example of what I am trying to do: I've got a database table (Geo) with the following: ID: int (Autoindex, primary key) X: int Y: int Home: int The table consists of an X/Y grid of data. While I can do individual queries like "SELECT Home from Geo WHERE X=345 and Y=972" to get an individual value for Home, it's a pretty large grid (1000x1000, a million records), and I'll be accessing "square-shaped" chunks of that data, so I'm thinking it will probably quicker to do a query like: SELECT X,Y,Home FROM Geo WHERE (X BETWEEN 50 and 80) and (Y BETWEEN 200 and 220) Then somehow select from the DataSet using the X & Y values. But I have no idea how to "query" the dataset based on other columns in the dataset. In SQL syntax, doing the following on the DataSet returned above: SELECT Home from DataSet WHERE X=220 and Y=355 Someone with a clue stick, please bash me with it, thanks! :) Also, is there a good way to move the two dimensional data in the dataset into a two dimensional array?