public ActionResult Dosage() { List <PharmacyDosage> CategoryList = new List <PharmacyDosage>(); Property p = new Property(); DataSet ds = new DataSet(); p.OnTable = "FetchPharmacyDosage"; ds = dl.FetchPharmacyDosage_sp(p); List <SelectListItem> Categoryinventory = new List <SelectListItem>(); Categoryinventory.Add(new SelectListItem { Text = "Select", Value = "" }); foreach (DataRow dr in ds.Tables[1].Rows) { Categoryinventory.Add(new SelectListItem { Text = dr["CategoryName"].ToString(), Value = dr["CategoryId"].ToString() }); } ViewBag.Categoryinventory = new SelectList(Categoryinventory, "Value", "Text"); try { foreach (DataRow item in ds.Tables[0].Rows) { PharmacyDosage m = new PharmacyDosage(); m.DosageId = item["DosageId"].ToString(); m.DName = item["DName"].ToString(); m.CategoryId = item["CategoryId"].ToString(); m.CategoryName = item["CategoryName"].ToString(); m.AddedBy = item["AddedBy"].ToString(); m.IsActive = item["IsActive"].ToString(); CategoryList.Add(m); } ViewBag.CategoryList = CategoryList; } catch (Exception e) { } return(View()); }