private void PrintRows(DataSet myDataSet)
{
  // For each table in the DataSet, print the row values.
    foreach(DataTable myTable in myDataSet.Tables)
    {
      foreach(DataRow myRow in myTable.Rows)
      {
        foreach (DataColumn myColumn in myTable.Columns)
        {
          Response.Write(myRow[myColumn] + "
");
        }
      }
    }
  }

This method is called with

printRows(<datasetname>)

// Database is called “MarcTest1″
// Table is called “phonebook”
// DataSet is called “ds”

string m_Connect = “Data Source=(local);integrated security=SSPI;Initial Catalog=MarcTest1;”;
SqlConnection myConn = new SqlConnection(m_Connect);
SqlDataAdapter da = new SqlDataAdapter();
myConn.Open();
DataSet ds = new DataSet();
string sQueryString = “”;
sQueryString = “SELECT * FROM phonebook”;
da.SelectCommand = new SqlCommand(sQueryString,myConn);
da.Fill(ds, “ImportTable”);
myConn.Close();