How to bind textboxes based on selection of dropdownlist??

Rajneesh Chaubey

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:-

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mukesh Nayak8y ago
Accepted answer
Hi Rajneesh,

You can use OnSelectedIndexChanged event of dropdownlist as follwing :
"server" ID="ddlEmployee" AutoPostBack="true" OnSelectedIndexChanged="ddlEmployee_SelectedIndexChanged">
Further in the event you can write following code :
protected void ddlEmployee_SelectedIndexChanged(object sender, EventArgs e)
       {
           int empID = Convert.ToInt32(ddlEmployee.SelectedValue);

           if (empID != 0)
           {
               string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
               using (SqlConnection con = new SqlConnection(constr))
               {
                   using (SqlCommand cmd = new SqlCommand("SELECT  Employee_Name, Employee_Number, Employee_State FROM Employee WHERE Employee_ID = @empID"))
                   {
                       cmd.CommandType = CommandType.Text;
                       cmd.Parameters.AddWithValue("@empID", empID);
                       cmd.Connection = con;
                       con.Open();
                       SqlDataReader reader = cmd.ExecuteReader();
                       while (reader.Read())
                       {
                           txtName.Text = reader[0].ToString();
                           txtMobile.Text = reader[1].ToString();
                           txtState.Text = reader[2].ToString();

                       }
                       reader.Close();
                       con.Close();
                   }

               }
           }
           else
           {
               txtName.Text = "";
               txtMobile.Text = "";
               txtState.Text = "";
           }
       }
You can change database field in the query above according to your database field.

Regards,
Mukesh Nayak
Rajneesh Chaubey8y ago
Got it. Thanks @Mukesh