title: MySQLConnector c# update MySqlCommand parameters
body: <p>I have a foreach loop in C# wich execute a MySql command to check if the result exist, the problem is I dont know how to update the value in the parameters corresponding to <code>@id_line</code> an error is thrown at the second iteration</p>
  
  <pre><code>foreach (String[] infos in ReferenceLine.getList())
  {
      cmd.Parameters.AddWithValue("@id_line", infos[0].ToString());
      using (MySqlDataReader reader = cmd.ExecuteReader())
      {
          if (reader.HasRows) { return true; }
      }
  }
  </code></pre>
  
  <blockquote>
    <p>I thought of checking if the value exist and deleting it but I dont find this solution <strong>clean</strong></p>
  </blockquote>
  
  <p>Thanks </p>