title: Pass checkbox list multiple selected value to stored procedure through one parameter
body: <p>i have checkbox list to select multiple value  ,now i want to pass this multiple selected value to my stored procedure using one parameter</p>
  
  <pre><code>insert into tblAccessRights (roleid,customerid,SubcustomerId)
  values(@_roleid,@CustomerId,@SubcustomerId,)
  </code></pre>
  
  <p>in above query @SubcustomerId is parameter which will hold the multiple selected value from checkboxlist
  so,now the entry should be like as follow</p>
  
  <pre><code>roleid customerid subcustomerid
   1        2           6
   1        2           7
   1        2           8
  </code></pre>
  
  <p>this subcustomerid is multiple selected value from check box ,how can i achieve this with one parameter,if any other way to do this then please reply</p>
  
  <p>Can it be done with dynamic query if i take checkboxlist value as comma separated string and accordingly pass it to dynamic insert query...</p>