Comments by vineeth raju (Top 66 by date)

Still its not working. So i used

location.href = '@Url.Action("LoadNew","ManageEmployeNumber")?drop_compny=' + drop_compny + '&drop_survey=' + drop_survey + '';

----------------------------------------------------

[HttpGet]
public ActionResult LoadNew(int drop_compny, int drop_survey)
{

List<tblEmployeetarget> lis_emp_targt = new List<tblEmployeetarget>();
lis_emp_targt = db.tblEmployeetargets.Where(s => s.COMP_ID == drop_compny && s.SURVEY_ID == drop_survey).ToList();

List<tblDepartment> lis_dept = new List<tblDepartment>();
lis_dept = db.tblDepartments.Where(s => s.CompID == drop_compny).ToList();

var joined = (from dep in lis_dept
join emp in lis_emp_targt
on dep.DeptID equals emp.DEPT_ID // join on some property
//into grouping
//from emp in grouping.DefaultIfEmpty()
select new mang_emp { tblDepartment = dep, tblEmpTarget = emp }).ToList();


TempData["drop_compny"] = drop_compny;
TempData["drop_survey"] = drop_survey;

TempData["lis_dept"] = joined;

return RedirectToAction("Load");
}