How to get data from SQL table to multiple text boxes when I select value in a dropdown list

See more:

C#

Dear Friends,

I am a beginner in asp.net. c#

I am working on a project. I have a form with a dropdown list(List of Employees) with value from SQL Table.(TableName- EmployeeDB)

I want to get the mobile number, father name, designation, employee status from SQL Table(EmployeeDB) to 4 Text Boxes when i select a EmployeeName from dropdownlist1. (example: Employee Name. When i Select Employee Name his mobile number, father name, designation, employee status to be shown in TextBox1,TextBox2,TextBox3,TextBox4.

Please help with a simple code for this issue.

Your code will help me learn.

What I have tried:

Just created a Form with dropdown and text boxes.

autopostback on dropdownlist1