Binding dropdown selected value

Question

0

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

asp asp.net binding dropdown selected sql value

Edited 5 Years Ago by __avd: wrong forum

2

Contributors

2

Replies

22

Views

5 Years

Discussion Span

5 Years Ago

Last Post by de Source

This Question has been Answered

1

Wrap your databinding code in page_Load handler,

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

asp asp.net binding dropdown selected sql value

de Source · Answer 1 · 2013-05-09T10:49:27+00:00

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