title: Display gridview base on multiple values
body: <p>I am looking to pull my data to a grid view base on one parameters which is an ID; the tricky part is, this ID might content a multiple IDs. 
  In sql, I can write something like below.</p>
  
  <pre><code>Select * from table1 where ID in ('ID123', 'ID234', 'ID456').
  </code></pre>
  
  <p>How do I do that with sqldatasource. Note: I already pull a multiple values into lblID
  Below is what the structure that I have.</p>
  
  <pre><code>&lt;asp:SqlDataSource SelectCommand="SELECT * FROM [talbe1] WHERE ([ID] = @ID)"&gt;
  &lt;SelectParameters&gt;
  &lt;asp:ControlParameter Name="ID" ControlID="lblID" /&gt;
  &lt;/SelectParameters&gt;
  &lt;/asp:SqlDataSource&gt;
  </code></pre>