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
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.
dlherren
Member
245 Points
49 Posts
Drop down binding issue
Aug 12, 2003 02:55 PM|LINK
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 SubThanks!joteke
All-Star
46284 Points
6896 Posts
ASPInsiders
MVP
Re: Drop down binding issue
Aug 12, 2003 03:05 PM|LINK
Teemu Keiski
Finland, EU
dlherren
Member
245 Points
49 Posts
Re: Drop down binding issue
Aug 12, 2003 03:27 PM|LINK