Drop down binding issue RSS

• • Reply
  

  dlherren

  Member

  245 Points

  49 Posts

  Drop down binding issue

  Aug 12, 2003 02:55 PM|LINK

  Hiya, I am trying to bind a drop down list to a database, but I am having a little problem. When I view the page the drop down list is filled with "System.Data.DataRowView" instead of the values in the database. I am sure it is an easy fix, but I dont see it. Below is my code snippet:

  Sub BindDropDown()
              Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\SAFE\Safe.md"& _
      "b"
              Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)
  
  
              Dim queryString As String = "SELECT [Projects].[ProjectID] FROM [Projects]"
  
  
              Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
              dbCommand.CommandText = queryString
              dbCommand.Connection = dbConnection
  
  
              Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter
  
  
              dataAdapter.SelectCommand = dbCommand
              Dim dataSet As System.Data.DataSet = New System.Data.DataSet
  
  
              dataAdapter.Fill(dataSet)
  
  
              DropDownList1.DataSource = dataSet
              DropDownList1.DataBind()
  
  
          End Sub

  Thanks!
• • Reply
  

  joteke

  All-Star

  46284 Points

  6896 Posts

  ASPInsiders

  MVP

  Re: Drop down binding issue

  Aug 12, 2003 03:05 PM|LINK

  You need to specify the database fields into DataTextField and DataValueField properties of the DDL so that it knows what to read as displayed items (text) and what as their values.
  Thanks,
  
  Teemu Keiski
  Finland, EU
  
• • Reply
  

  dlherren

  Member

  245 Points

  49 Posts

  Re: Drop down binding issue

  Aug 12, 2003 03:27 PM|LINK

  Ah, that fixed it. Thank you much.