Datasource in a dropdown list

[Paul]

Hi

I have a datasource with 1 table, 100 rows, 1 column. I'm trying to
populate the drowndown list with the contents of the datasource,

dd_phys.DataSource = da.ds_phys.Tables("Physical_Office").Rows
dd_phys.DataBind()

but this populates my dropdown list with 100 "SYSTEM.DATA.DATAROW"

I can do the same thing using ths code

For loopy = 0 To da.ds_phys.Tables("Physical_Office").Rows.Count - 1


dd_phys.Items.Add(da.ds_phys.Tables("Physical_Office").Rows(loopy).Item(0))

Next

But I would prefer to get the datasource and databind to work.

Any suggestions?

 

[Guest]

Hi, Paul

Try
dd_phys.DataSource = ds_phys
'O
dd_phys.DataSource = ds_phys.Tables("Physical_Office").DefaultVie
dd_phys.DataTextField = "FieldText
dd_phys.DataValueField = "FieldValue
dd_phys.DataBind(

Bin Song, MCP

 

[Scott Hamlin]

I'm not positive, but possibly specifying the fields names that you are
binding to, like so:

lstOrig.DataSource = objDS.Tables("Orig").DefaultView
lstOrig.DataTextField = "Name"
lstOrig.DataValueField = "ID"
lstOrig.DataBind()