title: Simple SQL select in C#?
body: <p>On my current project, to get a single value (select column from table where id=val), the previous programmer goes through using a datarow, datatable and an sqldatadapter (and of course sqlconnection) just to get that one value.</p>
  
  <p>Is there an easier way to make a simple select query? In php, I can just use <code>mysql_query</code> and then <code>mysql_result</code> and I'm done.</p>
  
  <p>It would be nice if I could just do:</p>
  
  <pre><code>SqlConnection conSql = new SqlConnection(ConnStr);
  SomeSqlClass obj = new SomeSqlClass(sql_string, conSql);
  conSql.Close();
  return obj[0];
  </code></pre>
  
  <p>Thanks for any tips.</p>