dropdownlist in asp.net mvc

Question

i just could not figure out how i will put my data on a selectlist for it to be displayed on a dropdownlist..

i am using mysql as my database.. on my model i have this query:

Imports Microsoft.VisualBasic
Imports System.Data

Public Class ClassCategoryConnection
Inherits ClassConnection

    Public Function SelectCategory() As DataTable
         Return ReadData("SELECT IDcategory, category FROM category")
     End Function
End Class

on my controller i have:

Public Class HomeController
Private Category As New ClassCategoryConnection
    Function Index() As ActionResult
        Dim _category As DataTable = Category.SelectCategory()
        Return View(_category)
    End Function
End Class

how will i construct my selectlist with this?..=)

thank you in advance!

Santhosh · Accepted Answer · 2009-09-14 07:04:03Z

3

You can do it in controller part and send the select list to view.

[Controller]

public IEnumerable<SelectListItem> List
{
     get
     {
          List<SelectListItem> list = new List<SelectListItem>();
          foreach(var data in _category){
                list.Add(new SelectListItem
                {
                     Text = data.field,
                     Value = data.field,
                 });
           }
          return list;
     }    
}

In the Index Action add the following code

ViewData["dropdownlist_name"] = List

In the View just create

<%=Html.DropDownList("dropdownlist_name") %>

answered Sep 14, 2009 at 7:04

Santhosh

20.5k23 gold badges67 silver badges76 bronze badges

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

1 Comment

tiff Over a year ago

can you please convert it to vb.net? i can't seem to convert it on the link provided by lucky below.. thank you!

Matthew Groves · Accepted Answer · 2009-09-14 12:39:53Z

0

In C# ,

Please convert it to to VB for your liking Here...

first thing passing a data table is a headache try passing it through the view data like

  return View (Category.SelectCategory().AsEnumerable().ToList());

and in the aspx page try using that like this

    Html.DropDownList("list",viewdata.model)

this should work ...

edited Sep 14, 2009 at 12:39

Matthew Groves

26.2k11 gold badges74 silver badges125 bronze badges

answered Sep 14, 2009 at 7:13

lucky

651 gold badge1 silver badge9 bronze badges

1 Comment

tiff Over a year ago

i got an error on the aspx page that says: Overload resolution failed because no accessible 'DropDownList' can be called without a narrowing conversion but when i removed the "list" it gave me this error: Conversion from type 'List(Of DataRow)' to type 'String' is not valid.

Collectives™ on Stack Overflow

dropdownlist in asp.net mvc

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related