public ActionResult Bed() { List <Bed> CategoryList = new List <Bed>(); Property p = new Property(); DataSet ds = new DataSet(); p.OnTable = "FetchBed"; ds = dl.FetchBed_sp(p); List <SelectListItem> Typeinventory = new List <SelectListItem>(); Typeinventory.Add(new SelectListItem { Text = "Select", Value = "" }); foreach (DataRow dr in ds.Tables[1].Rows) { Typeinventory.Add(new SelectListItem { Text = dr["Purpose"].ToString(), Value = dr["TId"].ToString() }); } ViewBag.Typeinventory = new SelectList(Typeinventory, "Value", "Text"); List <SelectListItem> Groupinventory = new List <SelectListItem>(); Groupinventory.Add(new SelectListItem { Text = "Select", Value = "" }); foreach (DataRow dr in ds.Tables[2].Rows) { Groupinventory.Add(new SelectListItem { Text = dr["GName"].ToString(), Value = dr["BGId"].ToString() }); } ViewBag.Groupinventory = new SelectList(Groupinventory, "Value", "Text"); try { foreach (DataRow item in ds.Tables[0].Rows) { Bed m = new Bed(); m.BId = item["BId"].ToString(); m.BName = item["BName"].ToString(); m.TId = item["TId"].ToString(); m.Purpose = item["Purpose"].ToString(); m.BGId = item["BGId"].ToString(); m.GName = item["GName"].ToString(); m.AddedBy = item["AddedBy"].ToString(); m.IsActive = item["IsActive"].ToString(); CategoryList.Add(m); } ViewBag.CategoryList = CategoryList; } catch (Exception e) { } return(View()); }