Roopa Shri

Roopa Shri

  • NA
  • 1
  • 538

Cascading 2 DDLs with sql tables in MVC without using entity

Jul 9 2016 9:45 AM
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! 
 
 
 
 
 

Answers (2)