public ActionResult Visitors() { List <Visitors> CategoryList = new List <Visitors>(); Property p = new Property(); DataSet ds = new DataSet(); p.OnTable = "FetchVisitors"; ds = dl.FetchVisitors_sp(p); List <SelectListItem> Purposeinventory = new List <SelectListItem>(); Purposeinventory.Add(new SelectListItem { Text = "Select", Value = "" }); foreach (DataRow dr in ds.Tables[1].Rows) { Purposeinventory.Add(new SelectListItem { Text = dr["PName"].ToString(), Value = dr["PId"].ToString() }); } ViewBag.Purposeinventory = new SelectList(Purposeinventory, "Value", "Text"); try { foreach (DataRow item in ds.Tables[0].Rows) { Visitors m = new Visitors(); m.VId = item["VId"].ToString(); m.VName = item["VName"].ToString(); m.Phone = item["Phone"].ToString(); m.Date = item["Date"].ToString(); m.IDCard = item["IDCard"].ToString(); m.InTime = item["InTime"].ToString(); m.OutTime = item["OutTime"].ToString(); m.NOP = item["NOP"].ToString(); m.PId = item["PId"].ToString(); m.PName = item["PName"].ToString(); m.Attachment = item["Attachment"].ToString(); m.AddedBy = item["AddedBy"].ToString(); m.Note = item["Note"].ToString(); m.IsActive = item["IsActive"].ToString(); CategoryList.Add(m); } ViewBag.CategoryList = CategoryList; } catch (Exception e) { } return(View()); }