looping the dataset

How can I loop through a dataset ?You can use the following:

 Dim myDataRow as DataRow
 For Each myDataRow In myDataSet.Tables("table_name").Rows
 response.write(myDataRow("table_name").ToString())
 Next

To get what?
Dataset contains collection of datatables, constarins. Each one of datatables contains datarows and datacolumns. If you need an example, please specify what exactly are you trying to do.
this is the query I am using

SELECT * from tablename where tableid="+tblid+ " and tablename='"+tblname+"' ORDER BY row"

and reading it into the dataset.

Now I am trying to loop through the dataset to read the values of different columns in all rows in the "tablename" table.