Loading

Cascading 2 DDLs with sql tables in MVC without using entity

Roopa Shri

10y803.NET

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!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

kalu singh rao10y ago
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.
0
Ehsan Sajjad10y ago
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
0