Conevert Datatable to Object List C# ASP.Net / ASP MVC

Posted by: Vishal Kottarathil on 4:27 AM in ASP .NET, ASP MVC, ASP Snippets, MVC 4, MVC 5 1

  DataTable dt = new DataTable();
  SqlDataAdapter da = new SqlDataAdapter(command);
  da.Fill(dt);


            var list = dt.AsEnumerable()
.Skip(1)
.Select(dr =>
        new StudentListResponse
        {
            id = dr["PKStudentID"].ToString(),
            name = dr["StudentName"].ToString(),
            profile_pic = dr["PhotoURL"].ToString()
        }
        ).ToList();



Here dt is the DataTable Holds data.
And StudentListResponse object list is created.