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 ?

Shakti Singh Dulawat · Answer

1) On your page add one drop down 2) Bind that drop down from your customer table with value filed customerID (primeryKey of your table) and text field will be Customer Name or (Display Name) 3) When user select data from the dropdown get Primery Key ID 4) Execute SQL or view using EF or some thing that you are using to get selected customer informatons