Get and display the values in dropdown from database

[الجنرال]

I want to retrieve the values what is in database to the dropdown. Here I have 3 Phases. Degree1, Degree2, Degree3. But In database i had one table for storing 3 items. But In view I want to take seperate using Id's. I use some type of code. But Its not retrieveing correctly. It is just count the values totally only. Can anyone give me advice?My code is\[code\] <div class="editor-label clear"> <%: Html.Label("Basic Qualification")%> </div> <div class="editor-field"> <% if (ViewData["BasicQualificationDegrees"]!=null){ %> <% var BasicQualificationDegree1 = Model.CandidateQualifications; %> <%for (int i = 0; i < Model.CandidateQualifications.Count; i++){%> <div id="basic-qualification-container1" style="margin-bottom:4px;" class="basic-qualification-container left"> <%: Html.DropDownList("BasicQualificationDegree1", new SelectList((IEnumerable<Dial4Jobz.Models.Degree>)ViewData["CandidateBasicQualifications"], "Id", "Name", (IEnumerable<int>)ViewData["BasicQualificationDegrees"]), "None",new { @class = "qualification" })%> <%: Html.TextBox("BasicQualificationSpecialization1", "", new { @title = "Enter basic qualification degree", @class="specialization" })%> <%} %> <%} else { %> <select id="BasicQualificationDegree1" name="BasicQualificationDegrees"></select> <%} %> </div> <div class="left"> <input type="button" id="btnAddBasicQualification" value="http://stackoverflow.com/questions/12798561/Add" /> <input type="button" id="btnDelBasicQualification" value="http://stackoverflow.com/questions/12798561/Remove" /> </div> </div> <div class="editor-label clear"> <%: Html.Label("Post Graduation")%> </div> <div class="editor-field"> <%if (ViewData["PostGraduationDegrees"] != null) { %> <% var BasicQualificationDegree1 = Model.CandidateQualifications; %> <% for (int i=0; i < BasicQualificationDegree1.Count();i++) {%> <div id="post-graduation-container1" style="margin-bottom:4px;" class="post-graduation-container left"> <%: Html.DropDownList("PostGraduationDegree1", new SelectList((IEnumerable<Dial4Jobz.Models.Degree>)ViewData["CandidatePostQualifications"], "Id", "Name", (IEnumerable<int>)ViewData["PostGraduationDegrees"]), "None",new { @class = "qualification" })%> <%: Html.TextBox("PostGraduationSpecialization1", "", new { @title = "Enter post graduation degree", @class = "specialization" })%> <%} %> <%} else { %> <select id="BasicQualificationDegree2" name="PostGraduationDegrees1"></select> <%} %> </div> <div class="left"> <input type="button" id="btnAddPostGraduation" value="http://stackoverflow.com/questions/12798561/Add" /> <input type="button" id="btnDelPostGraduation" value="http://stackoverflow.com/questions/12798561/Remove" /> </div> </div> <div class="editor-label clear"> <%: Html.Label("Doctorate")%> </div> <div class="editor-field"> <% if (ViewData["DoctorateDegrees"]!=null){ %> <% var BasicQualificationDegree3 = Model.CandidateQualifications.ToList(); %> <% for (int i=0; i < BasicQualificationDegree3.Count();i++) {%> <div id="doctorate-container1" style="margin-bottom:4px;" class="doctorate-container left"> <%: Html.DropDownList("DoctorateDegree1", new SelectList((IEnumerable<Dial4Jobz.Models.Degree>)ViewData["CandidateDoctorate"], "Id", "Name", (IEnumerable<int>)ViewData["DoctorateDegrees"]), "None", new { @class = "qualification" })%> <%: Html.TextBox("DoctorateSpecialization1", "", new { @title = "Enter doctorate degree", @class="specialization" })%> <%} %> <%} else { %> <select id="BasicQualificationDegree3" name="BasicQualificationDegrees"></select> <%} %> </div> <div class="left"> <input type="button" id="btnAddDoctorate" value="http://stackoverflow.com/questions/12798561/Add" /> <input type="button" id="btnDelDoctorate" value="http://stackoverflow.com/questions/12798561/Remove" /> </div> </div>\[/code\]