title: c# sqldataadapter params in using
body: <p>is there any option to initialize sqldataadapter with params ? I'm starting it with using so there's no option to use cmd.Parameters.AddWithValue .</p>
  
  <pre><code>using (SqlDataAdapter dap = new SqlDataAdapter("select * from smthg where kh_Symbol = '" + khSymbol + "'", cn,))
                  {}
  </code></pre>
  
  <p>I want to take of sql statement to the configuration file, but I want to kh_Symbol be in param like this:</p>
  
  <pre><code>select * from smthg where kh_Symbol = '@param'
  </code></pre>
  
  <p>I don't know how to do it in USING.</p>