Databases
StackOverflow2013
Postsdbo
POFill Dropdownlist with values from sql database in MVC4
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFill Dropdownlist with values from sql database in MVC4
    text
    copied!<p>I have a table in my database which I select all Mem_NA to fill it in my dropdownlist in my view.</p> <p>I can't understand how can I fill the values in there? Someone can give me a hand?</p> <p>My Model</p> <pre><code>public class MemberBasicData { public int Id { get; set; } public string Mem_NA { get; set; } public string Mem_Occ { get; set; } } public List&lt;MemberBasicData&gt; GetAllMembers() { DateTime today = DateTime.Now; List&lt;MemberBasicData&gt; mbd = new List&lt;MemberBasicData&gt;(); using (SqlConnection con = new SqlConnection(Config.ConnectionString)) { using (SqlCommand cmd = new SqlCommand("SELECT Id,Mem_NA,Mem_Occ FROM Mem_Basic", con)) { try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { MemberBasicData mb = new MemberBasicData(); mb.Id = (int)reader["Id"]; mb.Mem_NA = (string)reader["Mem_NA"]; mb.Mem_Occ =(string)reader["Mem_Occ"]; mbd.Add(mb); } } catch (Exception e) { throw e; } finally { if (con.State == System.Data.ConnectionState.Open) { con.Close(); } } return mbd; } } } </code></pre> <p><code>GetAllMembers()</code> function is an IEnumerable function which I was used for get all details of members. Can I use the same function for filling the dropdown list?</p> <p>My controller</p> <pre><code>public ActionResult Register() { return View(new Member()); } </code></pre> <p>And View</p> <pre><code>@Html.DropDownListFor("-- Select --", new SelectList("")) &lt;=== ???? i dont know </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload