Populating DropDownList Items

[Joe Delphi]

Hi,

I am trying to populate dropdownlist items from the results of a
database query. My code looks like this:

Private Sub PopulateSubByBox(ByVal DBConn As SqlConnection)
Dim DBComm As New SqlCommand
Dim DBReader As SqlDataReader
DBComm.Connection = DBConn
DBComm.CommandText = "SELECT * FROM PERSONNEL ORDER BY PERSONNEL"
DBReader = DBComm.ExecuteReader()

'Now Populate the ddlstSubBy.Items with the results from the DBReader - '
ddlstSubBy.Items(0) = DBReader.GetString(0)
End Sub

I get an error on the last line that ddlstSubBy.Items is a Read-Only
property.

So if it is Read-Only, how do I populate it?
JD

[Karl Seguin]

(A) you should use items.Add()

(b) you should really use DataBinding

ddlstSubBy.DataSource = DBReader
ddlstSubBy.DataTextField = "ColumnName to Display"
ddlstSubBy.DataValueField = "ColumnValue"
ddlstSubBy.DataBind()
(c) you should dispose of your connection, command and close your reader.
Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"Joe Delphi" <delphi561@no****@cox.net> wrote in message
news:8uVwe.3745$Qo.766@fed1read01...

Hi,

I am trying to populate dropdownlist items from the results of a
database query. My code looks like this:

Private Sub PopulateSubByBox(ByVal DBConn As SqlConnection)
Dim DBComm As New SqlCommand
Dim DBReader As SqlDataReader
DBComm.Connection = DBConn
DBComm.CommandText = "SELECT * FROM PERSONNEL ORDER BY PERSONNEL"
DBReader = DBComm.ExecuteReader()

'Now Populate the ddlstSubBy.Items with the results from the DBReader -
'
ddlstSubBy.Items(0) = DBReader.GetString(0)
End Sub

I get an error on the last line that ddlstSubBy.Items is a Read-Only
property.

So if it is Read-Only, how do I populate it?
JD