title: asp.net stored procedure,multiple values in a single parameter
body: <p>Im fairly new to Asp.Net arena here guys,so please bear with me if say something that's not logical.</p>
  
  <p>I have a procedure that binds to a grid-view that displays data based on the selection made from a drop-down box. It works fine when a single value is sent but I'm thinking of doing multiple selection from the drop-down[using checkboxes] or even using a list-view, and I'm confused how to go about it. This is the code for the stored procedure. At the moment it accepts only a single value. For e.g., if I select Africa from the drop-down it displays all the cities from Africa. But now I would like to have multiple selections for the drop-down so that the grid display cities from more than one country.</p>
  
  <pre><code>CREATE PROCEDURE sp_getCities 
  (
  @p_country  nvarchar(50)
  )
  AS
  
  SELECT country, cities
  FROM world WHERE country=@p_country
  </code></pre>
  
  <p>I'm sure there are people who must have come across situations like this. If you have could you please provide me with a link to a tutorial or a solution?</p>