title: sd display the details of selected item in the dropdown list from database
body: <p>This is the code i have written to display the details of employee selected from the drop down list into textboxes. I didn't get any error but the details are not getting displayed in the textboxes...</p>
  
  <pre><code>protected void  dlstemps_SelectedIndexChanged(object sender, EventArgs e)
  {
      int empno=Convert.ToInt32(dlstemps.SelectedItem.Value);
  
      SqlConnection con = new SqlConnection();
      con.ConnectionString=constr;
      SqlCommand cmd=new SqlCommand();
      cmd.CommandText = "select * from emp where empno="+empno;
      cmd.Connection = con;
      SqlDataReader reader;
      try
      {
          con.Open();
          reader = cmd.ExecuteReader();
          reader.Read();
              txtempno.Text = reader["empno"].ToString();
              txtename.Text = reader["ename"].ToString();
              txtsal.Text = reader["sal"].ToString();
              txtdeptno.Text = reader["deptno"].ToString();
              txtadress.Text = reader["adress"].ToString();
         reader.Close();
      }
      catch(Exception er)
      {
          lblerror.Text=er.Message;
      }
      finally
      {
          con.Close();
      }
  }
  </code></pre>
  
  <p>I don't understand what went wrong in this code....
  Please help me to fix it.</p>