Implement cascading (dependent) DropDownList in ASP.Net MVC using Stored Procedure

Hi,

I have 3 different table which is Table A, Table B and Table Main as in the image.

So in table main, the data should be save from the dropdown next to table in image below.

In that DropDownList, if we choose type A then, the dropdown should display the value in table A.

My question is how can i do like this using stored procedure and MVC?