title: Getting a specified column's value based on the value in another column of the same row?
body: <p>I have this SQL Table:</p>
  
  <pre><code>TABLE: Info
  
  COLUMNS:|   Name   |  Value
  --------|----------|------------------
  ROW:    |   Server |  255.255.255.255
  ROW:    |   Host   |  212.212.212.212
  ROW:    |   User   |  Admin
  </code></pre>
  
  <p>I'm selecting this table like that: <code>SELECT  * FROM Info</code></p>
  
  <p>Now after I got all in this table.</p>
  
  <p>I want to get the value <code>Where Name = 'Server'</code> and put it into the <code>Server</code> variable.</p>
  
  <p>What is the best method to do it in C#?</p>
  
  <p>DataSet? DataReader? And how can I accomplish this?</p>
  
  <hr>
  
  <p>If you didn't understand what I need here is another good explanation thx to Tim:</p>
  
  <p><em>I'm trying to get a specified column's value based on the value in another column of the same row</em> </p>