Cascading 2 DDLs with sql tables in MVC without using entity

Question

A newbie to programming so pls bare with me... Have 2 tables in sql: tbl_Dept : DeptID DeptName tbl_Emp : EmpID EmpName DeptID (Dept ID is foreign key) I am trying to create two DDLs where in when I select DeptName from DDL1 it should show me EmpNames of the selected Dept in DDL2. How do I do this in MVC preferably without entity framework? I did it in asp.net but not sure how to do this in MVC? any help is appreciated thanks!

kalu singh rao · Answer

Dear Roopa Shri Add dll in project reference after you can use this dll reference on the your page. While you using reference that time you can access your first dll data on the page.

Ehsan Sajjad · Answer

Please take a look at the following posts: https://code.msdn.microsoft.com/Cascading-DropDownList-in-833683f9   http://www.c-sharpcorner.com/UploadFile/4d9083/creating-simple-cascading-dropdownlist-in-mvc-4-using-razor/   http://www.devcurry.com/2013/01/aspnet-mvc-cascading-dropdown-list.html