title: Trying to filter dataGridView with combobox, error : "There is already an open DataReader"
body: <p>I have 2 tables. One is :</p>
  
  <p>Table A(</p>
  
  <p>idA</p>
  
  <p>name)</p>
  
  <p>FK numB(</p>
  
  <p>Table B</p>
  
  <p>idB</p>
  
  <p>CityName)</p>
  
  <p>I am trying to filter a dataGridView of the Table A with a CityName from a combobox.</p>
  
  <p>In my combobox properties : </p>
  
  <ul>
  <li><p>DataSource = TableB BindingSource</p></li>
  <li><p>DisplayMember = CityName</p></li>
  <li><p>ValueMember = idB</p></li>
  <li><p>SelectedValue = SpectacleBindingSource.numB</p></li>
  </ul>
  
  <p>Then the code i am trying to go with  :</p>
  
  <pre><code>        private void cbGenreB_SelectedIndexChanged(object sender, EventArgs e)
      {
          int value = 0;
  
  
          if (cbGenreB.SelectedIndex !=-1)
          {
              compare = (cbGenreB.SelectedIndex);
  
              this.ATableAdapter.FillByCityB(this.billetterieDataSet.A, compare);
          }
  </code></pre>
  
  <p>There is no problem with the select request, then i got this error message : </p>
  
  <p><a href="http://gyazo.com/1bb7b1792c3dce676b257245bbb72e97" rel="nofollow">http://gyazo.com/1bb7b1792c3dce676b257245bbb72e97</a></p>
  
  <p>Thanks for the help</p>