public ActionResult HtmlExamplle()
        {
            Sp_GetEmployee_Result db = new Sp_GetEmployee_Result();

            db.EmpName = "under taker";
            //ViewBag.Employees = new SelectList(db1.Sp_GetEmployee(), "Empid", "EmpName",4);
            ViewBag.Employees12 = new SelectList(db1.employeeDetails, "Empid", "EmpName", 4);

            return(View(db));
        }
        public ActionResult Create(Sp_GetEmployee_Result obj)
        {
            System.Data.Entity.Core.Objects.ObjectResult i = db1.sp_insertEmployeeExample2(obj.EmpName, obj.EmpSalary, obj.EmpDesignation);
            int r = Convert.ToInt32(i);

            if (r > 0)
            {
                return(RedirectToAction("Index"));
            }
            else
            {
                return(View());
            }
        }