populate

[d2005]

want to populate a drop down list
my code doesnt seem to work, is it the fill method is a problem??

in my table i have just 2 columns with only one column name
table name = tb_area
columns = area_code, area_name

i just want to display area name.

Private ddlArea As New DropDownList
Private daArea As New SqlDataAdapter

.................

daArea.SelectCommand = New SqlCommand("SELECT * from tb_area", oSQLConn)
ddl_area.Fill(ddlArea)

ddlArea.DataSource = daArea.Tables(0)
ddlArea.DataBind()
oSQLConn.Close()

 

[Blokz]

You need to set the .DataTextField of the dropdownlist to the column you want to display.

Such as:
ddlArea.DataTextField = "area_name"

Blokz