title: ADO.NET TableAdapter parameters
body: <p>I have a query that I wish to run through an ASP.NET TableAdapter that contains an 'IN' clause which is to receive it's values through a parameter.</p>
  
  <p>My question is, how do I specify this parameter? I thought of writing the conditional statement like this:</p>
  
  <pre><code>AND b.group_category_id in (@ParamList)
  </code></pre>
  
  <p>where the @ParamList is a String of the parameters, e.g. "4,12,45,23" but since the specified id is an Integer, it complains that it cannot convert String to Integer. This makes sense, but is there any way to specify such a list in a SQL statement in an ASP.NET TableAdapter?</p>