Retrieve data from database column in WebMatrix

Question

Im using WebMatrix 2. I need retrieve data from column in my database. This is database column:

enter image description here

I have used this code to retrieve data and get it in combobox

@{ var db1 = Database.Open("StarterSite"); var selectCommand = "SELECT Motivo FROM Set_Residenziali"; var selectedData = db1.Query(selectCommand); } <select name="motivo"> @foreach(var row in selectedData) { <option value="@row.Motivo">@row.Motivo</option> } </select>

With this code I get this result:

enter image description here

But I need obtain this result:

enter image description here

I tried many solutions, without success. Thanks in advance!

Mike Brind · Accepted Answer · 2013-05-02 20:00:51Z

You need to split the value:

<select name="motivo"> @foreach(var row in selectedData){ foreach(var item in row.Motivo.ToString().Split(new [] {','})){ <option>@item</option> } } </select>

Collectives™ on Stack Overflow

Retrieve data from database column in WebMatrix

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related