title: How to bind textboxes based on selection of dropdownlist in asp.net?
body: <p>I have table named tbl_Employee with columns Employee_name,Emp_ID,Emp_Salary,Emp_State,Emp_Mobile Number.</p>
  
  <p>I have an aspx page where I used a dropdownlist and binded with the dtabase which when we click we get all Employee name from that dropdownlist.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
      if (!this.IsPostBack)
      {
          string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
          using (SqlConnection con = new SqlConnection(constr))
          {
              using (SqlCommand cmd = new SqlCommand("SELECT EmpId, Name FROM tblEmployee"))
              {
                  cmd.CommandType = CommandType.Text;
                  cmd.Connection = con;
                  con.Open();
                  ddlEmployee.DataSource = cmd.ExecuteReader();
                  ddlEmployee.DataTextField = "Name";
                  ddlEmployee.DataValueField = "EmpId";
                  ddlEmployee.DataBind();
                  con.Close();
  
              }
          }
          ddlEmployee.Items.Insert(0, new ListItem("--Select Employee--", "0"));
      }
  }
  </code></pre>
  
  <p>On the same page I have 3 textbox named txtname, txtMobile, and txtState. So I want to bind the value from database to those textbox on selection of particular employee to that drop downlist.</p>
  
  <p>For Ex. If have selected Empname 'ABC' those 3 textboxes should be bind with the value of ABC name, ABC mobile and his State.
  How do I do that? Do I have to use Jquery or javascript?</p>