I want to display the 'company added jobs' in a table on the selected index change of country dropdown. but when I pass values in dataset to list,
it displays the error
Cannot implicitly convert type 'System.Data.DataSet' to 'System.Collections.Generic.List
How can I convert dataset values to list?
model class
- public class company_add_jobs
- {
- public int pid { get; set; }
- public string Job_Name { get; set; }
- public string Job_Description { get; set; }
- public string Job_Type { get; set; }
- public string Qualification { get; set; }
- public string Salary { get; set; }
- public string Vaccancy { get; set; }
- public DataSet display{ get; set; }
-
- [Display(Name = "Company")]
- public int cid { get; set; }
- public string Company_Name { get; set; }
- public List listcompany { get; set; }
- public IEnumerable companylistitems
- {
- get
- {
- return new SelectList(listcompany, "cid", "Company_Name");
- }
- }
- }
controller.cs
- [HttpGet]
- public ActionResult selectcompany()
- {
- company_add_jobs c = new company_add_jobs();
- DataSet dt = db.getcompany();
- c.listcompany = dt;
- c.cid = c.listcompany.First().cid;
- c.Company_Name = c.listcompany.First().Company_Name;
- return View(c);
- }
- [HttpPost]
- public ActionResult selectcompany(company_add_jobs s)
- {
- DataSet dt = db.getcompany();
- s.listcompany = dt;
- var emp = s.listcompany.Where(e => e.cid == s.cid).FirstOrDefault();
- s.cid = emp.cid;
- DataSet ds = db.ddapplyjobs(s);
- s.display = ds;
- return View(s);
- }
dbconnection.cs
- public DataSet getcompany()
- {
- SqlCommand cmd = new SqlCommand("select * from company_regn", con);
- SqlDataAdapter da = new SqlDataAdapter(cmd);
- DataSet dt = new DataSet();
- da.Fill(dt);
- return dt;
- }