Search database and display the results in textboxes

Question

Hi Every one,

 

please i am using asp.net mvc c# for my project  and i want to seach records in an sql database table using a pin number and then display the results of this seach i.e firstname ,lastname , gender etc in a another view , from where more data can be added i.e current salary , current tax , and finally inserted into another table in the same database

 i have searched articles but everything i lay my hands on only displays records in a grid or on the view itself ,  any help will be appreciated

 

Thank you