Sunday, 25 August 2013

Fill Dropdownlist with values from sql database in MVC4 using c#

Fill Dropdownlist with values from sql database in MVC4 using c#

i have a table in my database which i select all Mem_NA to fill it in my
dropdownlist in my view.
i can´t understand how can i fill the values in there.someone can give me
a hand?
My Model
public class MemberBasicData
{
public int Id { get; set; }
public string Mem_NA { get; set; }
public string Mem_Occ { get; set; }
}
public List<MemberBasicData> GetAllMembers()
{
DateTime today = DateTime.Now;
List<MemberBasicData> mbd = new List<MemberBasicData>();
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;
}
}
}
GetAllMembers() function is an IEnumerable fuction which i was used for
get all details of members. Can i use the same function for filling the
dropdown list. My controller
public ActionResult Register()
{
return View(new Member());
}
And View
@Html.DropDownListFor("-- Select --", new SelectList("")) <=== ???? i
dont know

No comments:

Post a Comment