title: How to get data from server into Datagridview C#
body: <p>I want to get some Data displayed at a DataGridview. </p>
  
  <p>Here is what I tryed so far :</p>
  
  <pre><code>            cn.Open();
              SqlDataAdapter sda = new SqlDataAdapter("select * FROM Arbeiter WHERE (Name Like '%" + tbSuche.Text + "%'", cn);
              DataTable dt = new DataTable();
              sda.Fill(dt);
              dataGridView1.DataSource = dt;
  </code></pre>
  
  <p>I get the error :</p>
  
  <blockquote>
    <p>An unhandled exception of type 'System.Data.SqlClient.SqlException'
    occurred in System.Data.dll</p>
  </blockquote>
  
  <p>it works without the WHERE part ... so I think the error should be there .</p>
  
  <p>Thanks for your help</p>