title: C# How to output multiple sql data to text? (Single query is working)
body: <p>I'm searching for a tip or a code sample to output multiple records within my SQL database with the same name, called Auftragsnummer but differently second values called Stellplatz, to a textbox.</p>
  
  <p>This is my working code, to output one search query to two textboxes:</p>
  
  <pre><code>private void search_btn_Click(object sender, EventArgs e)
      {
          con.Open();
          cmd.Connection = con;
          SqlCommand myCommand = new SqlCommand("SELECT * FROM[FAUF] WHERE Auftragsnummer = '" + txt_search.Text + "'", con);
          mdr = myCommand.ExecuteReader();
          if (mdr.Read())
          {
              txt_searchNr.Text = mdr["Auftragsnummer"].ToString();
              txt_searchSF.Text = mdr["Stellplatz"].ToString();
              txt_search.SelectAll();
          }
          else
          {
              txt_searchNr.Text = "---";
              txt_searchSF.Text = "---";
              txt_search.SelectAll();
              MessageBox.Show("Keine Daten gefunden - Bitte überprüfen Sie Ihre Eingaben!");
  
          }
          con.Close();
      }
  </code></pre>
  
  <p>The user can add the Auftragsnummer multiple times with differently second values named Stellplatz.</p>
  
  <pre><code>Example:
  102555 - &gt; 3
  102555 - &gt; 7
  </code></pre>
  
  <p>How I get the second record from my SQL database into a second output within my Code?</p>