protected void Button2_Click(object sender, EventArgs e) { using (PMTDBContext context = new PMTDBContext()) { IEnumerable <UsersUnderProject> usersUnderProject = context.UsersUnderProjects.ToList(); List <Join_User_Project_UserUnderProject> joinData = new List <Join_User_Project_UserUnderProject>(); foreach (var item in usersUnderProject) { Join_User_Project_UserUnderProject addData = new Join_User_Project_UserUnderProject() { //AssignedID = item.AssignedID, ProjectName = item.Project.ProjectName, UserName = item.User.UserName, DesignationName = item.User.Designation.DesignationName }; joinData.Add(addData); } GridView1.DataSource = joinData.OrderBy(a => a.ProjectName).ToList(); GridView1.DataBind(); } }
private void loadData() { using (PMTDBContext context = new PMTDBContext()) { IEnumerable <UsersUnderProject> usersUnderProject = context.UsersUnderProjects.ToList(); List <Join_User_Project_UserUnderProject> joinData = new List <Join_User_Project_UserUnderProject>(); foreach (var item in usersUnderProject) { Join_User_Project_UserUnderProject addData = new Join_User_Project_UserUnderProject() { //AssignedID = item.AssignedID, ProjectName = item.Project.ProjectName, UserName = item.User.UserName, DesignationName = item.User.Designation.DesignationName }; joinData.Add(addData); } GridView1.DataSource = joinData.ToList(); GridView1.DataBind(); } }