title: Data Adapter Filter
body: <p>I'm using the wizards etc to create a c# form based application that uses a database for storage etc.</p>
  
  <p>I have a customer form that currently lists all records in a datagrid.</p>
  
  <pre><code>private void frm_customer_Load(object sender, EventArgs e)
  {
      this.tbl_customerTableAdapter.Fill(this.myDataSet.tbl_customer);
  }
  </code></pre>
  
  <p>I'm hoping to filter the records.</p>
  
  <p>After reading some other topics I've discovered that a Select method may be used to filter my TableAdapter. So far I have the following attached to a button.</p>
  
  <pre><code>string qString = "cust_postcode = CF48 4JY";
  string oString = "cust_postcode DESC";
  myDataSet.tbl_customer.Select(qString, oString);
  </code></pre>
  
  <p>When I hit the button it throws the following error;</p>
  
  <p>"Syntax error: Missing operand after '4' operator."</p>
  
  <p>I'm aware that the problem is to do with the qString itself, however I can't seem to find the correct way to do the query.</p>
  
  <p>Any ideas?</p>