Converting DataTable to List

Calling from Controller

 public ActionResult Index()
        {
            //join use
            //change view model.
            String sql = “SELECT * FROM faculties “;
            db.List(sql);
            var dt = db.List(sql);
            var model = new Faculty().List(dt);
            return View(model);
        }

Add a method to class
List<Faculty> list = new List<Faculty>();
        public List<Faculty> List(DataTable dt)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Faculty fac = new Faculty();
                fac.FacultyId = Convert.ToInt32(dt.Rows[i][“FacultyId”]);
                fac.Name = dt.Rows[i][“Name”].ToString();
                fac.Description = dt.Rows[i][“Description”].ToString();
                list.Add(fac);
            }
            return list;
        }

Leave a Reply

Your email address will not be published. Required fields are marked *