How to select customer name frim to dropdown list and displa

Question

Hi frnds How to display customer info from to select dropdown and display table using data base approach in mvc I have a 2 tables customer and Customer Info --------------------------------–----------------------------------- ID Name City Designation --------------------------------------------------------------------- --------------------------------------------------------------------- 2.Customer Info --------------------------------------------------------------------- ID Name ---------------------------------------------------------------------- --------------------------------------------------------------------- I need to create like this type of form using data base approach Here i want to create page where if i select name from to dropdown list and submit details should be display all details ?