Rajneesh Chaubey

Rajneesh Chaubey

  • NA
  • 2.9k
  • 234k

How to bind textboxes based on selection of dropdownlist??

Jan 13 2018 2:05 AM
Hi I have table named tbl_Employee having columns Employee_name,Emp_ID,Emp_Salary,Emp_State,Emp_Mobile Number.
 
Now 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.
Here is the code:-
  1.   
    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"));
    }
    }
 Now 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.
 
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??
Please help me. 
 
 

Answers (2)