# ASP.NET String to checkbox list

**URL:** <https://forum.kirupa.com/t/asp-net-string-to-checkbox-list/317415>\
**Category:** programming\
**Created:** [December 19, 2010, 11:09pm UTC](https://forum.kirupa.com/t/asp-net-string-to-checkbox-list/317415 "2010-12-19T23:09:11Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![yanivamar](https://avatars.discourse-cdn.com/v4/letter/y/d9b06d/32.png) [@yanivamar](https://forum.kirupa.com/u/yanivamar)\
**Post date:** [December 19, 2010, 11:09pm UTC](https://forum.kirupa.com/t/asp-net-string-to-checkbox-list/317415/1 "2010-12-19T23:09:11Z")

</div>

I am trying to retrieve a string of data from a single column and then explode it out and use its values to create a check box list

example.  
user enters their id.

SELECT [IMR], [Social] FROM [AlphaRoster] WHERE ([Social] = @Social)

is run

pulling out the record in column IMR

however im left with a string. value1,value2,value3…

i would like to know how i could seperate those values in [asp.net](http://asp.net)  
i know in php i would use the explode() but how do i get the check box to list those values not just one row containing a string.

Thank you for your help.