How to put the database values in an array in controller in asp.net mvc3

Question

I have a table named Scope in my databse, This table has two columns: ScopeName ad ScopeID. How can I pass all the data of ScopeName column to my controller and put them in an array? after that I want to show the content in a dropdown list in my view. Thanks

How are you currently getting data out of your db? What have you tried? — CD Smith
– CD Smith, Commented Jun 8, 2012 at 18:23

Charmander · Accepted Answer · 2012-06-08 18:49:22Z

3

If you can get ahold of an IQueryable<Scope> from your database, this LINQ code should work:

var scopeNames = (from s in DB.GetScopes()
                 select s.ScopeName).ToArray();

answered Jun 8, 2012 at 18:49

Charmander

1961 silver badge14 bronze badges

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

1 Comment

starrr Over a year ago

Thanks for your answer, Now how can I show this array in a dropdown list in my view?

Pablo Claus · Accepted Answer · 2012-06-12 01:30:31Z

2

following @Charmander answer..

To pass the data to the view you can do this:

In your controller create a SelectList with your array and pass it to your view:

ViewBag.myList = new SelectList(scopeNames);

Then in your view, use Html.DropDownlist:

@Html.DropDownList("myList", String.Empty)

edited Jun 12, 2012 at 1:30

answered Jun 12, 2012 at 1:22

Pablo Claus

5,9163 gold badges31 silver badges40 bronze badges

Collectives™ on Stack Overflow

How to put the database values in an array in controller in asp.net mvc3

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related