Member Avatar

Hi,
i am making an asp application and in code behind file i am trying to bound drop down list from tbl_teacher in which i concatenate the first and last name by this query
`string sqlStatement = "SELECT teacher_id, fname + lname AS Name FROM tbl_teacher";'
and it is working fine i got the drop down selected text as the names of the teachers and always "1" as the selected value but i want the selected value as the teacher's ID from tbl_teacher i am using following code

 if (dt.Rows.Count > 0)
            {
                ddl_TeacherName.DataSource = dt;
                ddl_TeacherName.DataTextField = "Name";
                ddl_TeacherName.DataValueField = "teacher_id";
                ddl_TeacherName.DataBind();
            }

i dont know where i am lacking. kindly explain me if you can
thanks in advance

Edited by __avd because: wrong forum
  • 2 Contributors
  • forum 2 Replies
  • 239 Views
  • 13 Hours Discussion Span
  • comment Latest Post Latest Post by de Source

Recommended Answers

Answered by __avd 1,826 in a post from

Wrap your databinding code in page_Load handler,

protected void page_load()
 {
  if(!IsPostBack)
    {
     //databinding code
      }
 }
Jump to Post

All 2 Replies

Member Avatar

Wrap your databinding code in page_Load handler,

protected void page_load()
 {
  if(!IsPostBack)
    {
     //databinding code
      }
 }
Member Avatar

Thanks avd it is working now.. thumbs up:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!