c# - Retrieve data from database column in WebMatrix -

im using webmatrix 2. need retrieve data column in database. database column:

i have used code retrieve data , in combobox

@{ var db1 = database.open("startersite"); var selectcommand = "select motivo set_residenziali"; var selecteddata = db1.query(selectcommand);  }  <select name="motivo">     @foreach(var row in selecteddata)     {         <option value="@row.motivo">@row.motivo</option>     } </select> 

with code result:

but need obtain result:

i tried many solutions, without success. in advance!

you need split value:

<select name="motivo">     @foreach(var row in selecteddata){         foreach(var item in row.motivo.tostring().split(new [] {','})){         <option>@item</option>         }     } </select>