title: WHERE clause in a SQL statement in C#
body: <p>I am trying to define two conditions for a <code>WHERE</code> clause:</p>
  
  <pre><code>WHERE Date = @date (already implemented)
  and
  WHERE Type = @currenttype
  </code></pre>
  
  <p>Code as follows:</p>
  
  <pre><code>string sql = string.Format("SELECT Result FROM {0} WHERE Date = @date", hostnameclear);
  </code></pre>
  
  <p>Would I use two <code>WHERE</code> clauses, or can I specify two conditions?</p>