title: How to find rows in a column that start with a specific name?
body: <pre><code>       private void button1_Click(object sender, EventArgs e)
         { 
          SqlConnection connection = new SqlConnection(@"Database Login");
          connection.Open();
  
          SqlCommand command = new SqlCommand("SELECT * FROM table WHERE row = '" + textBox1.Text + "%' AND row = '%" + textBox2.text + "%'", connection);
          SqlDataReader dataReader = command.ExecuteReader();
  
          if (dataReader.Read())
          {
              textBox3.Text = dataReader.GetString(1);
          }
  
      }
  
      private void textBox1_TextChanged(object sender, EventArgs e)
      {
  
      }
  
      private void textBox2_TextChanged(object sender, EventArgs e)
      {
  
      }
  
      private void textBox3_TextChanged(object sender, EventArgs e)
      {
  
      }
  </code></pre>
  
  <p>For example I have row like:</p>
  
  <p>banana-orange-apple</p>
  
  <p>apple-orange-banana</p>
  
  <p>orange-apple-banana</p>
  
  <p>banana-apple-orange</p>
  
  <p>and I need to output in textBox3 answers where all lines for example start from banana so answers will be about:</p>
  
  <p>banana-orange-apple</p>
  
  <p>banana-apple-orange</p>
  
  <p>But when I press button nothing happen, so where is my mistake, as I understand I use dataReader.Read wrong and maybe my SQL code also wrong?</p>