title: Passing a SQL parameter to an IN() clause using typed datasets in .NET
body: <p>First apologies as there are similar questions on this site, but none of them answer this problem directly.</p>
  
  <p>Im using typed datasets in VS 2010. I create a TableAdapter in a Dataset with a query like:</p>
  
  <pre><code>SELECT * from Table WHERE ID IN(@IDs)
  </code></pre>
  
  <p>Now if I call: <code>TableAdapter.Fill(MyDataTable,"1,2,3")</code> an error occurs stating that VS cannot convert 1,2,3 to type int. Fair enough.</p>
  
  <p>So then i decide to change the Parameter (i.e. @IDs) type to string in the Parameter collection. Try again - still the same error message.</p>
  
  <p>So is there any way this typed dataset can accept my "1,2,3" parameter? At the moment i only have a few parameters to pass, so i could easily just create 5 or so parameters and pass them separately, but what if there are hundreds? Is there any way I can call the <code>Fill()</code> method with my comma separated parameter?</p>
  
  <p>(i know i can use Dynamic SQL to create the statement and execute it but would prefer if there is another way allowing me to keep my typed dataset for use in e.g. ReportViewer/bindingsources)</p>