Fetch database rows and store them in an object?

Hi!
Something that just hit me and I have sort of been looking for before is a way to actually call an SQL-Query command and then store all the rows that macthes that query into one object in an array-list..is there any such object avaible?
For instance:


//Retrives all the rows in an database that matches the query and stores the rows in myFetchedDbRows as an arraylist

FetchDbRows myFetchedDbRows = new FetchDbRows("SELECT * FROM xxxx WHERE [PROPORTIE1] = 1");


//So if I whould write something like
myFetchedDbRows[0]
//That whould simply give me the first row that matched the above expression..well I guess you sort of understand what Im looking for by now..
Is there any such object/control avaible?


Thanks in advance!

...