Databinding issue with dropdown

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Neel

    #1

    Databinding issue with dropdown

    I would like to bind a custom sql statement such as

    sSqlStmt = "SELECT PgmSchID, SessionBegDate" & " - "
    & "SessionEndDate " & " - " & "SessionTim e" & " - "
    & "SessionDay AS PgmSessions" _
    & " FROM ProgramScheduli ng WHERE PgmID
    = '" + ddlPgm1.Selecte dItem.Value + "'"

    below is my code which i am not able to bind
    OleRdr = clsDBAccess.Exe cuteReader(Comm andType.Text,
    sSqlStmt)
    ddlPgmSess1.Dat aSource = OleRdr
    ddlPgmSess1.Dat aTextField = "PgmSession s"
    ddlPgmSess1.Dat aValueField = "PgmSchID"
    ddlPgmSess1.Dat aBind()
    ddlPgmSess1.Ite ms.Insert(0, "Select
    Session")
    ddlPgmSess1.Sel ectedIndex = 0

    help me out
    Neel
Working...