title: Query with parameter
body: <p>I have a query in <code>Mysql</code> like the following:</p>
  
  <pre><code>SELECT        id, nome, sigla
  FROM            pais
  WHERE    (estado=@estado)
  </code></pre>
  
  <p>In my code without using the parameter I would simply use:</p>
  
  <pre><code>this.cidadeTableAdapter.Fill(this.anfeDataSet1.cidade); 
  </code></pre>
  
  <p>and everything would be ok.</p>
  
  <p>More using the parameter how do I put a value on the parameter and pass to the TableAdapter?</p>