title: Getting value from a DataSet into a variable
body: <p>I have the following method which returns dataset. I am using .NET 2.0</p>
  
  <pre><code>DataSet ds = GetAllRecords();
  </code></pre>
  
  <p>I want to get values from each column for a particular row and bind it to a variable.
  How can this be achieved?</p>
  
  <p>currently the method returns all the row from the table and I have to find that particular row based on ID.</p>
  
  <p>However, if that is not possible I can come with</p>
  
  <pre><code>DataSet ds = GetSpecificRecord(id);
  </code></pre>
  
  <p>But I still need to get values from each column and bind it to variable. 
  Please advice.</p>