ASP.NET Razor C# SQL Database Dropdown List

Question

I am hoping someone can help me. I am sure this is quite simple, but I have spent many hours searching for the answer and nothing seems to be working. I have a CSHTML file in Microsoft WebMatrix with Razor/C# code and HTML markup as well as a basic SQL table. I would like to put a dropdown list which displays the results of a SQL query. Below is my code.

@{

var db = Database.Open("QualityMonitoring") ;
var listAgent = "SELECT Agent FROM Data";

}

How do I create a dropdown list to display the results in my markup?

Any help would be greatly appreciated.

What is the name of your dropdownlist

Murtaza Munshi
– Murtaza Munshi

2013-09-01 14:42:16 +00:00
Commented Sep 1, 2013 at 14:42 — Murtaza Munshi
– Murtaza Munshi, Commented Sep 1, 2013 at 14:42

afzalulh · Accepted Answer · 2013-09-01 16:32:31Z

4

You have to create a SelectedListItem list and bind a dropdownlist to it. Extend the code to:

@{
    var db = Database.Open("QualityMonitoring") ;
    var listAgent = "SELECT Agent FROM Data";

    List<SelectListItem> agentdropdownlistdata = new List<SelectListItem>();
    bool isSelected = false;
    foreach(var item in db.Query(listAgent)){   
        agentdropdownlistdata.Add(new SelectListItem
        {
            Text = item.AgentName,
            Value = item.AgentID.ToString(), 
            Selected = isSelected
        });
    }
}

And in the markup use html helper to bind the data:

 @Html.DropDownList("Agents", agentdropdownlistdata)

edited Sep 1, 2013 at 16:32

answered Sep 1, 2013 at 16:06

afzalulh

7,9432 gold badges28 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

dreamviewer Over a year ago

Thanks afzalulh, I have applied your code and markup, but I am getting the following error. Compiler Error Message: CS1526: A new expression requires (), [], or {} after type Source Error: Line 7: foreach(var item in db.Query(listAgent)){ Line 8: isSelected = false; Line 9: agentdropdownlistdata.Add(new SelectList Item Line 10: { Line 11: Text = item.AgentName,

afzalulh Over a year ago

Sorry for the typo! It should be SelectListItem, not SelectList Item. I have edited my answer.

dreamviewer Over a year ago

Thanks. This worked, although I had to comment out Value = item.ID.ToString(), as this produced an error on rendering. How would I make it so no default value is selected? It can say "Please Choose..." for example?

afzalulh Over a year ago

You can add a new SelectListItem as selected: agentdropdownlistdata.Add(new SelectListItem {Text = "Select one",Value = "0", Selected = true }); outside the foreach loop.

Murtaza Munshi · Accepted Answer · 2013-09-01 14:42:59Z

2

Try this and tell me if the problem gets solved:

DropDownlist.DataSource = listAgent;

answered Sep 1, 2013 at 14:42

Murtaza Munshi

1,0854 gold badges14 silver badges40 bronze badges

4 Comments

dreamviewer Over a year ago

Thanks for replying so quickly. listAgent is the variable which contains the SQL statement. Do I put your suggestion in the code or the markup? I am not sure how to create the dropdown list in the markup. Since it is Razor, I am thinking something which would require @ before it.

Murtaza Munshi Over a year ago

Well i am not quite familiar with razor, but the code above i showed you must be put in the code section not markup

dreamviewer Over a year ago

@afzalulh, how can I give this dropdown list a name so I can pass its value to a variable?

Murtaza Munshi Over a year ago

In the design view select the control and change its name in properties.

Collectives™ on Stack Overflow

ASP.NET Razor C# SQL Database Dropdown List

2 Answers 2

4 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related