Index: /Users/jcarnell/groovy_projects/groovy/src/main/groovy/sql/DataSet.java
===================================================================
--- /Users/jcarnell/groovy_projects/groovy/src/main/groovy/sql/DataSet.java	(revision 5718)
+++ /Users/jcarnell/groovy_projects/groovy/src/main/groovy/sql/DataSet.java	(working copy)
@@ -50,9 +50,13 @@
 
 import java.sql.Connection;
 import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.ResultSetMetaData;
 import java.sql.SQLException;
+
 import java.util.ArrayList;
 import java.util.Iterator;
+import java.util.LinkedHashMap;
 import java.util.List;
 import java.util.Map;
 import java.util.logging.Level;
@@ -92,6 +96,7 @@
         this.table = table;
     }
 
+    
     public DataSet(DataSet parent, Closure where) {
         super(parent);
         this.table = parent.table;
@@ -99,6 +104,7 @@
         this.where = where;
     }
 
+    
     public void add(Map values) throws SQLException {
         StringBuffer buffer = new StringBuffer("insert into ");
         buffer.append(table);
@@ -210,4 +216,61 @@
     public DataSet createView(Closure criteria) {
     	return new DataSet(this, criteria);
     }
+    
+     /**
+      * Returns a List of all of the rows from the table a DataSet
+      * represents
+      * @return  Returns a list of GroovyRowResult objects.
+      * @throws SQLException
+      */
+     public List rows() throws SQLException {
+    	String sql  = "SELECT * FROM " + table;
+    
+        List results = new ArrayList();
+        Connection connection = createConnection();
+        
+        java.sql.Statement statement = connection.createStatement();
+        
+        
+        configure(statement);
+        ResultSet rs = null;
+        try {
+            log.fine(sql);
+            
+            
+            rs = statement.executeQuery(sql);
+            
+            while (rs.next()) {
+                ResultSetMetaData metadata = rs.getMetaData();
+                LinkedHashMap lhm = new LinkedHashMap(metadata.getColumnCount(),1,true);
+                for(int i=1 ; i<=metadata.getColumnCount() ; i++) {
+                      lhm.put(metadata.getColumnName(i),rs.getObject(i));
+                }
+                 	
+                GroovyRowResult row = new GroovyRowResult(lhm);
+                results.add(row);
+            }
+            
+            return(results);
+        }
+        catch (SQLException e) {
+            log.log(Level.FINE, "Failed to execute: " + sql, e);
+            throw e;
+        }
+        finally {
+            closeResources(connection, statement, rs);
+        }
+    }
+     
+     /**
+      * Returns the first row from a DataSet's underying table
+      * 
+      * @return
+      * @throws SQLException
+      */
+     public Object firstRow() throws SQLException{
+    	 List rows = rows();
+         if (rows.isEmpty()) return null;
+         return(rows.get(0));
+     }
 }