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
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!