how to convert datatable to list?
<p>I have a dataset with few rows and columns in it, in the columns state there will be many matching rows, i want all the rows with same state to bind it to some list..how to achieve it.</p>

<p>I need it because i have same capital in all the rows where i have same state, so i don' t want the loop to run each and every time...instead i want to bind all the rows where there is same capital and use that data.</p>

<pre><code>  DataSet ds = new DataSet();
  da.Fill(ds, "table1");
  DataTable dt = new DataTable();
  dt = ds.Tables[0];
</code></pre>

<p>let me be more clear</p>

<p>i have a dataset with columns state, capital, population...i want to use this data in some other method so im using loop, when the state is tamilnadu, the capital and population will be same in all the rows..so its unnecessary to loop again and again for the data, so instead i want to bind the data with same state to something and use it..this is my requirement..</p>
