Posted By

wrburgess on 02/13/09


Tagged

aspnet vb DropDownList


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

benrudolph


Load DropDownList from Database in ASP.NET 3.5


 / Published in: ASP
 

  1. Sub BindDropDownListDB(ByVal ddlDrop As Object, ByVal strTable As String, ByVal strValue As String, ByVal strText As String, ByVal strOrder As String, ByVal strWhere As String)
  2.  
  3. Dim objConn As New SqlConnection()
  4. Dim objCmd As New SqlCommand()
  5. Dim strSQL As String
  6.  
  7. objConn = New SqlConnection(ConfigurationManager.ConnectionStrings("[database]").ConnectionString)
  8. objCmd.Connection = objConn
  9. objCmd.Connection.Open()
  10.  
  11. strSQL = "SELECT " + strValue + " As Value1, " + strText + " As Text1 "
  12. strSQL += "FROM " + strTable + " "
  13. strSQL += "WHERE " + strWhere + " "
  14. strSQL += "ORDER BY " + strOrder + ";"
  15.  
  16. objCmd.CommandText = strSQL
  17. ddlDrop.DataSource = objCmd.ExecuteReader()
  18. ddlDrop.DataTextField = "Text1"
  19. ddlDrop.DataValueField = "Value1"
  20. ddlDrop.DataBind()
  21. ddlDrop.Items.Insert(0, New ListItem("Default Item", ""))
  22.  
  23. objConn.Dispose()
  24. objConn.Close()
  25.  
  26. End Sub

Report this snippet  

You need to login to post a comment.