title: Syntax error: Missing operand after 'Student' operator
body: <p>This is the code I have:</p>
  
  <pre><code>private void btnSearch_Click(object sender, RoutedEventArgs e)
  {
  
          using (SqlConnection sc = new SqlConnection(sConn))
          {
              sc.Open();
  
  
              string SearchFor = txtSearch.Text;
  
  
  
              using (SqlDataAdapter adapter = new SqlDataAdapter())
              {
                  DataTable dt = new DataTable();
                  grdData.ItemsSource = dt.DefaultView.RowFilter = string.Concat("SELECT * FROM Student WHERE Forename LIKE '%", SearchFor, "%'");
              }
  </code></pre>
  
  <p>When I run the code I get:</p>
  
  <blockquote>
    <p>"Syntax error: Missing operand after 'Student' operator."</p>
  </blockquote>
  
  <p>I'm using WPF... I want it so I can search for people by just typing a letter of their name what can I do?</p>