//Display Specification in dropdown in Add Doctor
public void showSpecDropDown()
{
Models.Specialization spec = new Specialization();
DataSet data = spec.GetSpecDDown();
List <SelectListItem> speclist = new List <SelectListItem>();
foreach (DataRow dr in data.Tables[0].Rows)
{
speclist.Add(new SelectListItem {
Text = dr["SPEC_NAME"].ToString(), Value = dr["SPEC_ID"].ToString()
});
}
ViewBag.Specs = speclist;
}